Re: 9iAS and Oracle Database on same server, LINUX

[Ray Feighery]

Sushant

This can be done, but you must use separate $ORACLE_HOMEs. I don't think it
is recommend for production,  but I have set it up in our development
environment.

You are most likely getting a problem with your extproc connection. The iAS
configuration program (wtacca) uses extproc to export the user list from the
origin database and also to import into the icache database.

Check your listener.ora and _both_ (in each $ORACLE_HOME) your tnsnames.ora
files. If you just have one listener running, make it the listener for the
origin database. This listener.ora will need to contain listener information
for both databases, as you will need to be able to make extproc connections
to both databases.

There is quite a bit of information on this on Metalink (if you can get in),
mostly people with similar problems. Mail me if you have continuing
problems.

Ray

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 1:55 PM


> Hi DBAs,
>
> Did anybody install and configure data cache of 9iAS
> on the same database server.
>
> I get an error saying that "Unable to import user
> information in the cache from Origin database"
>
> If anybody has sucessfully installed and configured
> Oracle 9iAS cache, can please help me out..
>
> Thanks in advance...
>
> Sushant
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Feighery
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to check online and archived redo log files corruption

[Chuan Zhang]

Hi DBAs,
 
 
As I know in Oracle 8.0.6, at least, we can set up 
log_block_checksum initialiazation parameter to make sure archived log files are 
clean. But in Oracle 8.1.5, this parameter is obsolote.  Are there any 
ways to make sure my archived log files can be used for recovery?
 
Thanks for your help.
 
Chuan
 
 
   

Re: What or who is PUBLIC?

[Joseph S. Testa]

I beg to differ, look at sql.bsq, 

quote: 
create role public
/


its right after the create user sys 


joe
 

"Maser, Donna (SEA)" wrote:
> 
> Ron,
> 
> PUBLIC is not actually a ROLE, it is a 'user group'.
> It always is available to ALL users in a database.
> If used in reference to a synonym, privilege, role,
> or subroutine (variable, constant, function, procedure)
> of a package it means the synonym, privilege, role,
> or subroutine is accessible to every database user.
> 
> The other use of public is in reference to a rollback segment
> within a parallel server database, where public means that
> any instance requiring a rollback segment can use it .
> 
> Donna
> 
> -Original Message-
> Sent: Thursday, March 08, 2001 2:22 PM
> To: Multiple recipients of list ORACLE-L
> 
> Can anyone point me to a paper or explanation of the Oracle role? called
> PUBLIC?  How do you manage permissions for PUBLIC?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> The information contained in this email is intended for the
> personal and confidential use of the addressee only. It may
> also be privileged information. If you are not the intended
> recipient then you are hereby notified that you have received
> this document in error and that any review, distribution or
> copying of this document is strictly prohibited. If you have
> received  this communication in error, please notify Celltech
> Group immediately on:
> 
> +44 (0)1753 534655, or email '[EMAIL PROTECTED]'
> 
> Celltech Group plc
> 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
> 
> Registered Office as above. Registered in England No. 2159282
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maser, Donna  (SEA)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Corrupted dbf files ?

[sinardyxing]

Hi guys,

I exported my database 8.1.6 on Solaris 2.7 with full = y,
can import my full.dmp if dbf file corrupted ?

This is not emergency just for testing how usefull my exported file..



Thank You

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

9iAS and Oracle Database on same server, LINUX

[Oracle DBA]

Hi DBAs,

Did anybody install and configure data cache of 9iAS
on the same database server.

I get an error saying that "Unable to import user
information in the cache from Origin database"

If anybody has sucessfully installed and configured
Oracle 9iAS cache, can please help me out..

Thanks in advance...

Sushant

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Netbackup and RMAN

[Ravindra Basavaraja]

We are planning to use Veritas Netbackup to backup our Oracle Database(OPS).
I am not sure whether we need to use the combination of Netbackup and RMAN
to take the backup/recovery or just Netbackup is sufficient to take the
backup.

Can anyone tell how this combination works.

Should I have Both or just Netbackup is sufficient for the Oracle backup and
receovery.

thanks

Ravindra

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ScanMail Message: To Sender, sensitive content found and

[Troiano, Paul (CAP, GEFA)]

I guess that would be me...

Looks like our exchange server's address (the LAK means Lakewood, CO and I'm the only 
one here on the list). GE does scan is done at the corporate level. I don't usually 
pay any attention to it. This is the first time I've heard of anything like this. GE 
Financial Assurance is no
longer part of GE Capital.

- Paul Troiano

-Original Message-
From:   John Dailey [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: ScanMail Message: To Sender, sensitive content 
found and

I agree completely Joe this is pathetic.

Since it's GE Capital, I wonder if they scan outgoing mail for crappy
interest rates on new loans??  I doubt it...



-Original Message-
Testa
Sent: Thursday, March 08, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L


I don't know but i vote for them to be removed from the list, when i
work for a compnay that starts screening my email for me, i'll quit
thats for sure.

the place i work for, i know the admins and they dont do that kind of
garbage.

joe
[EMAIL PROTECTED] wrote:
>
> OK, who have we got who works at Ge Capital?
>
> Dick Goulet
>
> Reply Separator
> Author: System Attendant <[EMAIL PROTECTED]>
> Date:   3/8/2001 2:22 PM
>
> Trend SMEX Content Filter has detected sensitive content.
>
> Place = Multiple recipients of list ORACLE-L; ; ; 
[EMAIL PROTECTED]
> Sender = [EMAIL PROTECTED]
> Subject = Re:RE: Life in New England
> Delivery Time = March 08, 2001 (Thursday) 12:22:24
> Policy = Sexual Discrimination
> Action on this mail = Quarantine message
>
> Warning message from administrator:
> Notice: A message you sent appears to have violated GE Financial 
Assurance
email
> policies for inappropriate language or content and may not have been
received by
> the recipient.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing 
Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dailey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: What or who is PUBLIC?

[Molina, Gerardo]

I would add that it is different from other roles in that you cannot revoke
it from a user.  Everybody has public role automatically.  There may be
other idiosyncracies about PUBLIC as well.

HTH
Gerardo

-Original Message-
Sent: Thursday, March 08, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


public, a role built when the create database statement is executed (its
in sql.bsq).

what else would u like to know about it?

joe
"Smith, Ron L." wrote:
> 
> Can anyone point me to a paper or explanation of the Oracle role? called
> PUBLIC?  How do you manage permissions for PUBLIC?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Molina, Gerardo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: What or who is PUBLIC?

[Maser, Donna (SEA)]

Ron,

PUBLIC is not actually a ROLE, it is a 'user group'.
It always is available to ALL users in a database.
If used in reference to a synonym, privilege, role, 
or subroutine (variable, constant, function, procedure) 
of a package it means the synonym, privilege, role, 
or subroutine is accessible to every database user.


The other use of public is in reference to a rollback segment 
within a parallel server database, where public means that 
any instance requiring a rollback segment can use it .

Donna 




-Original Message-
Sent: Thursday, March 08, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L


Can anyone point me to a paper or explanation of the Oracle role? called
PUBLIC?  How do you manage permissions for PUBLIC?

Ron Smith
Database Administration
[EMAIL PROTECTED]


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ScanMail Message: To Sender, sensitive content found and

[John Dailey]

I agree completely Joe this is pathetic.

Since it's GE Capital, I wonder if they scan outgoing mail for crappy
interest rates on new loans??  I doubt it...



-Original Message-
Testa
Sent: Thursday, March 08, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L


I don't know but i vote for them to be removed from the list, when i
work for a compnay that starts screening my email for me, i'll quit
thats for sure.

the place i work for, i know the admins and they dont do that kind of
garbage.

joe
[EMAIL PROTECTED] wrote:
>
> OK, who have we got who works at Ge Capital?
>
> Dick Goulet
>
> Reply Separator
> Author: System Attendant <[EMAIL PROTECTED]>
> Date:   3/8/2001 2:22 PM
>
> Trend SMEX Content Filter has detected sensitive content.
>
> Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
> Sender = [EMAIL PROTECTED]
> Subject = Re:RE: Life in New England
> Delivery Time = March 08, 2001 (Thursday) 12:22:24
> Policy = Sexual Discrimination
> Action on this mail = Quarantine message
>
> Warning message from administrator:
> Notice: A message you sent appears to have violated GE Financial Assurance
email
> policies for inappropriate language or content and may not have been
received by
> the recipient.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dailey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: What or who is PUBLIC?

[Joseph S. Testa]

public, a role built when the create database statement is executed (its
in sql.bsq).

what else would u like to know about it?

joe
"Smith, Ron L." wrote:
> 
> Can anyone point me to a paper or explanation of the Oracle role? called
> PUBLIC?  How do you manage permissions for PUBLIC?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

What or who is PUBLIC?

[Smith, Ron L.]

Can anyone point me to a paper or explanation of the Oracle role? called
PUBLIC?  How do you manage permissions for PUBLIC?

Ron Smith
Database Administration
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ScanMail Message: To Sender, sensitive content found and

[Joseph S. Testa]

I don't know but i vote for them to be removed from the list, when i
work for a compnay that starts screening my email for me, i'll quit
thats for sure.

the place i work for, i know the admins and they dont do that kind of
garbage.

joe
[EMAIL PROTECTED] wrote:
> 
> OK, who have we got who works at Ge Capital?
> 
> Dick Goulet
> 
> Reply Separator
> Author: System Attendant <[EMAIL PROTECTED]>
> Date:   3/8/2001 2:22 PM
> 
> Trend SMEX Content Filter has detected sensitive content.
> 
> Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
> Sender = [EMAIL PROTECTED]
> Subject = Re:RE: Life in New England
> Delivery Time = March 08, 2001 (Thursday) 12:22:24
> Policy = Sexual Discrimination
> Action on this mail = Quarantine message
> 
> Warning message from administrator:
> Notice: A message you sent appears to have violated GE Financial Assurance email
> policies for inappropriate language or content and may not have been received by
> the recipient.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Problems Killing Sessions

[Mitchell]

This is internal oracle process I think.
Check used_ublk from v$transaction before killing or maybe big rollback will
going to hang everything

Mitchell



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 1:20 PM


>
>
>
>
>  Friends :
>
>  We have a problem for kill a session :
>
>  We did  :
>
>  select * from v$session  and got the result bellow :
>
>  USERNAME  SIDSERIAL# STATUS   SERVER
>  -- -- --  -
>  1  1 ACTIVE   DEDICATED
>  2  1 ACTIVE   DEDICATED
>  3  1 ACTIVE   DEDICATED
>  4  1 ACTIVE   DEDICATED
>  5  1 ACTIVE   DEDICATED
>  USER0135  55317 ACTIVE   DEDICATED
>
>
>  We applyed the command :
>
>  alter system kill session '35,55317';
>  alter system kill session '35,55317'
>  *
>  ERROR at line 1:
>  ORA-00030: user session ID does not exist
>
>  and also, by Instance Manager we finished with kill immediate
>
>  but the session is showed in the Instance Manager and v$session ..
>
>  Why ?
>
>
>  Eriovaldo do Carmo Andrietta
>  [EMAIL PROTECTED]
>  Limeira/SP - Brasil
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eriovaldo do Carmo Andrietta
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT, i'Messing with the scanner :Re: ScanMail Message: To Sender,

[Joseph S. Testa]

sex harrass bite F*$%

etc.

lets see if that gets screened
-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

oracle 8i NT and Win98

[Leyden, Joseph]

- Oracle 8i Personal Edition -
Has anyone downloaded it from OTN?

When installing NT,
  I got stopped on "Credential Retreival Failed"

When installing on Windows ME,
  It said something about the SOURCE and DESTINATION
  incorrect.

anybody had similar problems?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00922 on create table...

[Jacques Kilchoer]

Title: RE: ORA-00922 on create table...





> -Original Message-
> From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]
> Sent: jeudi, 8. mars 2001 12:37
> 
> I used to make many comma errors like that until I finally
> adopted a coding standard that has virtually eliminated
> them, as well as many others.  The simple rule is "Vertical,
> Preferably Left, but Always Vertical", meaning all my SQL
> and PL/SQL is formatted so that nothing of importance ends
> up "ragged right".



While I agree that Mr. Applewhite's coding practices can make it easier to find syntax errors, I nevertheless want to present an alternative approach to coding. :)

Here's a sample from the 2000 "Obfuscated C contest". (For those of you that are unfamiliar with it, the Obfuscated C contest is a contest where people try to write cryptic, yet valid and useful, C programs.)

http://www.ioccc.org/2000/anderson.c


Believe it or not, the program at the above link a valid C program that translates ASCII text into semaphore code.
(you can read a description of the program here:
http://www.ioccc.org/2000/anderson.hint )


My apologies for the off-topic comment, but I thought some computer humour might be approciated. Of course, what does this say about me that I find these kind of contests interesting? :)

--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: Which account do I need to change password besides system,sys

[Shreter, Hilary]

Careful!! You need to use the SAME password for APPS and APPLSYS.  
Also (maybe new in 11i?): p. 171 of the Admin manual says that ALL the
schema passwords have to be the same.
I'm referring to the section "Change Oracle Apps Password" in Ch. 6 of
"Maintaining Oracle Applications Rel 11i" part A83525-01.

I'm just starting on 11i myself else I'd know the answers for sure instead
of quoting you the manual!  Good luck to you and the system. - Hilary.

-Original Message-
Sent: Thursday, March 08, 2001 3:01 AM
To: Multiple recipients of list ORACLE-L
and


Hi,

We are about to implement the HRMS 11I Applications.  

The password for the following accounts has to be changed : SYS, SYSTEM,
APPS (for HRMS 11I Applications)

Is there any account that I've missed out ? Please advise. Thanks.

Regds,
ChorLing
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shreter, Hilary
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: ScanMail Message: To Sender, sensitive content found

[dgoulet]

Most likely, I'm more sorry for the person on the receiving end.  While I
understand companies wanting to keep an eye on e-mail this sure looks like
censorship to me.  Geuss I'll never consider working there.

Dick Goulet

Reply Separator
Author: "Holman; Rodney" <[EMAIL PROTECTED]>
Date:   3/8/2001 12:11 PM

Dick,
>From reading their auto response, You probably need to add more @#$@&*() to
some of the expletives used.  I suspect their content filter is picking up
on the ones that start with "F" and filtering your message as containing
"Sexually Harassing" content.

Rodd

-Original Message-
Sent: Thursday, March 08, 2001 7:49 PM
To: Multiple recipients of list ORACLE-L


OK, who have we got who works at Ge Capital?

Dick Goulet

Reply Separator
Author: System Attendant <[EMAIL PROTECTED]>
Date:   3/8/2001 2:22 PM

Trend SMEX Content Filter has detected sensitive content.

Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = [EMAIL PROTECTED]
Subject = Re:RE: Life in New England
Delivery Time = March 08, 2001 (Thursday) 12:22:24
Policy = Sexual Discrimination
Action on this mail = Quarantine message

Warning message from administrator:
Notice: A message you sent appears to have violated GE Financial Assurance
email
policies for inappropriate language or content and may not have been
received by
the recipient.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ScanMail Message: To Sender, sensitive content found and

[Jamadagni, Rajendra]

Our Firewall server reports two domains (I own them), which are * just
registered * and not even accessible, as blocked because it contains
"Partial Nudity". 

So much for AI based content filtering 

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00922 on create table...

[Jack C. Applewhite]

Pat,

I used to make many comma errors like that until I finally
adopted a coding standard that has virtually eliminated
them, as well as many others.  The simple rule is "Vertical,
Preferably Left, but Always Vertical", meaning all my SQL
and PL/SQL is formatted so that nothing of importance ends
up "ragged right".

For me, at least, it's so much easier to scan vertically and
see a pattern anomaly - such as missing punctuation - than
to scan left and right on the "ragged right".  "Vertical
Left" also helps keep all the ||s straight when I'm
concatenating stuff.

I'd have formatted your Create Table statement like this,
which allows my old eyes to much more easily see if I've
left off a comma, paren or semicolon:

Create Table Catrec
( Abstract  VARCHAR2(3000)
, Add_DtVARCHAR2(32)
, Altti VARCHAR2(200)
, AuVARCHAR2(1504)
...
, Year  VARCHAR2(32)
)
;

Going a little farther with this standard has me using the
following kinds of formatting:

Select t1.Col1 c1
 , t2.Another_Col2 c2
 , t2.Yet_Another_Col3 c3
>From   Table1  t1
 , Big_Old_Table2  t2
Where  t1.Col1  = 3
Andt2.The_Other_Col = t1.My_Col
Andt2.Col3  = 'NOPE'
;

Actually, this Select statement tries to do some "Vertical
Right" and "Vertical Middle" formatting as well.  Any
"Verticalizing" helps!

If
Then  
ElsIf 
Then  
Else  
End If
;

While 
Loop
  
End Loop
;

I find this makes for easy-to-read, therefore
easier-to-maintain, code.  Anyway, I'll climb down off my
soapbox now - I've evangelized enough.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Gorden-Ozgul, Patricia E
Sent: Thursday, March 08, 2001 10:48 AM
To: Multiple recipients of list ORACLE-L
I'll bet I'm doing something really stupid here.
Can anyone find my error?

I'm getting the following error on execution:
create table catrec (
*

ERROR at line 1:
ORA-00922:  missing or invalid option

huh?


create table catrec (
abstractVARCHAR2(3000),
add_dt  VARCHAR2(32),
altti   VARCHAR2(200),
au  VARCHAR2(1504),
...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Max Extents Error

[Jyoti]

Also you can  resolve by , 
Alter  storage(maxextents unlimited);

-Original Message-
Sent: Thursday, March 08, 2001 11:49 AM
To: Multiple recipients of list ORACLE-L

Pardon my syntax. Tim's is correct.

--- Tim Sawmiller <[EMAIL PROTECTED]> wrote:
> Check the maxextents value assigned to the table:
>
> select max_extents from dba_tables where table_name = 'your_table_name';
>
> Next, see how many extents the table is actually using:
>
> select count(*) from dba_extents where table_name = 'your_table_name';
>
> I'll bet the numbers are equal.  If so:
>
> Alter your_table_name storage(maxextents 999);
>
> where 999 is equal to a number larger than that obtained in the earlier
> scripts._
>
> >>> [EMAIL PROTECTED] 03/08/01 02:00PM >>>
> Hi,
>
> I have a table which consists of Long Raw column in addition to other
> columns of Number and Varchar2 datatypes.
>
> I have the datafile size set to 2GB. The average length of the messages
> goes up to 100M, sometimes more than that.
>
> I have now added three datafiles to that tablespace each greater than
> the first datafile. But I still keep getting the
> ORA-01631 Max extents reached for table "A" error.
>
> What do I do resolve this error?
>
> I am using 8K as the DB block size on SOlaris with Oracle 816. It is not
> a prod environment instead a dev environment.
>
> Thanks
> Sanjay
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Sawmiller
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jyoti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ScanMail Message: To Sender, sensitive content found and

[Holman, Rodney]

Dick,
>From reading their auto response, You probably need to add more @#$@&*() to
some of the expletives used.  I suspect their content filter is picking up
on the ones that start with "F" and filtering your message as containing
"Sexually Harassing" content.

Rodd

-Original Message-
Sent: Thursday, March 08, 2001 7:49 PM
To: Multiple recipients of list ORACLE-L


OK, who have we got who works at Ge Capital?

Dick Goulet

Reply Separator
Author: System Attendant <[EMAIL PROTECTED]>
Date:   3/8/2001 2:22 PM

Trend SMEX Content Filter has detected sensitive content.

Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = [EMAIL PROTECTED]
Subject = Re:RE: Life in New England
Delivery Time = March 08, 2001 (Thursday) 12:22:24
Policy = Sexual Discrimination
Action on this mail = Quarantine message

Warning message from administrator:
Notice: A message you sent appears to have violated GE Financial Assurance
email
policies for inappropriate language or content and may not have been
received by
the recipient.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Max Extents Error

[Jacques Kilchoer]

Title: RE: Max Extents Error





>-Original Message-
>From: Sanjay Kumar [mailto:[EMAIL PROTECTED]]
>Sent: jeudi, 8. mars 2001 11:01
>
>I have a table which consists of Long Raw column in addition to other columns of Number and Varchar2 datatypes.
> 
>I have the datafile size set to 2GB. The average length of the messages
>goes up to 100M, sometimes more than that.
> 
>I have now added three datafiles to that tablespace each greater
>than the first datafile. But I still keep getting the
>ORA-01631 Max extents reached for table "A" error.
> 
>What do I do resolve this error?
>
>I am using 8K as the DB block size on SOlaris with Oracle 816
>It is not a prod environment instead a dev environment.


Check the max_extents for the table:
select extents, max_extents
from dba_segments
where owner = 'table_owner_name' and segment_name = 'table_name'
and segment_type = 'TABLE' ;


You will have to change the max_extents on the table with the SQL command alter table, e.g.
alter table owner.name storage (maxextents new_value) ;



But before you do so, you may want to ask yourself - is there a reason that the current "maxextents" value was chosen? Should some rows from the table be archived deleted? Of course, since this is a development environment perhaps it's not as important to know the answers to those questions.

--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: ORA-00922 on create table...

[Jyoti]

Aren't you missing a comma on "m099 VARCHAR2(104) " line?
Jyoti


-Original Message-
Patricia E
Sent: Thursday, March 08, 2001 8:48 AM
To: Multiple recipients of list ORACLE-L


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159






-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 11:42 AM
To: [EMAIL PROTECTED]
Experts,

Solaris 2.6
RDBMS EE 8.1.5.0.0

I'll bet I'm doing something really stupid here.
Can anyone find my error?

I'm getting the following error on execution:
create table catrec (
*

ERROR at line 1:
ORA-00922:  missing or invalid option

huh?


create table catrec (
abstractVARCHAR2(3000),
add_dt  VARCHAR2(32),
altti   VARCHAR2(200),
au  VARCHAR2(1504),
authVARCHAR2(504),
au_sx   VARCHAR2(32),
callVARCHAR2(56),
call_lc_sortVARCHAR2(56),
catno   VARCHAR2(32),
check_in_note   VARCHAR2(3000),
claim_mode  VARCHAR2(32),
claim_mode_nm   VARCHAR2(32),
claim_period_days   VARCHAR2(32),
coden   VARCHAR2(32),
collVARCHAR2(504),
contentsVARCHAR2(3000),
corpVARCHAR2(1504),
cpv VARCHAR2(32),
dauth   VARCHAR2(232),
day_month   VARCHAR2(32),
day_weekVARCHAR2(32),
display_ti  VARCHAR2(504),
disp_isbn_order VARCHAR2(56),
doc VARCHAR2(32),
dse3VARCHAR2(32),
dse4VARCHAR2(32),
dse5VARCHAR2(32),
edtnVARCHAR2(232),
enum_type3  VARCHAR2(32),
enum_type4  VARCHAR2(32),
enum_type5  VARCHAR2(32),
exclude_dates   VARCHAR2(32),
holdingsVARCHAR2(1000),
include_dates   VARCHAR2(32),
isbnVARCHAR2(56),
issnVARCHAR2(32),
issue_enum_type VARCHAR2(32),
key_numbers VARCHAR2(56),
kw  VARCHAR2(56),
leader  VARCHAR2(56),
level_  VARCHAR2(32),
m008VARCHAR2(40),
m010VARCHAR2(32),
m011VARCHAR2(32),
m017VARCHAR2(56),
m018VARCHAR2(56),
m019VARCHAR2(32),
m027VARCHAR2(32),
m035VARCHAR2(56),
m037VARCHAR2(56),
m040VARCHAR2(32),
m041VARCHAR2(32),
m042VARCHAR2(32),
m049VARCHAR2(200),
m060VARCHAR2(56),
m069VARCHAR2(56),
m070VARCHAR2(56),
m080VARCHAR2(56),
m082VARCHAR2(56),
m086VARCHAR2(32),
m088VARCHAR2(56),
m090VARCHAR2(56),
m091VARCHAR2(56),
m092VARCHAR2(56),
m096VARCHAR2(56),
m098VARCHAR2(56),
m099VARCHAR2(104)
m100_expVARCHAR2(1504),
m110_expVARCHAR2(1504),
m111VARCHAR2(1504),
m111_expVARCHAR2(1504),
m130VARCHAR2(200),
m130_expVARCHAR2(200),
m210VARCHAR2(56),
m211VARCHAR2(200),
m212VARCHAR2(200),
m222VARCHAR2(200),
m240VARCHAR2(200),
m243VARCHAR2(200),
m247VARCHAR2(200),
m265VARCHAR2(200),
m310VARCHAR2(200),
m321VARCHAR2(56),
m330VARCHAR2(56),
m331VARCHAR2(56),
m351VARCHAR2(56),
m362VARCHAR2(56),
m410VARCHAR2(200),
m411VARCHAR2(200),
m440VARCHAR2(200),
m490VARCHAR2(200),
m501VARCHAR2(504),
m502VARCHAR2(504),
m503VARCHAR2(504),
m504VARCHAR2(504),
m505VARCHAR2(2000),
m506VARCHAR2(504),
m512VARCHAR2(504),
m513VARCHAR2(504),
m515VARCHAR2(504),
m520VARCHAR2(504),
m521VARCHAR2(504),
m522VARCHAR2(504),
m523VARCHAR2(504),
m524VARCHAR2(504),
m525VARCHAR2(504),
m527VARCHAR2(504),
m530VARCHAR2(504),
m533VARCHAR2(504),
m534VARCH

Re:ScanMail Message: To Sender, sensitive content found and

[dgoulet]

OK, who have we got who works at Ge Capital?

Dick Goulet

Reply Separator
Author: System Attendant <[EMAIL PROTECTED]>
Date:   3/8/2001 2:22 PM

Trend SMEX Content Filter has detected sensitive content.

Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = [EMAIL PROTECTED]
Subject = Re:RE: Life in New England
Delivery Time = March 08, 2001 (Thursday) 12:22:24
Policy = Sexual Discrimination
Action on this mail = Quarantine message

Warning message from administrator:
Notice: A message you sent appears to have violated GE Financial Assurance email
policies for inappropriate language or content and may not have been received by
the recipient.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Max Extents Error

[Rocky Welch]

Pardon my syntax. Tim's is correct.

--- Tim Sawmiller <[EMAIL PROTECTED]> wrote:
> Check the maxextents value assigned to the table:
> 
> select max_extents from dba_tables where table_name = 'your_table_name';
> 
> Next, see how many extents the table is actually using:
> 
> select count(*) from dba_extents where table_name = 'your_table_name';
> 
> I'll bet the numbers are equal.  If so:
> 
> Alter your_table_name storage(maxextents 999);
> 
> where 999 is equal to a number larger than that obtained in the earlier
> scripts._
> 
> >>> [EMAIL PROTECTED] 03/08/01 02:00PM >>>
> Hi,
> 
> I have a table which consists of Long Raw column in addition to other
> columns of Number and Varchar2 datatypes.
> 
> I have the datafile size set to 2GB. The average length of the messages
> goes up to 100M, sometimes more than that.
> 
> I have now added three datafiles to that tablespace each greater than
> the first datafile. But I still keep getting the
> ORA-01631 Max extents reached for table "A" error.
> 
> What do I do resolve this error?
> 
> I am using 8K as the DB block size on SOlaris with Oracle 816. It is not
> a prod environment instead a dev environment.
> 
> Thanks
> Sanjay
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Sawmiller
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Max Extents Error

[Joan Hsieh]

This 
is very simple. just follow the oracle instruction; increase the maxextents of 
the table.
 
3101631, 0, "max # extents (%s) reached in table %s.%s"// 
*Cause:  A table tried to extend past maxextents// *Action: If 
maxextents is less than the system maximum, raise it. 
Otherwise,//  you must 
recreate with larger initial, next or pctincrease params
 
Joan


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sanjay KumarSent: 
  Thursday, March 08, 2001 2:01 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Max Extents Error
  Hi,
   
  I have a table which consists of Long Raw column 
  in addition to other columns of Number and Varchar2 
  datatypes.
   
  I have the datafile size set to 2GB. The average 
  length of the messages goes up to 100M, sometimes more than that.
   
  I have now added three datafiles to that 
  tablespace each greater than the first datafile. But I still keep getting 
  the
  ORA-01631 Max extents reached for table 
  "A" error.
   
  What do I do resolve this error?
   
  I am using 8K as the DB block size on SOlaris 
  with Oracle 816. It is not a prod environment instead a dev 
  environment.
   
  Thanks
  Sanjay

Re: Max Extents Error

[Rocky Welch]

Hi Sanjay,
Issue this command as the table owner:

alter table A maxextents unlimited;

Check the max extents for the table and use an appropriate value for your
application. Unlimited will allow the table to grow to the size of free
space in the tablespace.

HTH,
Rocky

--- Sanjay Kumar <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have a table which consists of Long Raw column in addition to other
> columns of Number and Varchar2 datatypes.
> 
> I have the datafile size set to 2GB. The average length of the messages
> goes up to 100M, sometimes more than that.
> 
> I have now added three datafiles to that tablespace each greater than
> the first datafile. But I still keep getting the
> ORA-01631 Max extents reached for table "A" error.
> 
> What do I do resolve this error?
> 
> I am using 8K as the DB block size on SOlaris with Oracle 816. It is not
> a prod environment instead a dev environment.
> 
> Thanks
> Sanjay
> 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Max Extents Error

[Tim Sawmiller]

Check the maxextents value assigned to the table:

select max_extents from dba_tables where table_name = 'your_table_name';

Next, see how many extents the table is actually using:

select count(*) from dba_extents where table_name = 'your_table_name';

I'll bet the numbers are equal.  If so:

Alter your_table_name storage(maxextents 999);

where 999 is equal to a number larger than that obtained in the earlier
scripts._

>>> [EMAIL PROTECTED] 03/08/01 02:00PM >>>
Hi,

I have a table which consists of Long Raw column in addition to other columns of 
Number and Varchar2 datatypes.

I have the datafile size set to 2GB. The average length of the messages goes up to 
100M, sometimes more than that.

I have now added three datafiles to that tablespace each greater than the first 
datafile. But I still keep getting the
ORA-01631 Max extents reached for table "A" error.

What do I do resolve this error?

I am using 8K as the DB block size on SOlaris with Oracle 816. It is not a prod 
environment instead a dev environment.

Thanks
Sanjay

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00922 on create table...

[Jacques Kilchoer]

Title: RE: ORA-00922 on create table...





You have a comma missing after the column definition of m099.


Jacques R. Kilchoër
x8816


> -Original Message-
> From: Gorden-Ozgul, Patricia E [mailto:[EMAIL PROTECTED]]
> Sent: jeudi, 8. mars 2001 08:48
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, March 08, 2001 11:42 AM
> To: [EMAIL PROTECTED]
> Experts,
> 
> Solaris 2.6
> RDBMS EE 8.1.5.0.0
> 
> I'll bet I'm doing something really stupid here.
> Can anyone find my error?
> 
> I'm getting the following error on execution:
> create table catrec (
> *
> 
> ERROR at line 1:
> ORA-00922:  missing or invalid option
> 
> huh?
> 
> 
> create table catrec (
>   abstract    VARCHAR2(3000),
>   add_dt      VARCHAR2(32),
>   altti       VARCHAR2(200),
>   au      VARCHAR2(1504),
>   auth        VARCHAR2(504),
>   au_sx       VARCHAR2(32),
>   call        VARCHAR2(56),
>   call_lc_sort    VARCHAR2(56),
>   catno       VARCHAR2(32),
>   check_in_note   VARCHAR2(3000),
>   claim_mode  VARCHAR2(32),
>   claim_mode_nm   VARCHAR2(32),
>   claim_period_days   VARCHAR2(32),
>   coden       VARCHAR2(32),
>   coll        VARCHAR2(504),
>   contents    VARCHAR2(3000),
>   corp        VARCHAR2(1504),
>   cpv     VARCHAR2(32),
>   dauth       VARCHAR2(232),
>   day_month   VARCHAR2(32),
>   day_week    VARCHAR2(32),
>   display_ti  VARCHAR2(504),
>   disp_isbn_order VARCHAR2(56),
>   doc     VARCHAR2(32),
>   dse3        VARCHAR2(32),
>   dse4        VARCHAR2(32),
>   dse5        VARCHAR2(32),
>   edtn        VARCHAR2(232),
>   enum_type3  VARCHAR2(32),
>   enum_type4  VARCHAR2(32),
>   enum_type5  VARCHAR2(32),
>   exclude_dates   VARCHAR2(32),
>   holdings    VARCHAR2(1000),
>   include_dates   VARCHAR2(32),
>   isbn        VARCHAR2(56),
>   issn        VARCHAR2(32),
>   issue_enum_type VARCHAR2(32),
>   key_numbers VARCHAR2(56),
>   kw      VARCHAR2(56),
>   leader      VARCHAR2(56),
>   level_      VARCHAR2(32),
>   m008        VARCHAR2(40),
>   m010        VARCHAR2(32),
>   m011        VARCHAR2(32),
>   m017        VARCHAR2(56),
>   m018        VARCHAR2(56),
>   m019        VARCHAR2(32),
>   m027        VARCHAR2(32),
>   m035        VARCHAR2(56),
>   m037        VARCHAR2(56),
>   m040        VARCHAR2(32),
>   m041        VARCHAR2(32),
>   m042        VARCHAR2(32),
>   m049        VARCHAR2(200),
>   m060        VARCHAR2(56),
>   m069        VARCHAR2(56),
>   m070        VARCHAR2(56),
>   m080        VARCHAR2(56),
>   m082        VARCHAR2(56),
>   m086        VARCHAR2(32),
>   m088        VARCHAR2(56),
>   m090        VARCHAR2(56),
>   m091        VARCHAR2(56),
>   m092        VARCHAR2(56),
>   m096        VARCHAR2(56),
>   m098        VARCHAR2(56),
>   m099        VARCHAR2(104)
>   m100_exp    VARCHAR2(1504),
>   m110_exp    VARCHAR2(1504),
>   m111        VARCHAR2(1504),
>   m111_exp    VARCHAR2(1504),
>   m130        VARCHAR2(200),
>   m130_exp    VARCHAR2(200),
>   m210        VARCHAR2(56),
>   m211        VARCHAR2(200),
>   m212        VARCHAR2(200),
>   m222        VARCHAR2(200),
>   m240        VARCHAR2(200),
>   m243        VARCHAR2(200),
>   m247        VARCHAR2(200),
>   m265        VARCHAR2(200),
>   m310        VARCHAR2(200),
>   m321        VARCHAR2(56),
>   m330        VARCHAR2(56),
>   m331        VARCHAR2(56),
>   m351        VARCHAR2(56),
>   m362        VARCHAR2(56),
>   m410        VARCHAR2(200),
>   m411        VARCHAR2(200),
>   m440        VARCHAR2(200),
>   m490        VARCHAR2(200),
>   m501        VARCHAR2(504),
>   m502        VARCHAR2(504),
>   m503        VARCHAR2(504),
>   m504        VARCHAR2(504),
>   m505        VARCHAR2(2000),
>   m506        VARCHAR2(504),
>   m512        VARCHAR2(504),
>   m513        VARCHAR2(504),
>   m515        VARCHAR2(504),
>   m520        VARCHAR2(504),
>   m521        VARCHAR2(504),
>   m522        VARCHAR2(504),
>   m523        VARCHAR2(504),
>   m524        VARCHAR2(504),
>   m525        VARCHAR2(504),
>   m527        VARCHAR2(504),
>   m530        VARCHAR2(504),
>   m533        VARCHAR2(504),
>   m534        VARCHAR2(504),
>   m536        VARCHA

RE: ORA-00922 on create table... (private)

[Rachel Carmichael]

oopss... that one wasn't supposed to go to the list. Caffeine levels below 
optimum threshold.

my apologies to the list



>From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: ORA-00922 on create table... (private)
>Date: Thu, 08 Mar 2001 10:37:39 -0800
>
>He POSTS!  
>
>I take it you weren't on the installation trip.
>
>How was Nobu? Worth adding to my "some day for a special occasion" list?
>
>Rachel
>
>>From: Scott Crabtree <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: RE: ORA-00922 on create table...
>>Date: Thu, 08 Mar 2001 09:05:37 -0800
>>
>>Missing a , atm099VARCHAR2(104)
>>
>>HTH,
>>  Scott Crabtree
>>
>>-Original Message-
>>Sent: Thursday, March 08, 2001 11:48 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>
>>__
>>Pat Gorden-Ozgul   BNL-ISD Systems
>>[EMAIL PROTECTED] 631-344-5159
>>
>>
>>
>>
>>
>>
>>-Original Message-
>>[mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, March 08, 2001 11:42 AM
>>To: [EMAIL PROTECTED]
>>Experts,
>>
>>Solaris 2.6
>>RDBMS EE 8.1.5.0.0
>>
>>I'll bet I'm doing something really stupid here.
>>Can anyone find my error?
>>
>>I'm getting the following error on execution:
>>create table catrec (
>> *
>>
>>ERROR at line 1:
>>ORA-00922:  missing or invalid option
>>
>>huh?
>>
>>
>>create table catrec (
>>  abstractVARCHAR2(3000),
>>  add_dt  VARCHAR2(32),
>>  altti   VARCHAR2(200),
>>  au  VARCHAR2(1504),
>>  authVARCHAR2(504),
>>  au_sx   VARCHAR2(32),
>>  callVARCHAR2(56),
>>  call_lc_sortVARCHAR2(56),
>>  catno   VARCHAR2(32),
>>  check_in_note   VARCHAR2(3000),
>>  claim_mode  VARCHAR2(32),
>>  claim_mode_nm   VARCHAR2(32),
>>  claim_period_days   VARCHAR2(32),
>>  coden   VARCHAR2(32),
>>  collVARCHAR2(504),
>>  contentsVARCHAR2(3000),
>>  corpVARCHAR2(1504),
>>  cpv VARCHAR2(32),
>>  dauth   VARCHAR2(232),
>>  day_month   VARCHAR2(32),
>>  day_weekVARCHAR2(32),
>>  display_ti  VARCHAR2(504),
>>  disp_isbn_order VARCHAR2(56),
>>  doc VARCHAR2(32),
>>  dse3VARCHAR2(32),
>>  dse4VARCHAR2(32),
>>  dse5VARCHAR2(32),
>>  edtnVARCHAR2(232),
>>  enum_type3  VARCHAR2(32),
>>  enum_type4  VARCHAR2(32),
>>  enum_type5  VARCHAR2(32),
>>  exclude_dates   VARCHAR2(32),
>>  holdingsVARCHAR2(1000),
>>  include_dates   VARCHAR2(32),
>>  isbnVARCHAR2(56),
>>  issnVARCHAR2(32),
>>  issue_enum_type VARCHAR2(32),
>>  key_numbers VARCHAR2(56),
>>  kw  VARCHAR2(56),
>>  leader  VARCHAR2(56),
>>  level_  VARCHAR2(32),
>>  m008VARCHAR2(40),
>>  m010VARCHAR2(32),
>>  m011VARCHAR2(32),
>>  m017VARCHAR2(56),
>>  m018VARCHAR2(56),
>>  m019VARCHAR2(32),
>>  m027VARCHAR2(32),
>>  m035VARCHAR2(56),
>>  m037VARCHAR2(56),
>>  m040VARCHAR2(32),
>>  m041VARCHAR2(32),
>>  m042VARCHAR2(32),
>>  m049VARCHAR2(200),
>>  m060VARCHAR2(56),
>>  m069VARCHAR2(56),
>>  m070VARCHAR2(56),
>>  m080VARCHAR2(56),
>>  m082VARCHAR2(56),
>>  m086VARCHAR2(32),
>>  m088VARCHAR2(56),
>>  m090VARCHAR2(56),
>>  m091VARCHAR2(56),
>>  m092VARCHAR2(56),
>>  m096VARCHAR2(56),
>>  m098VARCHAR2(56),
>>  m099VARCHAR2(104)
>>  m100_expVARCHAR2(1504),
>>  m110_expVARCHAR2(1504),
>>  m111VARCHAR2(1504),
>>  m111_expVARCHAR2(1504),
>>  m130VARCHAR2(200),
>>  m130_expVARCHAR2(200),
>>  m210VARCHAR2(56),
>>  m211VARCHAR2(200),
>>  m212VARCHAR2(200),
>>  m222VARCHAR2(200),
>>  m240VARCHAR2(200),
>>  m243VARCHAR2(200),
>>  m247VARCHAR2(200),
>>  m265VARCHAR2(200),
>>  m310VARCHAR2(200),
>>  m321VARCHAR2(56),
>>  m330VARCHAR2(56),
>>  m331VARCHAR2(56),
>>  m351VARCHAR2(56),
>>  m362VARCHAR2(56),
>>  m410VARCHAR2(200),
>>  m411VARCHAR

RE: RE: Life in New England

[Kevin Kostyszyn]

Personally I like snow, the more the better!!  The only problem here in New
Jersey is, all of the other people that try to drive in it.  "Oh
wow...snowdoesn't matter, I have an SUV, I am indestructable!!!"
Kev

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 11:54 AM
To: Multiple recipients of list ORACLE-L


Patrice,

Yeah, it's also amazing how your perspective changes when you've got 32
inches of the white stuff in your driveway & all of the database servers at
work
crashed because the power failed!  At times like that one needs a little
comic
relief!

Dick Goulet
I hate Monday, especially when it comes twice in one week!

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   3/8/2001 7:57 AM

I heard this on Radio Canada, in French re. a person from France who moved
to Quebec.

Interesting how things go around on the 'net.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systemes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Region des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject:OT: Life in New England

Since a bunch of us in the Northeast had a real review of our
recovery plans
yesterday, like we actually had to follow them, I thought that the
following
might provide a little comic relief for the remainder of the week.

Dick Goulet
BTW: I live in New Hampshire!

Forward Header_


Ah... life in NH

Dear Diary: Aug. 1
Moved to our new home in New Hampshire. It is so beautiful here. The
country is so picturesque. Can hardly wait to see it covered with
snow.
I LOVE IT HERE.

OCT. 14
New Hampshire is the most beautiful place on earth. The leaves are
turning
all different colors. I love the shades of red and orange. Went for
a
ride through the hills and saw some deer. They are so graceful.
Certainly they
are the most peaceful animals on earth. This must be paradise. I
LOVE IT HERE.

NOV. 11
Dear season will open soon. I can't imagine anyone wanting to kill
such
an elegant creature. The very symbol of peace and tranquillity. Hope
it will
snow soon. I LOVE IT HERE.

DEC. 2
It snowed last night. Woke up to find everything blanketed in white.
It
looked like a postcard. Went outside and cleaned snow off the steps
and
shoveled the driveway. We had a snowball fight today (I won). When
the
snowplow came by we had to shovel the driveway again. What a
beautiful
place.  Mother Nature in perfect harmony. I LOVE IT HERE.

DEC. 12
More snow last night. I love it. The snowplow did his trick again
that
rascal. A winter wonderland. I LOVE IT HERE.

DEC. 19
Snowed again last night. Couldn't get out of the driveway to get to
work
on time. I'm exhausted from shoveling. F@cking snowplow!

DEC. 22
More of that white %$#^ fell last night. I've got blisters on my
hands
from shoveling. I think the snowplow hides around the corner and
waits
until I'm done shoveling. That buthole!

DEC. 25
"White Christmas" my busted *&^. Mother F@cking snow. If I ever get
my
hands on that son-of-a-bitch who drives that snowplow. I swear I
will
castrate the dumb b@st@rd. Don't know why they don't use more salt
on
this f@cking ice.

DEC. 28
More of the same ^%$# last night. Been inside since Christmas Day
except for when "Snowplow Harry" comes by. Can't go anywhere. The
car is
buried in a mountain of white. The weatherman says expect another
10 inches tonight. Do you know how many shovels full of snow
10 inches is?

Jan. 1
Happy F@cking New Year. The weatherman was wrong (again). We got
34 inches of snow this time. At this rate it won't melt until the
4th of July.
The snowplow got stuck down the road and sh^% for brains had the
balls to come
to the door and ask to borrow my shovel. I told him I broke 6
shovels already,
shoveling out what he plowed into my driveway. I broke the 7th
shovel over his
head.

Jan. 4
Finally got out of the house today. Went to the store to get food
and on
the way back a deer ran out in front of the car and I hit it. Did
about
$3,000.00 damage to the car. Wish the hunters had killed them all
last November.

May 3

Max Extents Error

[Sanjay Kumar]

Hi,
 
I have a table which consists of Long Raw column in 
addition to other columns of Number and Varchar2 datatypes.
 
I have the datafile size set to 2GB. The average 
length of the messages goes up to 100M, sometimes more than that.
 
I have now added three datafiles to that tablespace 
each greater than the first datafile. But I still keep getting the
ORA-01631 Max extents reached for table "A" 
error.
 
What do I do resolve this error?
 
I am using 8K as the DB block size on SOlaris with 
Oracle 816. It is not a prod environment instead a dev environment.
 
Thanks
Sanjay

RE: ORA-00922 on create table...

[Gorden-Ozgul, Patricia E]

Thanks to all who found my error.


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorden-Ozgul, Patricia E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database

[Rachel Carmichael]

What Tim said :)

This is basically how I name columns.. primary key is identified, not by 
some generic name like "id" but by the name I'd use for it in the foreign 
key reference.


>From: "Tim Sawmiller" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: opinions on naming primary keys in new database
>Date: Thu, 08 Mar 2001 09:11:05 -0800
>
>I like leaving prefixes off the column names, except for primary keys.  
>There I used the table short name, or alias, followed by 'id.  So for the 
>CUSTOMER table, I'd use CUST_ID.  This same column name would be used in 
>child tables as the FK reference.
>
> >>> [EMAIL PROTECTED] 03/08/01 11:47AM >>>
>I agree with Hugh's approach.  I don't like redundancy (a fully-qualified
>reference to a column describes it fully), nor embedding the object type
>name in an object name (e.g., "data_tablespace").  IMHO, too few developers
>and DBA's give enough thought to the names they give their database 
>objects.
>
>
>Paul Baumgartel
>InstiPro, Inc.
>[EMAIL PROTECTED]
>212 813-0829 x103 (office)
>917 549-4717 (mobile)
>
>
>-Original Message-
>Sent: Thursday, March 08, 2001 11:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hugh,
>
>You are right that Richard Barker says not to use an entity name as part of
>an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
>Barker, page 3-9)  And I believe Oracle still gives out this book in their
>Data Modeling class.
>
>I have seen databases that completely follow this method and others that
>include the table name in every column.  As far as naming your primary key
>as a column called 'key', I don't like it either.
>
>I am also curious to see what is the preference of other list members.
>
>
>Regards,
>
>Jeff Cox
>IPS-Sendero
>Scottsdale, AZ
>
>
>
>
>-Original Message-
>Sent: Wednesday, March 07, 2001 4:58 PM
>To: [EMAIL PROTECTED]
>
>
>Hello,
>
>I wanted to get the lists opinion on the preference of naming primary keys.
>
>Please see my example below with the CUSTOMER table, and the customer TYPE
>table.  The column 'type_id' is a foreign key referencing the TYPE table.
>This is just an example to get opinions.
>
>
>CUST   TYPE
>+-+   +--+
>| id  |   |id|
>| name|   |desc  |
>| type_id |>--|  |
>+-+   +--+
>
>
>I like having my primary keys called id, and not including the table names
>in the columns of the original table.  For example, in the CUST table, we
>would not have 'cust_id' as the primary key, we would just call it 'id'.
>But having 'type_id' as a column of the CUST table is okay because that is 
>a
>foreign key, and not an attribute of the original CUST entity.
>
>Including the table name in a column that is not a foreign key, I believe,
>is redundant and not necessary.  (I also remember reading this in a Richard
>Barker book.)
>
>All foreign keys would then have the standard of table_column, with the
>exception of tables with multiple foreign keys from the same table, and
>recursive relationships - which would then just include a more descriptive
>table_column name.
>
>This way, when you do a describe on a table, you will immediately be able 
>to
>tell what are the foreign keys, and the primary keys. (I also believe in
>surrogate keys for most tables, so the problem of having a composite key is
>not an issue here.)  I think that this will later make the database easier
>to understand to new DBAs and duhvelopers, which would have been nice when 
>I
>worked on my first database.
>
>My questions:
>
>1) What is your preference with primary and foreign keys - if you could
>design a database from scratch?
>
>2) Am I off my rocker thinking that this is a good way to design a 
>database?
>
>3) We have a developer who wants to name all of our primary keys, 'key', 
>and
>I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
>anyone ever used 'key' as the primary key of a table?  This seems like it
>would be confusing when
>
>All constructive criticism is welcomed.
>
>Thank you,
>
>Hugh
>
>
>
>
>Think you know someone who can answer the above question? Forward it to
>them!
>to unsubscribe, send a blank email to [EMAIL PROTECTED]
>to subscribe send a blank email to [EMAIL PROTECTED]
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jeff Cox
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be remove

RE: ORA-00922 on create table... (private)

[Rachel Carmichael]

He POSTS!  

I take it you weren't on the installation trip.

How was Nobu? Worth adding to my "some day for a special occasion" list?

Rachel

>From: Scott Crabtree <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: ORA-00922 on create table...
>Date: Thu, 08 Mar 2001 09:05:37 -0800
>
>Missing a , at m099VARCHAR2(104)
>
>HTH,
>   Scott Crabtree
>
>-Original Message-
>Sent: Thursday, March 08, 2001 11:48 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>__
>Pat Gorden-Ozgul   BNL-ISD Systems
>[EMAIL PROTECTED] 631-344-5159
>
>
>
>
>
>
>-Original Message-
>[mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 08, 2001 11:42 AM
>To: [EMAIL PROTECTED]
>Experts,
>
>Solaris 2.6
>RDBMS EE 8.1.5.0.0
>
>I'll bet I'm doing something really stupid here.
>Can anyone find my error?
>
>I'm getting the following error on execution:
>create table catrec (
> *
>
>ERROR at line 1:
>ORA-00922:  missing or invalid option
>
>huh?
>
>
>create table catrec (
>   abstractVARCHAR2(3000),
>   add_dt  VARCHAR2(32),
>   altti   VARCHAR2(200),
>   au  VARCHAR2(1504),
>   authVARCHAR2(504),
>   au_sx   VARCHAR2(32),
>   callVARCHAR2(56),
>   call_lc_sortVARCHAR2(56),
>   catno   VARCHAR2(32),
>   check_in_note   VARCHAR2(3000),
>   claim_mode  VARCHAR2(32),
>   claim_mode_nm   VARCHAR2(32),
>   claim_period_days   VARCHAR2(32),
>   coden   VARCHAR2(32),
>   collVARCHAR2(504),
>   contentsVARCHAR2(3000),
>   corpVARCHAR2(1504),
>   cpv VARCHAR2(32),
>   dauth   VARCHAR2(232),
>   day_month   VARCHAR2(32),
>   day_weekVARCHAR2(32),
>   display_ti  VARCHAR2(504),
>   disp_isbn_order VARCHAR2(56),
>   doc VARCHAR2(32),
>   dse3VARCHAR2(32),
>   dse4VARCHAR2(32),
>   dse5VARCHAR2(32),
>   edtnVARCHAR2(232),
>   enum_type3  VARCHAR2(32),
>   enum_type4  VARCHAR2(32),
>   enum_type5  VARCHAR2(32),
>   exclude_dates   VARCHAR2(32),
>   holdingsVARCHAR2(1000),
>   include_dates   VARCHAR2(32),
>   isbnVARCHAR2(56),
>   issnVARCHAR2(32),
>   issue_enum_type VARCHAR2(32),
>   key_numbers VARCHAR2(56),
>   kw  VARCHAR2(56),
>   leader  VARCHAR2(56),
>   level_  VARCHAR2(32),
>   m008VARCHAR2(40),
>   m010VARCHAR2(32),
>   m011VARCHAR2(32),
>   m017VARCHAR2(56),
>   m018VARCHAR2(56),
>   m019VARCHAR2(32),
>   m027VARCHAR2(32),
>   m035VARCHAR2(56),
>   m037VARCHAR2(56),
>   m040VARCHAR2(32),
>   m041VARCHAR2(32),
>   m042VARCHAR2(32),
>   m049VARCHAR2(200),
>   m060VARCHAR2(56),
>   m069VARCHAR2(56),
>   m070VARCHAR2(56),
>   m080VARCHAR2(56),
>   m082VARCHAR2(56),
>   m086VARCHAR2(32),
>   m088VARCHAR2(56),
>   m090VARCHAR2(56),
>   m091VARCHAR2(56),
>   m092VARCHAR2(56),
>   m096VARCHAR2(56),
>   m098VARCHAR2(56),
>   m099VARCHAR2(104)
>   m100_expVARCHAR2(1504),
>   m110_expVARCHAR2(1504),
>   m111VARCHAR2(1504),
>   m111_expVARCHAR2(1504),
>   m130VARCHAR2(200),
>   m130_expVARCHAR2(200),
>   m210VARCHAR2(56),
>   m211VARCHAR2(200),
>   m212VARCHAR2(200),
>   m222VARCHAR2(200),
>   m240VARCHAR2(200),
>   m243VARCHAR2(200),
>   m247VARCHAR2(200),
>   m265VARCHAR2(200),
>   m310VARCHAR2(200),
>   m321VARCHAR2(56),
>   m330VARCHAR2(56),
>   m331VARCHAR2(56),
>   m351VARCHAR2(56),
>   m362VARCHAR2(56),
>   m410VARCHAR2(200),
>   m411VARCHAR2(200),
>   m440VARCHAR2(200),
>   m490VARCHAR2(200),
>   m501VARCHAR2(504),
>   m502VARCHAR2(504),
>   m503VARCHAR2(504),
>   m504VARCHAR2(504),
>   m505VARCHAR2(2000),
>   m506VARCHAR2(504),
>   m512VARCHAR2(504),
>   m513VARCHAR2(504),
>   m515 

RE: RE: Life in New England

[Boivin, Patrice J]

Dick,

I replied earlier but your e-mail gateway bounced my message back.

I was just wondering how to assess standard of living in New England, vs.
Canada.  My home e-mail is [EMAIL PROTECTED]
  

Anyway it doesn't sound like you lost any data during the storm, that's
good.  Hopefully all your servers came back up...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject:Re:RE: Life in New England

Patrice,

Yeah, it's also amazing how your perspective changes when you've
got 32
inches of the white stuff in your driveway & all of the database
servers at work
crashed because the power failed!  At times like that one needs a
little comic
relief!

Dick Goulet
I hate Monday, especially when it comes twice in one week!

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   3/8/2001 7:57 AM

I heard this on Radio Canada, in French re. a person from France who
moved
to Québec.

Interesting how things go around on the 'net.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 



-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject:OT: Life in New England

Since a bunch of us in the Northeast had a real review of
our
recovery plans
yesterday, like we actually had to follow them, I thought
that the
following
might provide a little comic relief for the remainder of the
week.

Dick Goulet
BTW: I live in New Hampshire!

Forward Header_


Ah... life in NH

Dear Diary: Aug. 1
Moved to our new home in New Hampshire. It is so beautiful
here. The
country is so picturesque. Can hardly wait to see it covered
with
snow.
I LOVE IT HERE.

OCT. 14
New Hampshire is the most beautiful place on earth. The
leaves are
turning
all different colors. I love the shades of red and orange.
Went for
a
ride through the hills and saw some deer. They are so
graceful.
Certainly they
are the most peaceful animals on earth. This must be
paradise. I
LOVE IT HERE.

NOV. 11
Dear season will open soon. I can't imagine anyone wanting
to kill
such
an elegant creature. The very symbol of peace and
tranquillity. Hope
it will
snow soon. I LOVE IT HERE.

DEC. 2
It snowed last night. Woke up to find everything blanketed
in white.
It
looked like a postcard. Went outside and cleaned snow off
the steps
and
shoveled the driveway. We had a snowball fight today (I
won). When
the
snowplow came by we had to shovel the driveway again. What a
beautiful
place.  Mother Nature in perfect harmony. I LOVE IT HERE.

DEC. 12
More snow last night. I love it. The snowplow did his trick
again
that
rascal. A winter wonderland. I LOVE IT HERE.

DEC. 19
Snowed again last night. Couldn't get out of the driveway to
get to
work
on time. I'm exhausted from shoveling. F@cking snowplow!

DEC. 22
More of that white %$#^ fell last night. I've got blisters
on my
hands
from shoveling. I think the snowplow hides around the corner
and
waits
until I'm done shoveling. That buthole!

DEC. 25
"White Christmas" my busted *&^. Mother F@cking snow. If I
ever get

815 install problem on NT

[Leslie Lu]

Hi all,

When I installed Oracle Enterprise Editon 8.1.5 to NT
4.0, I got this:  12570, 0, "TNS:packet reader
failure"

12570, 0, "TNS:packet reader failure"
// *Cause: An error occurred during a data receive.
// *Action: Not normally visible to the user. For
further details, turn
// on tracing and reexecute the operation. If error
persists, contact
// Oracle Customer Support.

I clicked ignore, Oracle run for a minute and show
that Create db assistant not installed successfully.

Anyone knows why did this happen and how to solve the
problem?  Much appreciated.

Leslie



__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(Fwd) Business Rules Symposium [ODTUG]

[Eric D. Pierce]

--- Forwarded message follows ---
Date sent: Thu, 08 Mar 2001 04:50:21 -0800
T o : M u l t i p l e   r e c i p i e n t s   o f   l i s t   O D T U
G - D E V 2 K - L
< O D T U G - D E V 2 K - L @ f a t c i t y . c o m >
F r o m : "P a u l   D o r s e y " < p d o r s e y @ d u l c i a n . c o m >

As many of you are aware, I am working with ODTUG to put together a Business
Rules Symposium as part of the ODTUG conference. Business rules-based
systems represent the next generation of database system design. If you are
involved in large project design, you need to be at the Symposium.

It will take place on Saturday June 23, 2001 in San Diego, CA, prior to the
start of the main ODTUG conference.  Most of the major "players" in the
business rule arena will be participating. In addition, I have invited
several of the vendors of business rules products to attend and tell us
about their products.

Since ODTUG is still months away, very few people have actually signed up
for the conference or the symposium but I am guessing that we will get over
100 attendees for the symposium.

As part of the symposium we are in the process of selecting two
Presentations to be given 90-minute slots in addition to 8 shorter
presentations in the afternoon. These two expanded talks will discuss actual
business rules implementations.

We received ten submissions that qualified for consideration of the
90-minute slots.  This caught me completely be surprise, I had no idea there
were so many good business rule projects to choose from!  The way we are
selecting these two presentations is to allow all of the symposium
participants to vote for the two projects they want to
hear more about.

If you are planning to attend the ODTUG Business Rule Symposium, please sign
up now rather than waiting.  The website address is
“www.odtug.com/2001_busrules.htm”. I must select the two projects by the end
of next week. You can participate in the selection process. If you sign up
for the Symposium before the close of business on Friday March 9th, I will
forward you the list of projects and you can vote for the ones you would
like to hear in more detail.

I hope to see you in June.

Dr. Paul Dorsey
Dulcian, Inc.

P.S. I would like to make a special issue on business rules for an upcomming
SELECT magazine edition.  If you want to submit a paper, please contact me
directly at [EMAIL PROTECTED]

--
ODTUG 2001 - Portal to Oracle Solutions is coming to San Diego, June 24-28!
Visit the ODTUG website at www.odtug.com for conference details and highlights.
Register before June 1st and save $100!
--
Author: Paul Dorsey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-DEV2K-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--- End of forwarded message ---

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Recall: RE: Life in New England

[Boivin, Patrice J]

Boivin, Patrice J would like to recall the message, "RE: Life in New
England".
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re[2]: OT: Life in New England

[dgoulet]

Nope, Been out of that for some time now!!

Reply Separator
Author: Terry Ball <[EMAIL PROTECTED]>
Date:   3/8/2001 9:28 AM

But did anyone ever accuse you of being in your right mind?

Terry

[EMAIL PROTECTED] wrote:

> Since a bunch of us in the Northeast had a real review of our recovery plans
> yesterday, like we actually had to follow them, I thought that the following
> might provide a little comic relief for the remainder of the week.
>
> Dick Goulet
> BTW: I live in New Hampshire!
>
> Forward Header_
>
> Ah... life in NH
>
> Dear Diary: Aug. 1
> Moved to our new home in New Hampshire. It is so beautiful here. The
> country is so picturesque. Can hardly wait to see it covered with snow.
> I LOVE IT HERE.
>
> OCT. 14
> New Hampshire is the most beautiful place on earth. The leaves are turning
> all different colors. I love the shades of red and orange. Went for a
> ride through the hills and saw some deer. They are so graceful. Certainly they
> are the most peaceful animals on earth. This must be paradise. I
> LOVE IT HERE.
>
> NOV. 11
> Dear season will open soon. I can't imagine anyone wanting to kill such
> an elegant creature. The very symbol of peace and tranquillity. Hope it will
> snow soon. I LOVE IT HERE.
>
> DEC. 2
> It snowed last night. Woke up to find everything blanketed in white. It
> looked like a postcard. Went outside and cleaned snow off the steps and
> shoveled the driveway. We had a snowball fight today (I won). When the
> snowplow came by we had to shovel the driveway again. What a beautiful
> place.  Mother Nature in perfect harmony. I LOVE IT HERE.
>
> DEC. 12
> More snow last night. I love it. The snowplow did his trick again that
> rascal. A winter wonderland. I LOVE IT HERE.
>
> DEC. 19
> Snowed again last night. Couldn't get out of the driveway to get to work
> on time. I'm exhausted from shoveling. F@cking snowplow!
>
> DEC. 22
> More of that white %$#^ fell last night. I've got blisters on my hands
> from shoveling. I think the snowplow hides around the corner and waits
> until I'm done shoveling. That buthole!
>
> DEC. 25
> "White Christmas" my busted *&^. Mother F@cking snow. If I ever get my
> hands on that son-of-a-bitch who drives that snowplow. I swear I will
> castrate the dumb b@st@rd. Don't know why they don't use more salt on
> this f@cking ice.
>
> DEC. 28
> More of the same ^%$# last night. Been inside since Christmas Day
> except for when "Snowplow Harry" comes by. Can't go anywhere. The car is
> buried in a mountain of white. The weatherman says expect another
> 10 inches tonight. Do you know how many shovels full of snow
> 10 inches is?
>
> Jan. 1
> Happy F@cking New Year. The weatherman was wrong (again). We got
> 34 inches of snow this time. At this rate it won't melt until the 4th of July.
> The snowplow got stuck down the road and sh^% for brains had the balls to come
> to the door and ask to borrow my shovel. I told him I broke 6 shovels already,
> shoveling out what he plowed into my driveway. I broke the 7th shovel over his
> head.
>
> Jan. 4
> Finally got out of the house today. Went to the store to get food and on
> the way back a deer ran out in front of the car and I hit it. Did about
> $3,000.00 damage to the car. Wish the hunters had killed them all last
November.
>
> May 3
> Took the car to the garage in town today. Would you believe the body is
> rotting away from all the salt they keep dumping all over the roads.  It
really
> looks like a piece of sh&^.
>
> May 10
> Moved to Florida today. I can't imagine why anyone in their right mind would
> want to live in the God forsaken State of New Hampshire.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other

Problems Killing Sessions

[Eriovaldo do Carmo Andrietta]

 
 Friends :
 
 We have a problem for kill a session :
 
 We did  :
 
 select * from v$session  and got the result bellow :
 
 USERNAME  SIDSERIAL# STATUS   SERVER
 -- -- --  -
 1  1 ACTIVE   DEDICATED
 2  1 ACTIVE   DEDICATED
 3  1 ACTIVE   DEDICATED
 4  1 ACTIVE   DEDICATED
 5  1 ACTIVE   DEDICATED
 USER0135  55317 ACTIVE   DEDICATED
 
 
 We applyed the command :
 
 alter system kill session '35,55317';
 alter system kill session '35,55317'
 *
 ERROR at line 1:
 ORA-00030: user session ID does not exist
 
 and also, by Instance Manager we finished with kill immediate
 
 but the session is showed in the Instance Manager and v$session ..
 
 Why ?
 
 
 Eriovaldo do Carmo Andrietta
 [EMAIL PROTECTED]
 Limeira/SP - Brasil
 
 
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo do Carmo Andrietta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database

[Jeff Cox]

Ron,

I think Hugh was asking about column names, not the actual constraint names.

You have a valid point, the constraint name should be more descriptive, with
the table name and column in it, followed by 'pk', 'fk', etc.  The subject
of the e-mail is a bit misleading and probably should be "opinions on naming
primary key COLUMNS in new database" because after reading his e-mail, I
think that he was talking about column names and not constraint names.

Jeff

-Original Message-
Sent: Thursday, March 08, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L


Hugh,
 For ease of maintaining the indexes ,keys and the space that they consume,
in  this shop they were named with the convention table_column_pk ,
table_column_ix , table_column_fk with numeric indications when there were
more than one. It makes it easier to see which index is growing and identify
the table associated with the growth. If all of the pk's were called "id"
etc, how would you know where the actual growth was occurring.

2 bits.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/08/01 11:10AM >>>
Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED]


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Cox
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Inter

RE: Svrmgrl "connect internal" asks for password??

[Ben Poels]

If you want to search for that document you need to
enter 69642.1 for the document no. search on the
advanced search page.

Ben Poels
Queen's University

-Original Message-
Sent: Thursday, March 08, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L


If you have access to Metalink there is a good article there (Doc. 69642 or
just put your subject in search), which lists all different causes why this
might happen audit dir being full is one of them, ORACLE_HOME and/or SID set
inapropriatelly, and a number of others.

Djordje

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 1:06 PM


> Try looking in $ORACLE_HOME/rdbms/audit directory.  If this directory is
> full, it can not create the .aud file to log that someone is using svrmgrl
and
> will
> ask for password.
>
> Terry
>
> "Fowler, Kenneth R" wrote:
>
> > List,
> >
> > I have an installation of Oracle 8.1.6 on a DBA test server where
svrmgrl
> > "connect internal" seems to want a password...
> >
> > Sun Microsystems Inc.   SunOS 5.8   Generic February 2000
> >
> > Configured oracle environment aliases...
> >
> > Alias SID   Oracle Home
> > - ---   ---
> > dba816dba816/Volumes/app/oracle/product/8.1.6
> > dba817dba817/Volumes/app/oracle/product/8.1.7
> >
> > $ id
> > uid=301(oracle) gid=300(dba)
> > $ groups
> > dba
> > $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > $ dba816
> > dba816 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba816
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
> > dba816 $ cdcreate
> > /Volumes/app/oracle/admin/dba816/create
> > dba816 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.6.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.6.2.0 - Production
> >
> > SVRMGR> connect internal;
> > Password:
> > Password:
> > ORA-01031: insufficient privileges
> > SVRMGR> ^D
> > Server Manager complete.
> > dba816 $ dba817
> > dba817 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba817
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
> > dba817 $ cdcreate
> > /Volumes/app/oracle/admin/dba817/create
> > dba817 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.7.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> >
> > SVRMGR> connect internal;
> > Connected.
> > SVRMGR> ^D
> > Server Manager complete.
> >
> > I know that the usual reason for this is that the account running
svrmgrl is
> > not a member of the appropriate unix group (usually "dba" or as
specified at
> > installation time) but this is not the case here.  On this server I have
> > Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
> > (Home = /Volumes/app/oracle/product/8.1.7).  My login script sets up
aliases
> > for each SID listed in /var/opt/oracle/oratab.  These aliases use the
oraenv
> > script with environment variable ORAENV_ASK=NO to set appropriate values
for
> > ORACLE_SID, ORACLE_HOME and PATH etc.  Other than that, the environment
is
> > exactly the same regardless of what SID I switch to (see log above).
> > However "connect internal" asks for a password for Oracle 8.1.6 but does
not
> > ask for one for Oracle 8.1.7.  I am pretty sure that I specified that
the
> > group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue.
> >
> > Can anybody give me some pointers of other things to look at to try and
> > resolve the problem???
> >
> > Thanks,
> > Ken
> > _
> > Clinical and Regulatory Informatics - Groton/New London
> > Coordinator, Business and Technical Services
> > Tel: (860) 732-0026Fax: (860) 715-8346
> > Email: [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Fowler, Kenneth R
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terry Ball
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego

Re: ORA-00922 on create table...

[Tim Sawmiller]

You're missing a comma after m099.

>>> [EMAIL PROTECTED] 03/08/01 11:47AM >>>


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159






-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 08, 2001 11:42 AM
To: [EMAIL PROTECTED] 
Experts,

Solaris 2.6
RDBMS EE 8.1.5.0.0

I'll bet I'm doing something really stupid here.
Can anyone find my error?

I'm getting the following error on execution:
create table catrec (
*

ERROR at line 1:
ORA-00922:  missing or invalid option

huh?


create table catrec (
abstractVARCHAR2(3000),
add_dt  VARCHAR2(32),
altti   VARCHAR2(200),
au  VARCHAR2(1504),
authVARCHAR2(504),
au_sx   VARCHAR2(32),
callVARCHAR2(56),
call_lc_sortVARCHAR2(56),
catno   VARCHAR2(32),
check_in_note   VARCHAR2(3000),
claim_mode  VARCHAR2(32),
claim_mode_nm   VARCHAR2(32),
claim_period_days   VARCHAR2(32),
coden   VARCHAR2(32),
collVARCHAR2(504),
contentsVARCHAR2(3000),
corpVARCHAR2(1504),
cpv VARCHAR2(32),
dauth   VARCHAR2(232),
day_month   VARCHAR2(32),
day_weekVARCHAR2(32),
display_ti  VARCHAR2(504),
disp_isbn_order VARCHAR2(56),
doc VARCHAR2(32),
dse3VARCHAR2(32),
dse4VARCHAR2(32),
dse5VARCHAR2(32),
edtnVARCHAR2(232),
enum_type3  VARCHAR2(32),
enum_type4  VARCHAR2(32),
enum_type5  VARCHAR2(32),
exclude_dates   VARCHAR2(32),
holdingsVARCHAR2(1000),
include_dates   VARCHAR2(32),
isbnVARCHAR2(56),
issnVARCHAR2(32),
issue_enum_type VARCHAR2(32),
key_numbers VARCHAR2(56),
kw  VARCHAR2(56),
leader  VARCHAR2(56),
level_  VARCHAR2(32),
m008VARCHAR2(40),
m010VARCHAR2(32),
m011VARCHAR2(32),
m017VARCHAR2(56),
m018VARCHAR2(56),
m019VARCHAR2(32),
m027VARCHAR2(32),
m035VARCHAR2(56),
m037VARCHAR2(56),
m040VARCHAR2(32),
m041VARCHAR2(32),
m042VARCHAR2(32),
m049VARCHAR2(200),
m060VARCHAR2(56),
m069VARCHAR2(56),
m070VARCHAR2(56),
m080VARCHAR2(56),
m082VARCHAR2(56),
m086VARCHAR2(32),
m088VARCHAR2(56),
m090VARCHAR2(56),
m091VARCHAR2(56),
m092VARCHAR2(56),
m096VARCHAR2(56),
m098VARCHAR2(56),
m099VARCHAR2(104)
m100_expVARCHAR2(1504),
m110_expVARCHAR2(1504),
m111VARCHAR2(1504),
m111_expVARCHAR2(1504),
m130VARCHAR2(200),
m130_expVARCHAR2(200),
m210VARCHAR2(56),
m211VARCHAR2(200),
m212VARCHAR2(200),
m222VARCHAR2(200),
m240VARCHAR2(200),
m243VARCHAR2(200),
m247VARCHAR2(200),
m265VARCHAR2(200),
m310VARCHAR2(200),
m321VARCHAR2(56),
m330VARCHAR2(56),
m331VARCHAR2(56),
m351VARCHAR2(56),
m362VARCHAR2(56),
m410VARCHAR2(200),
m411VARCHAR2(200),
m440VARCHAR2(200),
m490VARCHAR2(200),
m501VARCHAR2(504),
m502VARCHAR2(504),
m503VARCHAR2(504),
m504VARCHAR2(504),
m505VARCHAR2(2000),
m506VARCHAR2(504),
m512VARCHAR2(504),
m513VARCHAR2(504),
m515VARCHAR2(504),
m520VARCHAR2(504),
m521VARCHAR2(504),
m522VARCHAR2(504),
m523VARCHAR2(504),
m524VARCHAR2(504),
m525VARCHAR2(504),
m527VARCHAR2(504),
m530VARCHAR2(504),
m533VARCHAR2(504),
m534VARCHAR2(504),
m536VARCHAR2(504),
m537VARCHAR2(504),
m538VAR

RE: opinions on naming primary keys in new database (seriously)

[G . Plivna]

We have strict algorithm for table columns, keys, sequences and indexes

1. All tables have 3 cahracter long aliases
So all columns are in form _ for example emp_id, emp_name,
emp_adr_id, adr_street_name
2. All tables have surrogate primary key column in form _id
3. All primary keys are named _pk
4. All foreign key columns are in form __id
5. All foreign keys  are named __fk
6. If there are more than one foreign key to another table then foreign
keys  are named ___fk
6. All unique keys  are named __uk
7. Every table has its own sequence in form _seq
8. Every index on foreign key is in form __fk_i
9. Every index on one column  is in form _i
10. Every index on two or more columns is in form _
_i

The advantages are that one can surely identify object type, object
relation with table, not use aliases in almost all selects (aliases must be
in self joins).
Disadvantage - at least one - longer column names

I don't think it is invention of our organization, for example, Oracle
Designer uses almost the same scheme

But I think every apprach is good enough if it isn't haotic and You are
satisfied with it

Gints Plivna




   
   
"Jeff Cox" 
   
   
ndero.com>  cc:
   
Sent by:Subject: RE: opinions on naming 
primary keys in new database  
[EMAIL PROTECTED](seriously)
   
   
   
   
   
01.03.08 18:10 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED]


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is
a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able
to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when
I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from

RE: write error

[Trassens, Christian]

File too large. You are probably using an 32-bit OS with 2 Gb file size
limit. Use pipes.

Regards.

> -Mensaje original-
> De:   Leyden, Joseph [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 8 de marzo de 2001 16:41
> Para: Multiple recipients of list ORACLE-L
> Asunto:   write error
> 
> I got this while doing a database export,
> but system says only 16% full. why did it stop?
> 
> Help!
> Joe
> 
> . . exporting table  ACT_DAILY_OPERATOR_ACTIVITIES
> EXP-2: error in writing to export file
> EXP-00222:
> System error message 27
> EXP-2: error in writing to export file
> EXP-0: Export terminated unsuccessfully
> oracle@totsqt: /exp >
> 
> $ df -tk
> Filesystem1024-blocks  Used  Free %Used Mounted on
> /dev/explv8388608   1311964   7076644   16% /exp
> oracle@totsqt: /exp >
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database

[Tim Sawmiller]

I like leaving prefixes off the column names, except for primary keys.  There I used 
the table short name, or alias, followed by 'id.  So for the CUSTOMER table, I'd use 
CUST_ID.  This same column name would be used in child tables as the FK reference.

>>> [EMAIL PROTECTED] 03/08/01 11:47AM >>>
I agree with Hugh's approach.  I don't like redundancy (a fully-qualified
reference to a column describes it fully), nor embedding the object type
name in an object name (e.g., "data_tablespace").  IMHO, too few developers
and DBA's give enough thought to the names they give their database objects.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED] 
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Thursday, March 08, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED] 


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jeff Cox
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message

RE: ORA-00922 on create table...

[Scott Crabtree]

Missing a , at  m099VARCHAR2(104)

HTH,
Scott Crabtree

-Original Message-
Sent: Thursday, March 08, 2001 11:48 AM
To: Multiple recipients of list ORACLE-L




__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159






-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 08, 2001 11:42 AM
To: [EMAIL PROTECTED]
Experts,

Solaris 2.6
RDBMS EE 8.1.5.0.0

I'll bet I'm doing something really stupid here.
Can anyone find my error?

I'm getting the following error on execution:
create table catrec (
*

ERROR at line 1:
ORA-00922:  missing or invalid option

huh?


create table catrec (
abstractVARCHAR2(3000),
add_dt  VARCHAR2(32),
altti   VARCHAR2(200),
au  VARCHAR2(1504),
authVARCHAR2(504),
au_sx   VARCHAR2(32),
callVARCHAR2(56),
call_lc_sortVARCHAR2(56),
catno   VARCHAR2(32),
check_in_note   VARCHAR2(3000),
claim_mode  VARCHAR2(32),
claim_mode_nm   VARCHAR2(32),
claim_period_days   VARCHAR2(32),
coden   VARCHAR2(32),
collVARCHAR2(504),
contentsVARCHAR2(3000),
corpVARCHAR2(1504),
cpv VARCHAR2(32),
dauth   VARCHAR2(232),
day_month   VARCHAR2(32),
day_weekVARCHAR2(32),
display_ti  VARCHAR2(504),
disp_isbn_order VARCHAR2(56),
doc VARCHAR2(32),
dse3VARCHAR2(32),
dse4VARCHAR2(32),
dse5VARCHAR2(32),
edtnVARCHAR2(232),
enum_type3  VARCHAR2(32),
enum_type4  VARCHAR2(32),
enum_type5  VARCHAR2(32),
exclude_dates   VARCHAR2(32),
holdingsVARCHAR2(1000),
include_dates   VARCHAR2(32),
isbnVARCHAR2(56),
issnVARCHAR2(32),
issue_enum_type VARCHAR2(32),
key_numbers VARCHAR2(56),
kw  VARCHAR2(56),
leader  VARCHAR2(56),
level_  VARCHAR2(32),
m008VARCHAR2(40),
m010VARCHAR2(32),
m011VARCHAR2(32),
m017VARCHAR2(56),
m018VARCHAR2(56),
m019VARCHAR2(32),
m027VARCHAR2(32),
m035VARCHAR2(56),
m037VARCHAR2(56),
m040VARCHAR2(32),
m041VARCHAR2(32),
m042VARCHAR2(32),
m049VARCHAR2(200),
m060VARCHAR2(56),
m069VARCHAR2(56),
m070VARCHAR2(56),
m080VARCHAR2(56),
m082VARCHAR2(56),
m086VARCHAR2(32),
m088VARCHAR2(56),
m090VARCHAR2(56),
m091VARCHAR2(56),
m092VARCHAR2(56),
m096VARCHAR2(56),
m098VARCHAR2(56),
m099VARCHAR2(104)
m100_expVARCHAR2(1504),
m110_expVARCHAR2(1504),
m111VARCHAR2(1504),
m111_expVARCHAR2(1504),
m130VARCHAR2(200),
m130_expVARCHAR2(200),
m210VARCHAR2(56),
m211VARCHAR2(200),
m212VARCHAR2(200),
m222VARCHAR2(200),
m240VARCHAR2(200),
m243VARCHAR2(200),
m247VARCHAR2(200),
m265VARCHAR2(200),
m310VARCHAR2(200),
m321VARCHAR2(56),
m330VARCHAR2(56),
m331VARCHAR2(56),
m351VARCHAR2(56),
m362VARCHAR2(56),
m410VARCHAR2(200),
m411VARCHAR2(200),
m440VARCHAR2(200),
m490VARCHAR2(200),
m501VARCHAR2(504),
m502VARCHAR2(504),
m503VARCHAR2(504),
m504VARCHAR2(504),
m505VARCHAR2(2000),
m506VARCHAR2(504),
m512VARCHAR2(504),
m513VARCHAR2(504),
m515VARCHAR2(504),
m520VARCHAR2(504),
m521VARCHAR2(504),
m522VARCHAR2(504),
m523VARCHAR2(504),
m524VARCHAR2(504),
m525VARCHAR2(504),
m527VARCHAR2(504),
m530VARCHAR2(504),
m533VARCHAR2(504),
m534VARCHAR2(504),

Oracle Lite and Palm Synchronization

[Miller, Dave]

Has anyone got this to work? I'm using the latest oracle Lite I could find
(4.0.1.2).
When I follow the instructions to setup Iconnect for Palm sync, the step
that says to runregset cnshscnd.dll   results in the error:

C:\ORACLE\OLITE\BIN>regset cnshscnd.dll
Error : HotSync is not installed!


Any ideas?

Thanks

Dave Miller
DBA
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Problems Killing Sessions

[Eriovaldo do Carmo Andrietta]

Friends :

We have a problem for kill a session :

We did  :

select * from v$session  and got the result bellow :

USERNAME  SIDSERIAL# STATUS   SERVER
-- -- --  -
1  1 ACTIVE   DEDICATED
2  1 ACTIVE   DEDICATED
3  1 ACTIVE   DEDICATED
4  1 ACTIVE   DEDICATED
5  1 ACTIVE   DEDICATED
USER0135  55317 ACTIVE   DEDICATED


We applyed the command :

alter system kill session '35,55317';
alter system kill session '35,55317'
*
ERROR at line 1:
ORA-00030: user session ID does not exist

and also, by Instance Manager we finished with kill immediate

but the session is showed in the Instance Manager and v$session ..

Why ?


Eriovaldo do Carmo Andrietta
[EMAIL PROTECTED]
Limeira/SP - Brasil



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo do Carmo Andrietta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: write error

[Ruth Gramolini]

What is the size of the resultant .dmp file. If it is 2 gig it hit the exp
limit.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 10:40 AM


> I got this while doing a database export,
> but system says only 16% full. why did it stop?
>
> Help!
> Joe
>
> . . exporting table  ACT_DAILY_OPERATOR_ACTIVITIES
> EXP-2: error in writing to export file
> EXP-00222:
> System error message 27
> EXP-2: error in writing to export file
> EXP-0: Export terminated unsuccessfully
> oracle@totsqt: /exp >
>
> $ df -tk
> Filesystem1024-blocks  Used  Free %Used Mounted on
> /dev/explv8388608   1311964   7076644   16% /exp
> oracle@totsqt: /exp >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: Life in New England

[Terry Ball]

But did anyone ever accuse you of being in your right mind?

Terry

[EMAIL PROTECTED] wrote:

> Since a bunch of us in the Northeast had a real review of our recovery plans
> yesterday, like we actually had to follow them, I thought that the following
> might provide a little comic relief for the remainder of the week.
>
> Dick Goulet
> BTW: I live in New Hampshire!
>
> Forward Header_
>
> Ah... life in NH
>
> Dear Diary: Aug. 1
> Moved to our new home in New Hampshire. It is so beautiful here. The
> country is so picturesque. Can hardly wait to see it covered with snow.
> I LOVE IT HERE.
>
> OCT. 14
> New Hampshire is the most beautiful place on earth. The leaves are turning
> all different colors. I love the shades of red and orange. Went for a
> ride through the hills and saw some deer. They are so graceful. Certainly they
> are the most peaceful animals on earth. This must be paradise. I
> LOVE IT HERE.
>
> NOV. 11
> Dear season will open soon. I can't imagine anyone wanting to kill such
> an elegant creature. The very symbol of peace and tranquillity. Hope it will
> snow soon. I LOVE IT HERE.
>
> DEC. 2
> It snowed last night. Woke up to find everything blanketed in white. It
> looked like a postcard. Went outside and cleaned snow off the steps and
> shoveled the driveway. We had a snowball fight today (I won). When the
> snowplow came by we had to shovel the driveway again. What a beautiful
> place.  Mother Nature in perfect harmony. I LOVE IT HERE.
>
> DEC. 12
> More snow last night. I love it. The snowplow did his trick again that
> rascal. A winter wonderland. I LOVE IT HERE.
>
> DEC. 19
> Snowed again last night. Couldn't get out of the driveway to get to work
> on time. I'm exhausted from shoveling. F@cking snowplow!
>
> DEC. 22
> More of that white %$#^ fell last night. I've got blisters on my hands
> from shoveling. I think the snowplow hides around the corner and waits
> until I'm done shoveling. That buthole!
>
> DEC. 25
> "White Christmas" my busted *&^. Mother F@cking snow. If I ever get my
> hands on that son-of-a-bitch who drives that snowplow. I swear I will
> castrate the dumb b@st@rd. Don't know why they don't use more salt on
> this f@cking ice.
>
> DEC. 28
> More of the same ^%$# last night. Been inside since Christmas Day
> except for when "Snowplow Harry" comes by. Can't go anywhere. The car is
> buried in a mountain of white. The weatherman says expect another
> 10 inches tonight. Do you know how many shovels full of snow
> 10 inches is?
>
> Jan. 1
> Happy F@cking New Year. The weatherman was wrong (again). We got
> 34 inches of snow this time. At this rate it won't melt until the 4th of July.
> The snowplow got stuck down the road and sh^% for brains had the balls to come
> to the door and ask to borrow my shovel. I told him I broke 6 shovels already,
> shoveling out what he plowed into my driveway. I broke the 7th shovel over his
> head.
>
> Jan. 4
> Finally got out of the house today. Went to the store to get food and on
> the way back a deer ran out in front of the car and I hit it. Did about
> $3,000.00 damage to the car. Wish the hunters had killed them all last November.
>
> May 3
> Took the car to the garage in town today. Would you believe the body is
> rotting away from all the salt they keep dumping all over the roads.  It really
> looks like a piece of sh&^.
>
> May 10
> Moved to Florida today. I can't imagine why anyone in their right mind would
> want to live in the God forsaken State of New Hampshire.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database (seriously)

[Tony Johnson]

Depends on the primary key type. If a surrogate key type like ( like a
sequence number ) we name them (table name)_id. If comprised of multiple
columns we cant do this so just give them names following our naming
standards. The index which makes up the primary key is always named
pk_(table name). Hope this helps.


--
Tony JohnsonEmail  : [EMAIL PROTECTED]
Senior Database Administrator   Voice  : ( 480 ) 682 - 0849
GRID DATA, INC.   Cell   : ( 602 ) 363 - 7328
7408 W. Detroit #100Fax: ( 480 ) 961 - 8801
Chandler, AZ 85226

--
Murphy's Data Constant:Data will be damaged in direct proportion to its
value

-Original Message-
Sent: Thursday, March 08, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L


Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED]


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Cox
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tony Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

RE: opinions on naming primary keys in new database

[William Beilstein]

We would use something like curt_id, not just id. That way you can query the 
dba_tab_columns or user_tab_columns to see everywhere a particular key is referenced.

>>> "Jeff Cox" <[EMAIL PROTECTED]> 03/08/01 11:10AM >>>
Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED] 


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jeff Cox
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-00922 on create table...

[Gorden-Ozgul, Patricia E]

__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159






-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 08, 2001 11:42 AM
To: [EMAIL PROTECTED]
Experts,

Solaris 2.6
RDBMS EE 8.1.5.0.0

I'll bet I'm doing something really stupid here.
Can anyone find my error?

I'm getting the following error on execution:
create table catrec (
*

ERROR at line 1:
ORA-00922:  missing or invalid option

huh?


create table catrec (
abstractVARCHAR2(3000),
add_dt  VARCHAR2(32),
altti   VARCHAR2(200),
au  VARCHAR2(1504),
authVARCHAR2(504),
au_sx   VARCHAR2(32),
callVARCHAR2(56),
call_lc_sortVARCHAR2(56),
catno   VARCHAR2(32),
check_in_note   VARCHAR2(3000),
claim_mode  VARCHAR2(32),
claim_mode_nm   VARCHAR2(32),
claim_period_days   VARCHAR2(32),
coden   VARCHAR2(32),
collVARCHAR2(504),
contentsVARCHAR2(3000),
corpVARCHAR2(1504),
cpv VARCHAR2(32),
dauth   VARCHAR2(232),
day_month   VARCHAR2(32),
day_weekVARCHAR2(32),
display_ti  VARCHAR2(504),
disp_isbn_order VARCHAR2(56),
doc VARCHAR2(32),
dse3VARCHAR2(32),
dse4VARCHAR2(32),
dse5VARCHAR2(32),
edtnVARCHAR2(232),
enum_type3  VARCHAR2(32),
enum_type4  VARCHAR2(32),
enum_type5  VARCHAR2(32),
exclude_dates   VARCHAR2(32),
holdingsVARCHAR2(1000),
include_dates   VARCHAR2(32),
isbnVARCHAR2(56),
issnVARCHAR2(32),
issue_enum_type VARCHAR2(32),
key_numbers VARCHAR2(56),
kw  VARCHAR2(56),
leader  VARCHAR2(56),
level_  VARCHAR2(32),
m008VARCHAR2(40),
m010VARCHAR2(32),
m011VARCHAR2(32),
m017VARCHAR2(56),
m018VARCHAR2(56),
m019VARCHAR2(32),
m027VARCHAR2(32),
m035VARCHAR2(56),
m037VARCHAR2(56),
m040VARCHAR2(32),
m041VARCHAR2(32),
m042VARCHAR2(32),
m049VARCHAR2(200),
m060VARCHAR2(56),
m069VARCHAR2(56),
m070VARCHAR2(56),
m080VARCHAR2(56),
m082VARCHAR2(56),
m086VARCHAR2(32),
m088VARCHAR2(56),
m090VARCHAR2(56),
m091VARCHAR2(56),
m092VARCHAR2(56),
m096VARCHAR2(56),
m098VARCHAR2(56),
m099VARCHAR2(104)
m100_expVARCHAR2(1504),
m110_expVARCHAR2(1504),
m111VARCHAR2(1504),
m111_expVARCHAR2(1504),
m130VARCHAR2(200),
m130_expVARCHAR2(200),
m210VARCHAR2(56),
m211VARCHAR2(200),
m212VARCHAR2(200),
m222VARCHAR2(200),
m240VARCHAR2(200),
m243VARCHAR2(200),
m247VARCHAR2(200),
m265VARCHAR2(200),
m310VARCHAR2(200),
m321VARCHAR2(56),
m330VARCHAR2(56),
m331VARCHAR2(56),
m351VARCHAR2(56),
m362VARCHAR2(56),
m410VARCHAR2(200),
m411VARCHAR2(200),
m440VARCHAR2(200),
m490VARCHAR2(200),
m501VARCHAR2(504),
m502VARCHAR2(504),
m503VARCHAR2(504),
m504VARCHAR2(504),
m505VARCHAR2(2000),
m506VARCHAR2(504),
m512VARCHAR2(504),
m513VARCHAR2(504),
m515VARCHAR2(504),
m520VARCHAR2(504),
m521VARCHAR2(504),
m522VARCHAR2(504),
m523VARCHAR2(504),
m524VARCHAR2(504),
m525VARCHAR2(504),
m527VARCHAR2(504),
m530VARCHAR2(504),
m533VARCHAR2(504),
m534VARCHAR2(504),
m536VARCHAR2(504),
m537VARCHAR2(504),
m538VARCHAR2(504),
m540VARCHAR2(504),
m541VARCH

RE: How to know which are the snapshots suposed to be getting ref

[Muru]

It's 815 on NT40. The interesting point is, I created
a test case with one table and tested whether the logs
are getting purged, it did. So, As such I am unable to
come to a conclusion that there may be bugs with
Oracle on this.

--- "Fowler, Kenneth R"
<[EMAIL PROTECTED]> wrote:
> Version of oracle??  I know from personal that 8.1.6
> has problems with
> snapshot logs not being purged.
> 
> -Original Message-
> Sent: Wednesday, March 07, 2001 4:17 PM
> To: Multiple recipients of list ORACLE-L
> refreshed from master?
> 
> 
> Hello Forumists,
> 
> How to know which are the snapshots supposingly to
> get
> refreshed from the master? In my situation, I have
> around 40 databases refreshing from a single master
> and seems to be all the 40 databases' snapshots are
> getting refreshed. So, why my snapshot still grows
> without purging automatically is the question. If I
> manually purge the snapshots using
> dbms_snapshot.purge() procedure then, I have to make
> a
> COMPLETE refresh for all these snapshots which will
> involve more efforts. So, I would like to know if
> there is a way to find which are the snapshots
> supposed to refresh from master. Perhaps there is a
> way to find this out at the master using some
> dictionary tables etc..which I am not aware of. If
> anybody has an idea please let me know.
> 
> Thank you very much,
> Muru
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Muru
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Fowler, Kenneth R
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muru
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: exp/imp on NT

[William Beilstein]

For a full import to a test machine, just the tablespaces. need to be the same.

>>> Connie Milliken <[EMAIL PROTECTED]> 03/08/01 11:25AM >>>
Are there any file size limitations for exp/imp on NT like there are on
UNIX?  We have an 8GB db that we want to do a full exp/imp on.  Are
there any issues we could run into due to the size?

To do a full, imp, do just the tablespace names have to be the same as
the db the exp was taken from or do the datafiles and their directory
structures need to be exactly the same?

We want to do a full exp from a prod system and imp into a dev database
that is an old copy of prod.  Do we just need to drop all the users and
their schemas in dev (except for System) to to do the full imp?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Connie Milliken
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: Life in New England

[dgoulet]

Patrice,

Yeah, it's also amazing how your perspective changes when you've got 32
inches of the white stuff in your driveway & all of the database servers at work
crashed because the power failed!  At times like that one needs a little comic
relief!

Dick Goulet
I hate Monday, especially when it comes twice in one week!

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   3/8/2001 7:57 AM

I heard this on Radio Canada, in French re. a person from France who moved
to Québec.

Interesting how things go around on the 'net.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject:OT: Life in New England

Since a bunch of us in the Northeast had a real review of our
recovery plans
yesterday, like we actually had to follow them, I thought that the
following
might provide a little comic relief for the remainder of the week.

Dick Goulet
BTW: I live in New Hampshire!

Forward Header_


Ah... life in NH

Dear Diary: Aug. 1
Moved to our new home in New Hampshire. It is so beautiful here. The
country is so picturesque. Can hardly wait to see it covered with
snow.
I LOVE IT HERE.

OCT. 14
New Hampshire is the most beautiful place on earth. The leaves are
turning
all different colors. I love the shades of red and orange. Went for
a
ride through the hills and saw some deer. They are so graceful.
Certainly they
are the most peaceful animals on earth. This must be paradise. I
LOVE IT HERE.

NOV. 11
Dear season will open soon. I can't imagine anyone wanting to kill
such
an elegant creature. The very symbol of peace and tranquillity. Hope
it will
snow soon. I LOVE IT HERE.

DEC. 2
It snowed last night. Woke up to find everything blanketed in white.
It
looked like a postcard. Went outside and cleaned snow off the steps
and
shoveled the driveway. We had a snowball fight today (I won). When
the
snowplow came by we had to shovel the driveway again. What a
beautiful
place.  Mother Nature in perfect harmony. I LOVE IT HERE.

DEC. 12
More snow last night. I love it. The snowplow did his trick again
that
rascal. A winter wonderland. I LOVE IT HERE.

DEC. 19
Snowed again last night. Couldn't get out of the driveway to get to
work
on time. I'm exhausted from shoveling. F@cking snowplow!

DEC. 22
More of that white %$#^ fell last night. I've got blisters on my
hands
from shoveling. I think the snowplow hides around the corner and
waits
until I'm done shoveling. That buthole!

DEC. 25
"White Christmas" my busted *&^. Mother F@cking snow. If I ever get
my
hands on that son-of-a-bitch who drives that snowplow. I swear I
will
castrate the dumb b@st@rd. Don't know why they don't use more salt
on
this f@cking ice.

DEC. 28
More of the same ^%$# last night. Been inside since Christmas Day
except for when "Snowplow Harry" comes by. Can't go anywhere. The
car is
buried in a mountain of white. The weatherman says expect another
10 inches tonight. Do you know how many shovels full of snow
10 inches is?

Jan. 1
Happy F@cking New Year. The weatherman was wrong (again). We got
34 inches of snow this time. At this rate it won't melt until the
4th of July. 
The snowplow got stuck down the road and sh^% for brains had the
balls to come
to the door and ask to borrow my shovel. I told him I broke 6
shovels already,
shoveling out what he plowed into my driveway. I broke the 7th
shovel over his
head.

Jan. 4
Finally got out of the house today. Went to the store to get food
and on
the way back a deer ran out in front of the car and I hit it. Did
about
$3,000.00 damage to the car. Wish the hunters had killed them all
last November.

May 3
Took the car to the garage in town today. Would you believe the body
is
rotting away from all the salt they keep dumping all over the roads.
It really
looks like a piece of sh&^.

May 10
Moved to Florida today. I can't imagine why anyone in their right
mind would
want to live in the God forsaken

RE: opinions on naming primary keys in new database (seriously)

[Paul Baumgartel]

I agree with Hugh's approach.  I don't like redundancy (a fully-qualified
reference to a column describes it fully), nor embedding the object type
name in an object name (e.g., "data_tablespace").  IMHO, too few developers
and DBA's give enough thought to the names they give their database objects.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Thursday, March 08, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED]


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Cox
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: exp/imp on NT

[Ruth Gramolini]

Go to the LazyDBA website, to scripts scripts and get the scripts on
exporting and importing compressed files thru pipes written by Rachel
Carmichael.  These will create .dmp files of 2 gig which is the limit.  You
can edit these files to fit your needs.

Ruth


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 11:25 AM


> Are there any file size limitations for exp/imp on NT like there are on
> UNIX?  We have an 8GB db that we want to do a full exp/imp on.  Are
> there any issues we could run into due to the size?
>
> To do a full, imp, do just the tablespace names have to be the same as
> the db the exp was taken from or do the datafiles and their directory
> structures need to be exactly the same?
>
> We want to do a full exp from a prod system and imp into a dev database
> that is an old copy of prod.  Do we just need to drop all the users and
> their schemas in dev (except for System) to to do the full imp?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Connie Milliken
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database

[Ron Rogers]

Hugh,
 For ease of maintaining the indexes ,keys and the space that they consume,  in  this 
shop they were named with the convention table_column_pk , table_column_ix , 
table_column_fk with numeric indications when there were more than one. It makes it 
easier to see which index is growing and identify the table associated with the 
growth. If all of the pk's were called "id" etc, how would you know where the actual 
growth was occurring.

2 bits.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/08/01 11:10AM >>>
Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED] 


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jeff Cox
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: write error

[Mohan, Ross]

Title: RE: write error





you might want to look up system error message 27. 


something like /usr/sys/includes/errno.h should have it. 


...who knows? maybe a GB limit? A user quota? a
protocol hiccup?


Also, keep in mind, that if you DID fill up the filesystem
and failed, "something" might have deleted the failed EXPDAT.DMP
file before you ran your "ok" df -k. 


hth



- ross mohan 


-Original Message-
From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L
Subject: write error



I got this while doing a database export,
but system says only 16% full. why did it stop?


Help!
Joe


. . exporting table  ACT_DAILY_OPERATOR_ACTIVITIES
EXP-2: error in writing to export file
EXP-00222:
System error message 27
EXP-2: error in writing to export file
EXP-0: Export terminated unsuccessfully
oracle@totsqt: /exp >


$ df -tk
Filesystem    1024-blocks  Used  Free %Used Mounted on
/dev/explv    8388608   1311964   7076644   16% /exp
oracle@totsqt: /exp >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Life in New England

[Boivin, Patrice J]

I heard this on Radio Canada, in French re. a person from France who moved
to Québec.

Interesting how things go around on the 'net.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 08, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject:OT: Life in New England

Since a bunch of us in the Northeast had a real review of our
recovery plans
yesterday, like we actually had to follow them, I thought that the
following
might provide a little comic relief for the remainder of the week.

Dick Goulet
BTW: I live in New Hampshire!

Forward Header_


Ah... life in NH

Dear Diary: Aug. 1
Moved to our new home in New Hampshire. It is so beautiful here. The
country is so picturesque. Can hardly wait to see it covered with
snow.
I LOVE IT HERE.

OCT. 14
New Hampshire is the most beautiful place on earth. The leaves are
turning
all different colors. I love the shades of red and orange. Went for
a
ride through the hills and saw some deer. They are so graceful.
Certainly they
are the most peaceful animals on earth. This must be paradise. I
LOVE IT HERE.

NOV. 11
Dear season will open soon. I can't imagine anyone wanting to kill
such
an elegant creature. The very symbol of peace and tranquillity. Hope
it will
snow soon. I LOVE IT HERE.

DEC. 2
It snowed last night. Woke up to find everything blanketed in white.
It
looked like a postcard. Went outside and cleaned snow off the steps
and
shoveled the driveway. We had a snowball fight today (I won). When
the
snowplow came by we had to shovel the driveway again. What a
beautiful
place.  Mother Nature in perfect harmony. I LOVE IT HERE.

DEC. 12
More snow last night. I love it. The snowplow did his trick again
that
rascal. A winter wonderland. I LOVE IT HERE.

DEC. 19
Snowed again last night. Couldn't get out of the driveway to get to
work
on time. I'm exhausted from shoveling. F@cking snowplow!

DEC. 22
More of that white %$#^ fell last night. I've got blisters on my
hands
from shoveling. I think the snowplow hides around the corner and
waits
until I'm done shoveling. That buthole!

DEC. 25
"White Christmas" my busted *&^. Mother F@cking snow. If I ever get
my
hands on that son-of-a-bitch who drives that snowplow. I swear I
will
castrate the dumb b@st@rd. Don't know why they don't use more salt
on
this f@cking ice.

DEC. 28
More of the same ^%$# last night. Been inside since Christmas Day
except for when "Snowplow Harry" comes by. Can't go anywhere. The
car is
buried in a mountain of white. The weatherman says expect another
10 inches tonight. Do you know how many shovels full of snow
10 inches is?

Jan. 1
Happy F@cking New Year. The weatherman was wrong (again). We got
34 inches of snow this time. At this rate it won't melt until the
4th of July. 
The snowplow got stuck down the road and sh^% for brains had the
balls to come
to the door and ask to borrow my shovel. I told him I broke 6
shovels already,
shoveling out what he plowed into my driveway. I broke the 7th
shovel over his
head.

Jan. 4
Finally got out of the house today. Went to the store to get food
and on
the way back a deer ran out in front of the car and I hit it. Did
about
$3,000.00 damage to the car. Wish the hunters had killed them all
last November.

May 3
Took the car to the garage in town today. Would you believe the body
is
rotting away from all the salt they keep dumping all over the roads.
It really
looks like a piece of sh&^.

May 10
Moved to Florida today. I can't imagine why anyone in their right
mind would
want to live in the God forsaken State of New Hampshire.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E

Re: write error

[Cherie_Machler]

Is the output file larger than 1 Gig?
Do you have an upper limit on your
file sizes?

Cherie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

exp/imp on NT

[Connie Milliken]

Are there any file size limitations for exp/imp on NT like there are on
UNIX?  We have an 8GB db that we want to do a full exp/imp on.  Are
there any issues we could run into due to the size?

To do a full, imp, do just the tablespace names have to be the same as
the db the exp was taken from or do the datafiles and their directory
structures need to be exactly the same?

We want to do a full exp from a prod system and imp into a dev database
that is an old copy of prod.  Do we just need to drop all the users and
their schemas in dev (except for System) to to do the full imp?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Connie Milliken
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Recommended # of CPUs and MHz

[Kimberly Smith]

I agree.  I have 8 production databases here and everyone of them
run fine CPU wise but IO is at times noticeable.  Especially when
I need to do maintenance.  This is the case regardless of the fact
that some of the databases have dedicated HP servers and some share
their servers and there are splits of 2,3, and 4 CPUs.  

-Original Message-
Sent: Wednesday, March 07, 2001 6:56 PM
To: Multiple recipients of list ORACLE-L


Don,

Sounds like you've got a good base to run from, especially if you can
get
the memory for 3 instances.  Now don't forget the other part, lots of Disk
IO
capacity.  I've a 100GB database on an HP 9000/K570 with 4 250MHZ CPU's (I
believe).  The system supports 100+ users and 150 automatic test stations
plus
assorted other stuff.  On an average day the CPU's rarely break a sweat, but
the
SCSI channels are maxed out.  Basically this DB misbehaves due to being IO
bound.

Dick Goulet

Reply Separator
Author: "Simpson; Don" <[EMAIL PROTECTED]>
Date:   3/7/2001 12:35 PM

I've been looking around for ways to determine how much processor speed I
need for a new installation.  From what I found so far there are basically
two ways to do this.
1.  Spend the time and money on resources and tools to analyze the needs.
2.  Make a best guess and go from there.

Given the limited time and budget I would like simply to make a best guess.
I'm hoping a query to the mass might produce some suggestions for me.

I'm estimating about 100 to 150 users on a machine that will be dedicated
strictly to the database, no app servers or any other programs outside of
normal OS and database processes will run on it.  I will have  3 Oracle
instances running on it, all together about 10 gig of data manipulated in a
OLTP environment.

I'll probably go with a SUN 420 with 2 450MHz processors to start.  I'd like
to have more but then that would raise the ante on the Oracle licensing.
I'll attempt to compensate with loads of memory.

What do you think, am I being unrealistic with only 900MHz or can I skate
by? 

Thanks,
Don.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Simpson, Don
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: opinions on naming primary keys in new database (seriously)

[Jeff Cox]

Hugh,

You are right that Richard Barker says not to use an entity name as part of
an attribute name.  (CASE*METHOD Entity Relationship Moddelling, by Richard
Barker, page 3-9)  And I believe Oracle still gives out this book in their
Data Modeling class.

I have seen databases that completely follow this method and others that
include the table name in every column.  As far as naming your primary key
as a column called 'key', I don't like it either.

I am also curious to see what is the preference of other list members.


Regards,

Jeff Cox
IPS-Sendero
Scottsdale, AZ




-Original Message-
Sent: Wednesday, March 07, 2001 4:58 PM
To: [EMAIL PROTECTED]


Hello,

I wanted to get the lists opinion on the preference of naming primary keys.

Please see my example below with the CUSTOMER table, and the customer TYPE
table.  The column 'type_id' is a foreign key referencing the TYPE table.
This is just an example to get opinions.


CUST   TYPE
+-+   +--+
| id  |   |id|
| name|   |desc  |
| type_id |>--|  |
+-+   +--+


I like having my primary keys called id, and not including the table names
in the columns of the original table.  For example, in the CUST table, we
would not have 'cust_id' as the primary key, we would just call it 'id'.
But having 'type_id' as a column of the CUST table is okay because that is a
foreign key, and not an attribute of the original CUST entity.

Including the table name in a column that is not a foreign key, I believe,
is redundant and not necessary.  (I also remember reading this in a Richard
Barker book.)

All foreign keys would then have the standard of table_column, with the
exception of tables with multiple foreign keys from the same table, and
recursive relationships - which would then just include a more descriptive
table_column name.

This way, when you do a describe on a table, you will immediately be able to
tell what are the foreign keys, and the primary keys. (I also believe in
surrogate keys for most tables, so the problem of having a composite key is
not an issue here.)  I think that this will later make the database easier
to understand to new DBAs and duhvelopers, which would have been nice when I
worked on my first database.

My questions:

1) What is your preference with primary and foreign keys - if you could
design a database from scratch?

2) Am I off my rocker thinking that this is a good way to design a database?

3) We have a developer who wants to name all of our primary keys, 'key', and
I am trying to convince her that we should use 'id' or 'nbr' instead.  Has
anyone ever used 'key' as the primary key of a table?  This seems like it
would be confusing when

All constructive criticism is welcomed.

Thank you,

Hugh




Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Cox
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Installing OAS and Deploying on it.

[Abdul Aleem]

Hi!

I want to try out OAS, recently offered by OTN. I have following queries for
deploying application totally based on Oracle Forms6i and Reports 6i:

What components to install for deploying Oracle forms based application
Should the application be located in a particular folder for the OAS to pick
it up during installation
Which Oracle_Home to install in
How to deploy
How to then access the same application through browser and forms/reports
runtime.

Any help, link etc. would be much appreciated.

TIA,

Aleem

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: Life in New England

[dgoulet]

Since a bunch of us in the Northeast had a real review of our recovery plans
yesterday, like we actually had to follow them, I thought that the following
might provide a little comic relief for the remainder of the week.

Dick Goulet
BTW: I live in New Hampshire!

Forward Header_


Ah... life in NH

Dear Diary: Aug. 1
Moved to our new home in New Hampshire. It is so beautiful here. The
country is so picturesque. Can hardly wait to see it covered with snow.
I LOVE IT HERE.

OCT. 14
New Hampshire is the most beautiful place on earth. The leaves are turning
all different colors. I love the shades of red and orange. Went for a
ride through the hills and saw some deer. They are so graceful. Certainly they
are the most peaceful animals on earth. This must be paradise. I
LOVE IT HERE.

NOV. 11
Dear season will open soon. I can't imagine anyone wanting to kill such
an elegant creature. The very symbol of peace and tranquillity. Hope it will
snow soon. I LOVE IT HERE.

DEC. 2
It snowed last night. Woke up to find everything blanketed in white. It
looked like a postcard. Went outside and cleaned snow off the steps and
shoveled the driveway. We had a snowball fight today (I won). When the
snowplow came by we had to shovel the driveway again. What a beautiful
place.  Mother Nature in perfect harmony. I LOVE IT HERE.

DEC. 12
More snow last night. I love it. The snowplow did his trick again that
rascal. A winter wonderland. I LOVE IT HERE.

DEC. 19
Snowed again last night. Couldn't get out of the driveway to get to work
on time. I'm exhausted from shoveling. F@cking snowplow!

DEC. 22
More of that white %$#^ fell last night. I've got blisters on my hands
from shoveling. I think the snowplow hides around the corner and waits
until I'm done shoveling. That buthole!

DEC. 25
"White Christmas" my busted *&^. Mother F@cking snow. If I ever get my
hands on that son-of-a-bitch who drives that snowplow. I swear I will
castrate the dumb b@st@rd. Don't know why they don't use more salt on
this f@cking ice.

DEC. 28
More of the same ^%$# last night. Been inside since Christmas Day
except for when "Snowplow Harry" comes by. Can't go anywhere. The car is
buried in a mountain of white. The weatherman says expect another
10 inches tonight. Do you know how many shovels full of snow
10 inches is?

Jan. 1
Happy F@cking New Year. The weatherman was wrong (again). We got
34 inches of snow this time. At this rate it won't melt until the 4th of July. 
The snowplow got stuck down the road and sh^% for brains had the balls to come
to the door and ask to borrow my shovel. I told him I broke 6 shovels already,
shoveling out what he plowed into my driveway. I broke the 7th shovel over his
head.

Jan. 4
Finally got out of the house today. Went to the store to get food and on
the way back a deer ran out in front of the car and I hit it. Did about
$3,000.00 damage to the car. Wish the hunters had killed them all last November.

May 3
Took the car to the garage in town today. Would you believe the body is
rotting away from all the salt they keep dumping all over the roads.  It really
looks like a piece of sh&^.

May 10
Moved to Florida today. I can't imagine why anyone in their right mind would
want to live in the God forsaken State of New Hampshire.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Helpdesk Support

[Kevin Kostyszyn]

That is beyond perfect!!!

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L


This is a message I received from a colleague.  Have a good laugh:

==
This has got to be one of the funniest I've heard of in a long  time. I
 think this guy should have been promoted, not fired.


 This is a  true story from the Word Perfect Help line which was
 transcribed from a  recording monitoring the customer care department.
 Needless to say the  Helpdesk employee was fired; however, he is
 currently suing the Word Perfect  organization for " Termination without
Cause."
 Actual dialogue of a former WordPerfect Customer Support  employee !


 "Ridge Hall computer assistance; may I help you?"

 "Yes, well, I'm having trouble with WordPerfect."

 "What sort of trouble?"

 "Well, I was just typing along, and all of a sudden the words went
  away."

 "Went away?"

 "They disappeared."

 "Hmm. So what does your screen look like now?"

 "Nothing."

 "Nothing?"

 "It's blank; it won't accept anything when I type."

 "Are you still in WordPerfect, or did you get out?"

 "How do I tell?"

 "Can you see the C: prompt on the screen?"

 "What's a sea-prompt?"

 "Never mind, can you move your cursor around the screen?"

 "There isn't any cursor: I told you, it won't accept anything  I type."

 "Does your monitor have a power indicator?"

 "What's a monitor?"

 "It's the thing with the screen on it that looks like a TV.  Does it
  have a little light that tells you when it's on?"

 "I don't know."

 "Well, then look on the back of the monitor and find where the  power
  cord goes into it. Can you see that?"

 "Yes, I think so."

 "Great. Follow the cord to the plug, and tell me if it's  plugged into
  the wall."

 "Yes, it is."

 "When you were behind the monitor, did you notice that there  were two
  cables plugged into the back of it, not just one?"

 "No."

 "Well, there are. I need you to look back there again and find the other
  cable."

 "Okay, here it is."

 "Follow it for me, and tell me if it's plugged securely into  the back
  of your computer."

 "I can't reach."

 "Uh huh. Well, can you see if it is? Even if you maybe put your knee on
  something and lean way over?"

 "Oh, it's not because I don't have the right angle, it's because it's
 dark."

 "Dark?"

 "Yes - the office light is off, and the only light I have is coming in
 from the window."

 "Well, turn on the office light then."

 "I can't."

 "No? Why not?"

 "Because there's a power failure."

 "A power . . . A power failure? Aha, Okay, we've got it licked now. Do
 you still have the boxes and manuals and packing stuff your computer came
 in?"

 "Well, yes, I keep them in the closet."

 "Good. Go get them, and unplug your system and pack it up just like it
 was when you got it. Then take it back to the store you bought it from."

"Really? Is it that bad?"

 "Yes, I'm afraid it is."

 "Well, all right then, I suppose. What do I tell them?"

"Tell them you're too f@cking stupid to own a computer."








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

write error

[Leyden, Joseph]

I got this while doing a database export,
but system says only 16% full. why did it stop?

Help!
Joe

. . exporting table  ACT_DAILY_OPERATOR_ACTIVITIES
EXP-2: error in writing to export file
EXP-00222:
System error message 27
EXP-2: error in writing to export file
EXP-0: Export terminated unsuccessfully
oracle@totsqt: /exp >

$ df -tk
Filesystem1024-blocks  Used  Free %Used Mounted on
/dev/explv8388608   1311964   7076644   16% /exp
oracle@totsqt: /exp >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle HR gets a BIG customer!!!

[dgoulet]

>From my copy of the Air Force News Service:

Dick Goulet

==

0323.  MilMod replaces current personnel system

RANDOLPH AIR FORCE BASE, Texas (AFPN) -- In less than two months, military
personnelists throughout the Air Force, Air National Guard and Reserve will
begin using state-of-the-art technology to process "total force" personnel
information.

The Air Force Military Personnel Data System Modernization program, or
MilMod, will be turned on May 1, replacing the 1970s technology currently
being used with a relational database using the Oracle Human Resources
software. It has been more than 20 years since the last major update.

"We've been working hard for nearly five years building this modernized
system to take Air Force personnel processing into the next century," said
Lt. Col. Ed Oliver, MilMod program manager at the Air Force Personnel Center
here. "Our folks have been working seriously long hours to get this new
system up and running by the May 1 deadline. We're now in the final stretch
and are building the world's largest, and we think the best, human resource
system."

This new system will support all "life cycle" personnel management functions
from recruiting through job assignment and ultimately separation or
retirement. It will provide real-time updating and reporting capabilities
that are not available in today's Personnel Data System, Oliver said.

"Current automation technology is being leveraged to improve support at all
levels and is the foundation for building a robust integrated personnel
system for the total force," he said.

The new system has several inherent improvements over the current system.
The most apparent improvement is the graphical-user interface, which will
give personnel technicians online, real-time access to personnel
information.

"We've also standardized the support we're providing to the total force,"
Oliver said. "This will improve system support to the Air National Guard and
Air Force Reserve personnel processes."

But, as with any new system, there will be a transition period where the
normal personnel functions that people use will be unavailable, officials
said. There will be a nine-day period prior to the implementation date where
no personnel transactions will be accepted into the systems being replaced.
All active-duty, Guard and Reserve members are urged to complete any
personnel actions before April 21 to ensure the transactions are processed
prior to the transition, or people can wait until MilMod comes online May 1.

For more information, visit the MilMod home page at
http://www.afpc.randolph.af.mil/modern. (Courtesy of AFPC News Service)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: Helpdesk Support

[dgoulet]

This is a message I received from a colleague.  Have a good laugh:

==
This has got to be one of the funniest I've heard of in a long  time. I
 think this guy should have been promoted, not fired.


 This is a  true story from the Word Perfect Help line which was
 transcribed from a  recording monitoring the customer care department.
 Needless to say the  Helpdesk employee was fired; however, he is
 currently suing the Word Perfect  organization for " Termination without
Cause."
 Actual dialogue of a former WordPerfect Customer Support  employee !


 "Ridge Hall computer assistance; may I help you?"

 "Yes, well, I'm having trouble with WordPerfect."

 "What sort of trouble?"

 "Well, I was just typing along, and all of a sudden the words went
  away."

 "Went away?"

 "They disappeared."

 "Hmm. So what does your screen look like now?"

 "Nothing."

 "Nothing?"

 "It's blank; it won't accept anything when I type."

 "Are you still in WordPerfect, or did you get out?"

 "How do I tell?"

 "Can you see the C: prompt on the screen?"

 "What's a sea-prompt?"

 "Never mind, can you move your cursor around the screen?"

 "There isn't any cursor: I told you, it won't accept anything  I type."

 "Does your monitor have a power indicator?"

 "What's a monitor?"

 "It's the thing with the screen on it that looks like a TV.  Does it
  have a little light that tells you when it's on?"

 "I don't know."

 "Well, then look on the back of the monitor and find where the  power
  cord goes into it. Can you see that?"

 "Yes, I think so."

 "Great. Follow the cord to the plug, and tell me if it's  plugged into
  the wall."

 "Yes, it is."

 "When you were behind the monitor, did you notice that there  were two
  cables plugged into the back of it, not just one?"

 "No."

 "Well, there are. I need you to look back there again and find the other
  cable."

 "Okay, here it is."

 "Follow it for me, and tell me if it's plugged securely into  the back
  of your computer."

 "I can't reach."

 "Uh huh. Well, can you see if it is? Even if you maybe put your knee on
  something and lean way over?"

 "Oh, it's not because I don't have the right angle, it's because it's
 dark."

 "Dark?"

 "Yes - the office light is off, and the only light I have is coming in
 from the window."

 "Well, turn on the office light then."

 "I can't."

 "No? Why not?"

 "Because there's a power failure."

 "A power . . . A power failure? Aha, Okay, we've got it licked now. Do
 you still have the boxes and manuals and packing stuff your computer came
 in?"

 "Well, yes, I keep them in the closet."

 "Good. Go get them, and unplug your system and pack it up just like it
 was when you got it. Then take it back to the store you bought it from."

"Really? Is it that bad?"

 "Yes, I'm afraid it is."

 "Well, all right then, I suppose. What do I tell them?"

"Tell them you're too f@cking stupid to own a computer."








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Svrmgrl "connect internal" asks for password??

[djordjej]

If you have access to Metalink there is a good article there (Doc. 69642 or
just put your subject in search), which lists all different causes why this
might happen audit dir being full is one of them, ORACLE_HOME and/or SID set
inapropriatelly, and a number of others.

Djordje

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 1:06 PM


> Try looking in $ORACLE_HOME/rdbms/audit directory.  If this directory is
> full, it can not create the .aud file to log that someone is using svrmgrl
and
> will
> ask for password.
>
> Terry
>
> "Fowler, Kenneth R" wrote:
>
> > List,
> >
> > I have an installation of Oracle 8.1.6 on a DBA test server where
svrmgrl
> > "connect internal" seems to want a password...
> >
> > Sun Microsystems Inc.   SunOS 5.8   Generic February 2000
> >
> > Configured oracle environment aliases...
> >
> > Alias SID   Oracle Home
> > - ---   ---
> > dba816dba816/Volumes/app/oracle/product/8.1.6
> > dba817dba817/Volumes/app/oracle/product/8.1.7
> >
> > $ id
> > uid=301(oracle) gid=300(dba)
> > $ groups
> > dba
> > $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > $ dba816
> > dba816 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba816
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
> > dba816 $ cdcreate
> > /Volumes/app/oracle/admin/dba816/create
> > dba816 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.6.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.6.2.0 - Production
> >
> > SVRMGR> connect internal;
> > Password:
> > Password:
> > ORA-01031: insufficient privileges
> > SVRMGR> ^D
> > Server Manager complete.
> > dba816 $ dba817
> > dba817 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba817
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
> > dba817 $ cdcreate
> > /Volumes/app/oracle/admin/dba817/create
> > dba817 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.7.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> >
> > SVRMGR> connect internal;
> > Connected.
> > SVRMGR> ^D
> > Server Manager complete.
> >
> > I know that the usual reason for this is that the account running
svrmgrl is
> > not a member of the appropriate unix group (usually "dba" or as
specified at
> > installation time) but this is not the case here.  On this server I have
> > Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
> > (Home = /Volumes/app/oracle/product/8.1.7).  My login script sets up
aliases
> > for each SID listed in /var/opt/oracle/oratab.  These aliases use the
oraenv
> > script with environment variable ORAENV_ASK=NO to set appropriate values
for
> > ORACLE_SID, ORACLE_HOME and PATH etc.  Other than that, the environment
is
> > exactly the same regardless of what SID I switch to (see log above).
> > However "connect internal" asks for a password for Oracle 8.1.6 but does
not
> > ask for one for Oracle 8.1.7.  I am pretty sure that I specified that
the
> > group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue.
> >
> > Can anybody give me some pointers of other things to look at to try and
> > resolve the problem???
> >
> > Thanks,
> > Ken
> > _
> > Clinical and Regulatory Informatics - Groton/New London
> > Coordinator, Business and Technical Services
> > Tel: (860) 732-0026Fax: (860) 715-8346
> > Email: [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Fowler, Kenneth R
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terry Ball
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') an

Re: export/import

[Ruth Gramolini]

You can do that.  Just make sure you FTP in binary mode.  RBG

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 5:31 PM


> Can I import a database from NT which was 
> exported from AIX RS6000 servers? Do I just
> move the expdat.dmp (exported output) from
> AIX to NT and simply use the export/import 
> utilities?
> 
> TIA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle V9 DB server

[Dwayne Cox]

Just got this from Infoworld's site. It basically talks about 'pieces' of
9i being
 released ahead of the database. The section of more urgent interest
is this:

Oracle's target date for releasing 9i is June 30, Bob 
Shimp, senior director for Oracle 9i marketing, said in 
an interview last week. That would be the tail end of 
Oracle's previously stated launch window of the first 
half of 2001. Indeed, Larry Ellison, Oracle's chairman 
and chief executive officer, said at the OpenWorld 
show in October that Oracle 9i would ship in March. 

Oracle is pitching the new database to ASPs, where 
it hopes to become a significant player in the 
emerging hosted applications market, as well as to 
e-businesses that are using the Internet as a critical 
part of their operations and who need a reliable and 
scalable database. 

Here is the whole article:
http://www.infoworld.com/articles/hn/xml/01/03/07/010307hndataguard.xml?p=br&s=8



Dwayne Cox
[EMAIL PROTECTED]
Database Administrator, Development Department

Info Tech, Inc. 
5700 S.W.  34th Street, Suite 1235
Gainesville, FL  32608
Phone: 352-381-4400/Fax: 352-381-
http://www.infotech.com

change the seize of buffer ODBC

[benajam lhoussain]

hi,

where i can change the seize of buffer ODBC under nt.

thanks in advance.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: benajam lhoussain
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Svrmgrl "connect internal" asks for password??

[Trassens, Christian]

Kenneth,

The password file could be another reason for svrmgrl asking you a password.

Regards.

> -Mensaje original-
> De:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Enviado el:   miércoles 7 de marzo de 2001 19:07
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Re: Svrmgrl "connect internal" asks for password??
> 
> 
> Do you have a password file set up for the 8.1.6 database ? Check your
> init.ora file to see whether you have specified any password file to store
> the internal password (parameter remote_login_passwordfile ..
> 
> Thanks
> Riyaj "Re-yas" Shamsudeen
> Certified Oracle DBA
> i2 technologies   www.i2.com
> 
> 
>  
> 
> "Fowler, Kenneth R"
> 
> <[EMAIL PROTECTED]To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>  
> fizer.com>cc:
> 
> Sent by: [EMAIL PROTECTED] Subject: Svrmgrl
> "connect internal" asks for password??  
>  
> 
>  
> 
> 03/07/01 11:00 AM
> 
> Please respond to ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> List,
> 
> 
> I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl
> "connect internal" seems to want a password...
> 
> 
> Sun Microsystems Inc.   SunOS 5.8   Generic February 2000
> 
> 
> Configured oracle environment aliases...
> 
> Alias SID   Oracle Home
> - ---   ---
> dba816dba816/Volumes/app/oracle/product/8.1.6
> dba817dba817/Volumes/app/oracle/product/8.1.7
> 
> $ id
> uid=301(oracle) gid=300(dba)
> $ groups
> dba
> $ env | grep ORACLE
> ORACLE_BASE=/Volumes/app/oracle
> $ dba816
> dba816 $ env | grep ORACLE
> ORACLE_BASE=/Volumes/app/oracle
> ORACLE_SID=dba816
> ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
> dba816 $ cdcreate
> /Volumes/app/oracle/admin/dba816/create
> dba816 $ svrmgrl
> 
> Oracle Server Manager Release 3.1.6.0.0 - Production
> 
> Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> 
> Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.2.0 - Production
> 
> SVRMGR> connect internal;
> Password:
> Password:
> ORA-01031: insufficient privileges
> SVRMGR> ^D
> Server Manager complete.
> dba816 $ dba817
> dba817 $ env | grep ORACLE
> ORACLE_BASE=/Volumes/app/oracle
> ORACLE_SID=dba817
> ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
> dba817 $ cdcreate
> /Volumes/app/oracle/admin/dba817/create
> dba817 $ svrmgrl
> 
> Oracle Server Manager Release 3.1.7.0.0 - Production
> 
> Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
> 
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> 
> SVRMGR> connect internal;
> Connected.
> SVRMGR> ^D
> Server Manager complete.
> 
> 
> I know that the usual reason for this is that the account running svrmgrl
> is
> not a member of the appropriate unix group (usually "dba" or as specified
> at
> installation time) but this is not the case here.  On this server I have
> Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
> (Home = /Volumes/app/oracle/product/8.1.7).  My login script sets up
> aliases
> for each SID listed in /var/opt/oracle/oratab.  These aliases use the
> oraenv
> script with environment variable ORAENV_ASK=NO to set appropriate values
> for
> ORACLE_SID, ORACLE_HOME and PATH etc.  Other than that, the environment is
> exactly the same regardless of what SID I switch to (see log above).
> However "connect internal" asks for a password for Oracle 8.1.6 but does
> not
> ask for one for Oracle 8.1.7.  I am pretty sure that I specified that the
> group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue.
> 
> 
> Can anybody give me some pointers of other things to look at to try and
> resolve the problem???
> 
> 
> Thanks,
> Ken
> _
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026Fax: (860) 715-8346
> Email: [EMAIL PROTECTED]
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fowler, Kenneth R
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET

Bde-oracle

[GKor]

Hi all

Anyone using Nt authentication with oracle 8i and the Borland Database
Engine ?
We got the message invalid user 

oracle 817
BDE version 511

thanks

g. kor
rdw the netherlands
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: What database can I migrate to for Des/2000?

[Rod Corderey]

Hi

> this:  Can the Designer/2000 R2.1 repository be hosted in an 8.1.5

yes

In the past I have always had least trouble when migrating the repository
to a different server version by creating a new repository on the new server
then using "application/archive" in the RON. Archive the applications you want 
to move and then  restore them on the new server into the new repository again 
using the same tool under "application" in the RON

Different versions and patch releases seem to have varying issues with migrate
but I have never had a problem when restoring into a new repository.

The added advantage is that both repositories are still intact, if anything 
should go wrong in some other way - rollback space or whatever you can ditch and 
rerun.

Also this route works well when you want to move up a version as conversion is
normally done automatically by the restore process, again without touching your
original repository set.

> If I do have to upgrade Des/2000, what version do I have to upgrade
> to?

2.1 should connect to 8.1.5 with no issues, when using 2.1 we use 2.1.2
but mainly use 6.0 now.

good luck

Rod


-- 
Rod Corderey

Lane Associates
[EMAIL PROTECTED]
http://www.Lane-Associates.com


[EMAIL PROTECTED] wrote:
> 
> 
> 
> I have a 7.3.4 Oracle database (called CASE) on my Sun Solaris 2.6
> operating system that contains my Des/2000 R2.1 repository.
> 
> I'd like to migrate the 7.3.4 CASE database to 8.1.5.  My question is
> this:  Can the Designer/2000 R2.1 repository be hosted in an 8.1.5
> database?  If yes, do I have to migrate the repository as well or
> just the database?   If yes, can I migrate the 7.3.4 CASE database
> using the migration utility provided by Oracle.  Or do I need to
> do something special.
> 
> If I can migrate the database to 8.1.5, do I also have to upgrade
> the Des/2000 tool itself or will it still work with an 8.1.5 database.
> If I do have to upgrade Des/2000, what version do I have to upgrade
> to?
> 
> Thanks to anyone who can shed some light on this topic.
> 
> Cherie Machler
> Gelco Information Network
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Corderey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: error after creating second database

[Trassens, Christian]

An slightly correction. The script is pupbld.sql and the path is
$ORACLE_HOME/sqlplus/admin.

Sorry and regards.

> -Mensaje original-
> De:   C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 8 de marzo de 2001 4:57
> Para: Multiple recipients of list ORACLE-L
> Asunto:   Re: error after creating second database
> 
>  run pubbld.sql present in $ORACLE_HOME/sqlplus dir under system account
> in the second database
> --
> 
> On Tue, 06 Mar 2001 19:20:21  
>  Bambang Setiawan wrote:
> >Wahai Guys,
> >
> >I created second database using Database Assistant on NT.
> >There's no error when I create this 2nd DB.
> >Then I make a host-string name 'dblokal2' for my second database.
> >
> >I can connect to my second db , but there's an error :
> >the message written below :
> >
> >SQL> conn beng/bambang@dblokal2;
> >Error accessing PRODUCT_USER_PROFILE
> >Warning:  Product user profile information not loaded!
> >You may need to run PUPBLD.SQL as SYSTEM
> >Connected.
> >
> >why ? for there's no error when I create 2nd DB.
> >please help me to fix it ...
> >
> >
> >
> ><> Bambang Setiawan <>
> >
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >-- 
> >Author: Bambang Setiawan
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> 
> 
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: C.S.Venkata Subramanian
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle Date change

[Ramasamy, Baskar]

Hi,

Could any one tell me how to change the date and time in Oracle Database to
future rather than doing in unix server.

Baskar
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramasamy, Baskar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

table_privileges

[sinardyxing]

Hi guys,

Do you know what is the value "A" represented inside "coloum insert_priv" in
"table_privileges"?

Thank You

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Script from heaven

[SuzyV]

Data dictionary info: select * from dictionary ;
http://www.revealnet.com/Pipelines/DBA/archives/wpdbaerd.htm

Scripts & Docs
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=131418.1&blackframe=0
http://technet.oracle.com/deploy/performance/listing.htm


[EMAIL PROTECTED] wrote:
> 
> Hi guys,
> 
> I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
> dictionary view, do you have any scripts to share such as to display
> redologs, tablespaces, earlier potential problems detection?
> 
> Thank you so much..
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SuzyV
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Script from heaven

[Marin Dimitrov]

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 04:26


>
> Hi guys,
>
> I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data
> dictionary view, do you have any scripts to share such as to display
> redologs, tablespaces, earlier potential problems detection?
>


Try OraSnap from http://www.pobox.com/~dba/oracle/orasnap

hth,

Marin



"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


Herman Hesse, "Siddhartha"






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Which account do I need to change password besides system,sys and

[CHAN Chor Ling Catherine (CSC)]

Hi,

We are about to implement the HRMS 11I Applications.  

The password for the following accounts has to be changed : SYS, SYSTEM,
APPS (for HRMS 11I Applications)

Is there any account that I've missed out ? Please advise. Thanks.

Regds,
ChorLing
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to kill Oracle 7 processes in Open-VMS (STOP /ID command

[CHAN Chor Ling Catherine (CSC)]

Thanks, Paul. It works.

-Original Message-
From:   Paul Del Mastro [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, March 07, 2001 9:57 PM
To: CHAN Chor Ling Catherine (CSC)
Subject:Re: How to kill Oracle 7 processes in
Open-VMS (STOP /ID command does

I've always used STOP PROC/ID=x and not had a problem
-but I do not
know if this is different than STOP/ID=xx

"CHAN Chor Ling Catherine (CSC)" wrote:
> 
> Hi,
> 
> I tried to kill the following process with the command =>
stop /id=0432,
> the process is still there. Any ideas how to kill the
process ? Please
> advise.
> 
> DS9_DEVDBA> show system
> OpenVMS V7.1-2  on node NIEDS9   7-MAR-2001 10:10:11.73
Uptime  3 17:40:37
>   PidProcess NameState  Pri  I/O   CPU
Page flts
> Pages
> 0432 ORA_DEVC0429RWAST6  170   0
00:00:08.80  1202
> 537
> 
> 
> Regds,
> Chorling
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
> San Diego, California-- Public Internet access /
Mailing Lists
>

> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ORACLE-L
> (or the name of mailing list you want to be removed from).
You may
> also send the HELP command for other information (like
subscribing).

-- 
Paul  Del Mastro
City of Raleigh
222 W. Hargett Street
Raleigh, N.C. 27601
(919) 890-3018
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: session commits when PC crashes

[Rahul]

i tried out a few things too...
my PC is win95, and i;m running plus33, connecting to  8.1.5

1) when run plus33 from DOS WINDOW, the session DOES NOT commit when 
closed using ctrl+alt+del, task manager

2) when plus33W is executed, the session COMMIT ALWAYS, when the window
is closed (task manager, clicking 'x' )

3) in unix (rs/6000) the session DOES NOT commit when KILLED using kill -9 


Now my windows sql*plus is acting wierd should i turn on the tracing on
the client
to debug ? 

Rahul



> --
> From: Jeremiah Wilton[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 5:07 AM
> To:   Dan Rajkumar
> Cc:   Lazy DBA
> Subject:  Re: session commits when PC crashes
> 
> Rahul said that his data was getting committed when he closes the
> window.  This is definitely unexpected behavior.  It is true that if
> you exit properly from SQL*Plus after making DML changes but without
> committing, SQL*Plus will commit for you (improper behavior in my
> opinion, but at least it is documented).  It is not expected, however,
> that abnormal terminations (like closing the SQL*Plus window) should
> leave the data committed.
> 
> I was curious about this.  Here are some interesting scenarios I tried
> out, which basically show that closing the window does not leave the
> data committed.  Therefore, I'm still curious what application Rahul
> is using, because it doesn't sound like it is SQL*Plus.
> 
> 1. On Unix, using SQL*Plus v8.1.6:
> 
>  A. SQL> insert into jeremiah values ('a');
> SQL> exit
> Disconnected from Oracle8i...
> *COMMITTED*
> 
>  B. SQL> insert into jeremiah values ('a');
> (hit ++|)
> Quit (core dumped)
> *NOT COMMITTED*
> 
>  C. SQL> insert into jeremiah values ('a');
> (Terminate SQL*Plus by sending it a SIGTERM from another process)
> (kill -TERM 25461)
> Terminated
> *NOT COMMITTED*
> 
> 2. On Windows, using the SQL*Plus GUI (SQLPLUSW.EXE, v8.1.6):
> 
>  A. SQL> insert into jeremiah values ('a');
> SQL> exit
> *COMMITTED*
> 
>  B. SQL> insert into jeremiah values ('a');
> (Close the SQL*Plus window by clicking the "X" in the upper right
> corner)
> *NOT COMMITTED*
> 
>  C. SQL> insert into jeremiah values ('a');
> (Kill the SQL*Plus process by clicking "End Process" in the Task
> Manager)
> *NOT COMMITTED*
> 
> 3. On Windows, using the SQL*Plus DOS command line (SQLPLUS.EXE, v.8.1.6)
> 
>  A. SQL> insert into jeremiah values ('a');
> SQL> exit
> *COMMITTED*
> 
>  B. SQL> insert into jeremiah values ('a');
> (Close the DOS window by clicking the "X" in the upper right corner)
> *NOT COMMITTED*
> 
>  C. SQL> insert into jeremiah values ('a');
> (Kill the SQL*Plus process by clicking "End Process" in the Task
> Manager)
> *NOT COMMITTED*
> 
> --
> Jeremiah Wilton  http://www.wolfenet.com/~jeremiah
> 
> 
> On Wed, 7 Mar 2001, Dan Rajkumar wrote:
> 
> > Oracle will rollback the transaction only if there is an abnormal exit
> > during statement execution.  If you close your SQL worksheet/SQL*Plus
> > session while the insert is in progress (and therefore not complete),
> then
> > PMON will rollback the transaction.  In your case, the statement
> completed
> > normally.  Thus, even if you close the session without issuing the
> commit,
> > it will commit.
> > 
> > - Original Message -
> > From: Ashish Shah
> > 
> > sure it does. I just tested it through sqlplus and
> > also sql-worksheet. I inserted a row and close the
> > window without commit. row is there now !!
> > 
> > --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> > > On Tue, 6 Mar 2001, Rahul wrote:
> > >
> > > > the oracle session will commit if the session is
> > > > terminated by closing the window or re-booting 
> > > > the PC etc
> > > >
> > > > is there a way (parameter) to prevent this ?
> > >
> > > This should not happen.  What client software are
> > > you using?
> 
> 
> 
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED] 
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).