RE: Internal Password

[Ganesh Raja]

Title: Internal Password



Set 
ORACLE_SID Environment Variable to the instance u want to Connect to 
.
 
HTH
 
Best Regards, Ganesh R Tel  : +971 (4)  
397 3337 Ext 420 Fax : +971 (4)  397 
6262
HP  : +971 (50) 7456019

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 10:35 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Internal Password
  Hello Gurus 
  I have a problem in that I was always able to login 
  to svrmgrl on the consol and connect to internal, without having to give a 
  password.
  Yesterday however we had a massive mulfunction of 
  the UPS and all power was lost to the server room. Anyway the Win2k, compaq 8500R server recovered fine and so did the 
  Oracle DB 817. BUT, now connecting internal 
  demands a password, why? Also all known passwords do not work including the 
  default one. Can anyone shed some light on 
  what happened? and how can I fix it? 
  TIA Denham 
  Eva 
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  

Re: Blocking "illegal" connections

[Walter K]

Unfortunately, some of the Apps we have are "canned" and we don't have the
ability to modify them as suggested.

Any ideas on the trigger approach?

Thanks again!
-w

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


> A close workaround is with roles.  By default give
> everyone has 'create session' (so they at least log
> on), but any other privs they need come from a
> password protected role.
>
> The apps you write enable the role at login, so if
> anyone comes in not via an app, all they can do is
> login and nothing else...
>
> C
>
>  --- Walter K <[EMAIL PROTECTED]> wrote: > Hi,
> >
> > We're trying to prevent users from connecting to our
> > production database via "illegal" connections (i.e.
> > tools like TOAD, etc.).
> >
> > Does anyone have any suggestions on how to block
> > connections from query tools (i.e. Toad, SQL Nav,
> > etc.) in such a way that an error message is
> > reported
> > back to the tool user that the connection is
> > prohibited? We've tried designing a logon trigger
> > with
> > a PRAGMA definition but the error message is not
> > getting relayed back to the client.
> >
> > As always, your feedback is appreciated!
> > -w
> >
> > __
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for
> > all of
> > your unique holiday gifts! Buy at
> > http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Walter K
> >   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).
>
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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: Walter K
  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).

SQl Loader error sql*loader 704

[Girijan Puthran]

I am using Oracle version 8.1.6.3.0 on a sun 2.6 server and am getting the following 
error when trying to load a table using sql loader.

SQL*Loader-704: Internal error: Maximum record length must be <= [1000]

The problem occurs when I set the bindsize parameter value to > 1000 , the 
surprising fact is that the same load works fine on the devt version of the same 
database.The devt database are identical to the prod database settings.Metalink didn't 
prove to be much of a help and I was wondering if this is related to some kind of a 
bug. Any help would be greatly appreciated.

 
Girijan


--

This e-mail may contain confidential and/or privileged information. If you are not the 
intended recipient (or have received this e-mail in error) please notify the sender 
immediately and destroy this e-mail. Any unauthorized copying, disclosure or 
distribution of the material in this e-mail is strictly forbidden.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Girijan Puthran
  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).

Internal Password

[Denham Eva]

Title: Internal Password





Hello Gurus


I have a problem in that I was always able to login to svrmgrl on the consol and connect to internal, without having to give a password.

Yesterday however we had a massive mulfunction of the UPS and all power was lost to the server room.
Anyway the Win2k, compaq 8500R server recovered fine and so did the Oracle DB 817.
BUT, now connecting internal demands a password, why? Also all known passwords do not work including the default one.
Can anyone shed some light on what happened? and how can I fix it?


TIA
Denham Eva




This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com 

RE: SqlLoader

[Burton, Laura L.]

Title: SqlLoader



Thank 
you for your reply.  The user does have DBA rights and also owns the table 
that is being referenced.  If it was a table rights issue I would think I 
would have gotten 'table or view does not exist' message.  I don't think it 
is even getting connected to the 
database.
 
Laura

  -Original Message-From: Jeff Cox 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 12, 2001 5:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  SqlLoader
  Laura,
   
  The username that you are trying to use, does 
  this username own the table that is to be loaded, or does this username have 
  DBA privileges?
   
  Even though you can connect via sqlplus 
  and/or svrmgr to a session, this does not mean that you will be able to 
  load data into any table that you desire.
   
  HTH
   
  Regards,
   
  Jeff
  Tempe, AZ
  
- Original Message - 
From: 
Burton, 
Laura L. 
To: Multiple 
recipients of list ORACLE-L 
Sent: Wednesday, December 12, 2001 3:35 
PM
Subject: SqlLoader

I have never had a problem with sqlloader before, 
but now when I run it I get an error 'invalid name/password' message.  
I can sign on svrmgr and through sqlplus with no problems.
Any ideas? 
Thanks, Laura 

temporary tablespaces using temp files .. extents?

[Doug C]

From what I've heard, temporary tablespaces based on temporary files locally
managed have the following behavior..

They don't de-allocate extents necessarily, otherwise there would be overhead in
using them again, (just a bitmap after all)   (I am using 8.1.7 on AIX 4.3.3) 

So questions:
1) How do I see these allocated extents? dba_free_space isn't much help.   
dba_extents doesn't seem to be any help either. Neither does dba_segments.

I already know I can see things in action with v$sortsegment etc.,  but I was
under the impression that I once a temp extent was allocated (24x7 system).. it
stayed that way.   How can I see these?  I'm curious for a high water mark
(after a Discoverer install).. 

Of course, maybe smon really does clear them up at some point and they are all
gone as I am looking at these views.

Anyone want to chime in?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Doug C
  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 delete "myfile*" in unix

[Kimberly Smith]

try rm "myfile*"  

-Original Message-
Sent: Wednesday, December 12, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi,

I accitentaly create a file with * 

$ > myfile*

$ ls

myfile1
myfile2
myfile3
myfile*


how to delete myfile* without delete the rest of the file

* here is not a wildcard but system see this as a wildcard


Thank you
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  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: Oracle 8.1.7 desupport date

[Kimberly Smith]

Man, that's two years away.  Don't worry about it.  That is the
longest Oracle has supported a release for a long while.  Don't forget
that a desupport is just no more bug fixes.  Your chances of finding
new bugs after 2003 are rare (that haven't had a patch already developed
that is).

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 6:15 PM
To: Multiple recipients of list ORACLE-L



Oracle has announced ECS ends on 31-December-2003 for 8.1.7

I had expected 8.1.7 to continue to mid-2004  (it was released early/mid
2000 ?
and is the terminal 8i release).

Is there any possibility that the ECS date would be extended ?

We are just beginning to upgrade a few 7.3.4 and many 8.0.5/8.1.5/8.1.6
databases to 8.1.7 and are not yet looking at 9.0.1

Hemant


-- 
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: how delete "myfile*" in unix

[Arn Klammer]

two ways:

$ rm "myfile*"
or
$ rm myfile\*

>>> [EMAIL PROTECTED] 13/12/2001 13:30:18 >>>
This message has been scanned by MAILSweeper.


Hi,

I accitentaly create a file with * 

$ > myfile*

$ ls

myfile1
myfile2
myfile3
myfile*


how to delete myfile* without delete the rest of the file

* here is not a wildcard but system see this as a wildcard


Thank you
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Sinard Xing
  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).



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arn Klammer
  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: After logon trigger

[Ganesh Raja]

Hi Jared,

I just now Tried it and it was working.

But i have tried it in 8.1.6 and it has failed to execute for the users
granted the DBA Role.

Anyways when i checked at
http://asktom.oracle.com/pls/ask/f?p=4950:8:329387::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:1844531724208,%7BAfter%7D%20and%20%7BLogon%7D

This iw what he said.


This is the correct behavior and is designed to make it so your database
doesn't 
get into a state whereby NO ONE can log in (815 can get to that state).  It
is a 
feature.

My suggestion, don't use the DBA role.  Create your own ROLE (create many of

them in fact) YOUR_DBA and use that instead.  DBA is just a role (but a
special 
one).  If you don't use "DBA", you will be able to treat your DBA users as
if 
they were any ordinary user.


Your comments pls.


Best Regards, 
Ganesh R 
Tel  : +971 (4)  397 3337 Ext 420 
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019


-Original Message-
Sent: Thursday, December 13, 2001 1:56 AM
To: Multiple recipients of list ORACLE-L


I've done many tests and this is not right. It fires for users with DBA.

The only thing I remember (may be I'm dreaming )when I first used it in
8.1.5 on NT is that the logon trigger did not run under the user who is
logging on but under the pseudo process number 1.

This is not the case any more.

Regards

Waleed

-Original Message-
Sent: Wednesday, December 12, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L




Ganesh,

Are you sure about logon triggers not firing for users
with the DBA role enabled?

I've used them on 8.1.6 and 8.1.7, and they fire on
my DBA account.

Jared




 

Ganesh Raja


ulf.com> cc:

Sent by: Subject: RE: After logon
trigger   
[EMAIL PROTECTED]

om

 

 

12/11/01 11:30

PM

Please respond

to ORACLE-L

 

 





Create it Once not every time some one Logs in...

The table is notsimilar to temporary tables in SQl... They are Different..

The Table is visible to all sessions if u say they are Global temporary
Tables.

Yes Logon triggers Fire Every time the User logon... But the second time
onwards u will get a Error... The Logon triggers dont fire for Users with
the DBA Role Enabled.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337 Ext 420
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 12, 2001 11:00 AM
 To: Multiple recipients of list ORACLE-L
 Subject: After logon trigger


 Hi

 I am trying to use an after logon trigger to create a session temp
 table rather that create it at the time the procedure that uses it
 calls it. Two reasons for doing this is for performance ? the other is
 so that I can reference it in a cursor.

 1) Do logon triggers not work if I logon with toad or similar tools

 2) If 1 is wrong why when I have the following trigger in the database
 cant I see the table or use it after logging on

 TRIGGER create_temp_table
 AFTER LOGON ON DATABASE
 DECLARE
 v_CreateString VARCHAR2(100);
 BEGIN
 v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part
 NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS';
 EXECUTE IMMEDIATE  v_CreateString;

 END;

 TIA

 Peter McLarty   E-mail: [EMAIL PROTECTED]
 Technical ConsultantWWW: http://www.Mincom.com
 APAC Technical Services Phone: +61 (0)7 3303 3461
 Brisbane,  AustraliaMobile: +61 (0)402 094 238

 --Facsimile: +61 (0)7 3303
 3048

 --
 This transmission is for the intended addressee only and is
 confidential information. If you have received this transmission in
 error, please delete it and notify the sender. The contents of this
 e-mail are the opinion of the writer only and are not endorsed by the
 Mincom Group of companies unless expressly stated otherwise.



-- 
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: Khedr, Waleed
  INET

Re: how delete "myfile*" in unix

[hemantchitale]

Use the "\" character.
"rm myfile\*"

See :
apptest > cat >myfile*
here is the data in the file !
apptest > ls -l my*
-rw-r--r--   1 apptest  system31 Dec 13 12:08 myfile*
apptest > cat > myfile1
this is a good file
apptest > ls -l my*
-rw-r--r--   1 apptest  system31 Dec 13 12:08 myfile*
-rw-r--r--   1 apptest  system20 Dec 13 12:08 myfile1
apptest > rm myfile\*
apptest > ls -l my*
-rw-r--r--   1 apptest  system20 Dec 13 12:08 myfile1
apptest >

Hemant



"Sinard Xing" <[EMAIL PROTECTED]>13/12/2001 10:30 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)

 Subject: how delete "myfile*" in unix 

   

   

   






Hi,

I accitentaly create a file with *

$ > myfile*

$ ls

myfile1
myfile2
myfile3
myfile*


how to delete myfile* without delete the rest of the file

* here is not a wildcard but system see this as a wildcard


Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
  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).

how delete "myfile*" in unix

[Sinard Xing]

Hi,

I accitentaly create a file with * 

$ > myfile*

$ ls

myfile1
myfile2
myfile3
myfile*


how to delete myfile* without delete the rest of the file

* here is not a wildcard but system see this as a wildcard


Thank you
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  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 8.1.7 desupport date -- announced as Dec 2003

[hemantchitale]

Oracle has announced ECS ends on 31-December-2003 for 8.1.7

I had expected 8.1.7 to continue to mid-2004  (it was released early/mid
2000 ?
and is the terminal 8i release).

Is there any possibility that the ECS date would be extended ? What's your
feel / experience with previous desupport notices ?

We are just beginning to upgrade a few 7.3.4 and many 8.0.5/8.1.5/8.1.6
databases to 8.1.7 and are not yet looking at 9.0.1

Hemant



-- 
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).

Oracle 8.1.7 desupport date

[hemantchitale]

Oracle has announced ECS ends on 31-December-2003 for 8.1.7

I had expected 8.1.7 to continue to mid-2004  (it was released early/mid
2000 ?
and is the terminal 8i release).

Is there any possibility that the ECS date would be extended ?

We are just beginning to upgrade a few 7.3.4 and many 8.0.5/8.1.5/8.1.6
databases to 8.1.7 and are not yet looking at 9.0.1

Hemant


-- 
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: Blocking "illegal" connections

[Khedr, Waleed]

If you are trying to stop business users from connecting to the application
data using these tools then you need application authentication not database
authentication (application IDs not DB IDs).

But if you are only interested in stopping users from using "illegal" tools
then the only thing I could say Good Luck
except you're using n-tier where you can filter out connecting nodes.

Regards,

Waleed

-Original Message-
Sent: Wednesday, December 12, 2001 5:20 PM
To: Multiple recipients of list ORACLE-L


Hi,

We're trying to prevent users from connecting to our
production database via "illegal" connections (i.e.
tools like TOAD, etc.).

Does anyone have any suggestions on how to block
connections from query tools (i.e. Toad, SQL Nav,
etc.) in such a way that an error message is reported
back to the tool user that the connection is
prohibited? We've tried designing a logon trigger with
a PRAGMA definition but the error message is not
getting relayed back to the client.

As always, your feedback is appreciated!
-w

__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: Khedr, Waleed
  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 Compaq Tru64 certification

[Browett, Darren]

8.1.7 is certified for tru64 4.0d-g,5.0,5.0a,5.1 and 5.1a

It is in metalink.

Log into metalink
Choose "product lifecycle" from the side menu
Choose "certifications" button
Choose "by platform"

Then choose the platform and the Oracle product.



-Original Message-
Sent: December 12, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L


Does anyone know where to find which Oracle versions are certified for O/S
versions? Previously you could go to http://platforms.oracle.com, but that
now seems linked to the Oracle Partner Network, of which I am not a member.
I can't seem to find it on Metalink either.

What I am trying to determine is whether Oracle 8.1.7 is/will be certified
for Compaq Tru64 5.1

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Browett, Darren
  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: SqlLoader

[Jeff Cox]

Title: SqlLoader



Laura,
 
The username that you are trying to use, does this 
username own the table that is to be loaded, or does this username have DBA 
privileges?
 
Even though you can connect via sqlplus and/or 
svrmgr to a session, this does not mean that you will be able to load data 
into any table that you desire.
 
HTH
 
Regards,
 
Jeff
Tempe, AZ

  - Original Message - 
  From: 
  Burton, 
  Laura L. 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 12, 2001 3:35 
  PM
  Subject: SqlLoader
  
  I have never had a problem with sqlloader before, 
  but now when I run it I get an error 'invalid name/password' message.  I 
  can sign on svrmgr and through sqlplus with no problems.
  Any ideas? 
  Thanks, Laura 

Help on using bind variables asp web pages

[ARUN K C]

Hi,
Can anybody give me some examples as to how I can use bind variables in asp 
pages.
Here the developers are using static values for inserting and updating the 
data due to which the whole shared pool is filled with nothing insert and 
update statements.
They are not able to get any documents on this issue.
If anybody knows about this or point some urls,It will be of great help.
Thanks in advance




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ARUN K C
  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: Help on using bind variables asp web pages

[Jared . Still]

You may want to check support.microsoft.com.

There are some pages there that detail the use
of Oracle and ASP.

Jared



   
 
"ARUN K C" 
 

ail.com> cc:   
 
Sent by: Subject: Help on using bind variables asp 
web pages
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 02:55 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi,
Can anybody give me some examples as to how I can use bind variables in asp

pages.
Here the developers are using static values for inserting and updating the
data due to which the whole shared pool is filled with nothing insert and
update statements.
They are not able to get any documents on this issue.
If anybody knows about this or point some urls,It will be of great help.
Thanks in advance




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ARUN K C
  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: Blocking "illegal" connections

[Connor McDonald]

A close workaround is with roles.  By default give
everyone has 'create session' (so they at least log
on), but any other privs they need come from a
password protected role.

The apps you write enable the role at login, so if
anyone comes in not via an app, all they can do is
login and nothing else...

C

 --- Walter K <[EMAIL PROTECTED]> wrote: > Hi,
> 
> We're trying to prevent users from connecting to our
> production database via "illegal" connections (i.e.
> tools like TOAD, etc.).
> 
> Does anyone have any suggestions on how to block
> connections from query tools (i.e. Toad, SQL Nav,
> etc.) in such a way that an error message is
> reported
> back to the tool user that the connection is
> prohibited? We've tried designing a logon trigger
> with
> a PRAGMA definition but the error message is not
> getting relayed back to the client.
> 
> As always, your feedback is appreciated!
> -w
> 
> __
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> your unique holiday gifts! Buy at
> http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Walter K
>   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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: DB SIZE ?

[Scott Shafer]

delete data or drop tablespaces or resize datafiles.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 12:20 PM


> 
> hi
> Just a thought.How do we reduce Database size?
> Thanks
> -Seema
> 
> 
> _
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   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 your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: Instr function ?

[steven wndy]

I have this work in a SP now:

IF sep =1 THEN
select substr(EVFIELDS,1,instr(EVFIELDS,'^',1,1)-1)
into update_Text  
from c_eventout  where EVTYPE ='abc';
ELSE
select substr(EVFIELDS,
instr(EVFIELDS,'^',1,sep-1)+1, 

instr(EVFIELDS,'^',1,sep)-instr(EVFIELDS,'^',1,sep-1)-1)

into update_Text  
from c_eventout  where EVTYPE ='abc';
END IF;

Thanks for all the help

Steven
--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> Steven,
> 
> For a "pure" SQL solution, you can use INSTR to get
> the n'th occurrence of
> an item. So, you know item 2 is surrounded by the
> 1st and 2nd occurence,
> item 3 by the 2nd and 3rd occurence, etc. The SQL
> looks a little nasty but I
> took it down through item 9 for you to see:
> 
>   1  select substr(foo,1,instr(foo,'^',1,1)-1) f1,
>   2 substr(foo,instr(foo,'^',1,1)+1, -- find
> the first ^ and add 1
>   3   
> instr(foo,'^',1,2)-instr(foo,'^',1,1)-1) f2, -- find
> the second occurence minus the first occurence
>   4 substr(foo,instr(foo,'^',1,2)+1,
>   5   
> instr(foo,'^',1,3)-instr(foo,'^',1,2)-1) f3,
>   6 substr(foo,instr(foo,'^',1,3)+1,
>   7   
> instr(foo,'^',1,4)-instr(foo,'^',1,3)-1) f4,
>   8 substr(foo,instr(foo,'^',1,4)+1,
>   9   
> instr(foo,'^',1,5)-instr(foo,'^',1,4)-1) f5,
>  10 substr(foo,instr(foo,'^',1,5)+1,
>  11   
> instr(foo,'^',1,6)-instr(foo,'^',1,5)-1) f6,
>  12 substr(foo,instr(foo,'^',1,6)+1,
>  13   
> instr(foo,'^',1,7)-instr(foo,'^',1,6)-1) f7,
>  14 substr(foo,instr(foo,'^',1,7)+1,
>  15   
> instr(foo,'^',1,8)-instr(foo,'^',1,7)-1) f8,
>  16 substr(foo,instr(foo,'^',1,8)+1,
>  17   
> instr(foo,'^',1,9)-instr(foo,'^',1,8)-1) f9
>  18* from steven
> SQL> /
> 
> F1  F2  F3  F4  
>F5
> --- --- ---
> --- 
> ---
> F6  F7  F8  F9
> --- --- ---
> ---
> CIRCUITS1   12/31/01
>
> CIRCUITS
> 
> DESKTOP-01  333
>
> DESKTOP
> 
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of
> > steven wndy
> > Sent: Tuesday, December 11, 2001 5:50 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Instr function ?
> >
> >
> > Hello:
> >
> > My table has a column (EVFIELDS) contain the
> > concatenated information pass in (up to 20 fileds
> from
> > other tables which will be used to update into our
> > database), each piece of information will be
> separated
> > by ^ in this column and some info are nullable,
> then
> > the data for this column would be like:
> > 1/
> >
>
CIRCUITS1^^12/31/01^^CIRCUITS^
> > ^^
> >
> > 2/
> > DESKTOP-01^333^^^DESKTOP
> > ^^^
> >
> > The first example above I have data in pos1, pos3,
> > pos9, and others are NULL;
> > The second example there are data in pos1,
> pos2,pos9,
> > and others are NULL;
> >
> > I tried INSTR. But how do I find the start and end
> > points for the postion like pos3 or pos11?
> > In another word, how can I filter/select those
> data
> > out of these ^? Should I loop for the postion 1
> to
> > 2000? Any idea?
> >
> > Desc c_eventout:
> > EVTYPE VARCHAR2(64)
> > EVTIME DATE
> > EVUSER VARCHAR2(64)
> > EVFIELDS   VARCHAR2(2000)
> > EVSEPCHAR  VARCHAR2(1)
> >
> > Thanks for your reply
> >
> >
> > Steven
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Larry Elkins
>   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!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: steven wndy
  INET: [EMAIL PROTECTED]

Fat City Network Services  

Re: Architecture Options

[Peter . McLarty]

Hi

My thoughts are that there currently is no single best solution. I think that there is a number of systems that provide the best solution for that particular application. Like for example the application I am currently working on I just cant at present see where any middleware (Corba, AppServer etc) will provide any benefit. But there is other applications that will benefit greatly from using those products. 
Likewise I don't see any best method for doing the application front end. I do have a preference for Java, but I think Delphi, CBuilder or VB all can do a good job if the requirement is for only a Windows Desktop. Delphi here has one advantage in that you can use Kylix on Linux to recompile the Delphi source and create a Linux Desktop.

Also don't discount open source tools Perl, PHP Apache in your equation if a web model is part of your architecture solution

I think that if you have good application Architects then they will know the best fit for your application

HTH

Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






"Tracy Rahmlow" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
13/12/2001 07:25 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        Architecture Options


We are currently looking to create some new systems within our shop and
struggling to choose what the architecture should look.  Everything from
2-tier/n-tier, choice of middleware(whatever that is,since there appears to be
many definitions), presentation(browser based vs windows gui), app servers, web
servers, languages to use(vb, java, c++ ...) and when (eg write batch in pl/sql
procedures w/i the db or separate components that reside outside of the
database) yada yada yada.   Does anybody know of any sites where we can go to
obtain more information(points to consider, pros/cons) of particular
tools/languages/models to aid us in making our decisions.  Or am I living in a
dreamworld?  In other words, if there were no barriers(cost, training...)  how
would you design the archicture to support an oltp application of approximately
500 users, yet provide flexibility, scaleability and all those buzzwords.  In
addition, what would the architecture look like for integrating a datawarehouse
with an oltp environment?

Oh, by the way we have decided to continue to use Oracle, that is not on the
table.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  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).




-- 
This transmission is for the intended addressee only and is confidential information.  If you have received this transmission in error, please delete it and notify the sender.  The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

RE: export database from AIX to Sun

[Jeremiah Wilton]

Gopal,

Are all the datatype representations identical between solaris and HP
OS?  Are they both big-indian/little-indian?  I know you and I have
discussed this before - I actually requested Oracle to build a
migration utility that takes this approach.

As for CTAS over DB link, doesn't that do on e round trip per row?
That seems like it would be much slower than parallel unload/load over
named pipes / dd with large blocksizes over a fast network.  The
latter approach uses many fewer round trips

One advantage of CTAS over DB link is that the new tables can be
created NOLOGGING, which cannot be accomplished with import.
SQL*Loader, however can do parallel nologging loads, so I would say
the most supportable, most efficient method is parallel
unload/nologging sqlload over named pipes/dd/rsh/dd with large
blocksizes over a fast network.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 12 Dec 2001, K Gopalakrishnan wrote:

> Until Oracle or some one (guess who??) gives a tool, which reads the AIX
> datafiles and writes as Solaris Datafiles. IIRC we can copy the datafiles
> from Sun to HP (and HP to Sun) and use that, Not sure about Oracle Support's
> stand on these type of migrations.
>
> Other than these two, you can migrate the database using CTAS. (Create table
> as select over a dblink). This will be much faster than export and import
> (oracle Metalink has some statistics). This can be used if you have very
> few, huge tables.
>
> Best Regards,
> K Gopalakrishnan
> (408) 934 9310
>
>
> -Original Message-
> Carmichael
> Sent: Wednesday, December 12, 2001 12:10 PM
> To: Multiple recipients of list ORACLE-L
>
> okay let me modify my statement...
>
> that's the only SIMPLE way to do it
>
>
> --- [EMAIL PROTECTED] wrote:
> >
> > Unless of course you want to do it some other way, like dump to
> > flat files and use sqlloadder.  :)
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > Rachel
> >
> > Carmichael   To: Multiple recipients
> > of list ORACLE-L <[EMAIL PROTECTED]>
> >  >
> > ahoo.com>Subject: Re: export
> > database from AIX to Sun
> > Sent by:
> >
> > [EMAIL PROTECTED]
> >
> > om
> >
> >
> >
> >
> >
> > 12/12/01 09:50
> >
> > AM
> >
> > Please respond
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > in fact, that's the only way to move a database from one platform to
> > another.
> >
> >
> > --- mitchell <[EMAIL PROTECTED]> wrote:
> > > Hi Gurus:
> > >
> > > It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and
> > > imp to
> > > Sun Soloris 2.7 Oracle 8.1.7
> > > I have only done on same os. env before.
> > >
> > >
> > > Thanks in advance
> > > Mitchell
> > >
> > > --
> > > 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).
> >
> >
> > __
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for all of
> > your unique holiday gifts! Buy at http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   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 

Oracle Compaq Tru64 certification

[DENNIS WILLIAMS]

Does anyone know where to find which Oracle versions are certified for O/S
versions? Previously you could go to http://platforms.oracle.com, but that
now seems linked to the Oracle Partner Network, of which I am not a member.
I can't seem to find it on Metalink either.

What I am trying to determine is whether Oracle 8.1.7 is/will be certified
for Compaq Tru64 5.1

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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).

SqlLoader

[Burton, Laura L.]

Title: SqlLoader





I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message.  I can sign on svrmgr and through sqlplus with no problems.

Any ideas?


Thanks,
Laura

Blocking "illegal" connections

[Walter K]

Hi,

We're trying to prevent users from connecting to our
production database via "illegal" connections (i.e.
tools like TOAD, etc.).

Does anyone have any suggestions on how to block
connections from query tools (i.e. Toad, SQL Nav,
etc.) in such a way that an error message is reported
back to the tool user that the connection is
prohibited? We've tried designing a logon trigger with
a PRAGMA definition but the error message is not
getting relayed back to the client.

As always, your feedback is appreciated!
-w

__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: export database from AIX to Sun

[K Gopalakrishnan]

Until Oracle or some one (guess who??) gives a tool, which reads the AIX
datafiles and writes as Solaris Datafiles. IIRC we can copy the datafiles
from Sun to HP (and HP to Sun) and use that, Not sure about Oracle Support's
stand on these type of migrations.

Other than these two, you can migrate the database using CTAS. (Create table
as select over a dblink). This will be much faster than export and import
(oracle Metalink has some statistics). This can be used if you have very
few, huge tables.

Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
Carmichael
Sent: Wednesday, December 12, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L

okay let me modify my statement...

that's the only SIMPLE way to do it


--- [EMAIL PROTECTED] wrote:
>
> Unless of course you want to do it some other way, like dump to
> flat files and use sqlloadder.  :)
>
> Jared
>
>
>
>
>
>
> Rachel
>
> Carmichael   To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> 
> ahoo.com>Subject: Re: export
> database from AIX to Sun
> Sent by:
>
> [EMAIL PROTECTED]
>
> om
>
>
>
>
>
> 12/12/01 09:50
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> in fact, that's the only way to move a database from one platform to
> another.
>
>
> --- mitchell <[EMAIL PROTECTED]> wrote:
> > Hi Gurus:
> >
> > It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and
> > imp to
> > Sun Soloris 2.7 Oracle 8.1.7
> > I have only done on same os. env before.
> >
> >
> > Thanks in advance
> > Mitchell
> >
> > --
> > 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).
>
>
> __
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   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).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  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: After logon trigger

[Khedr, Waleed]

I've done many tests and this is not right. It fires for users with DBA.

The only thing I remember (may be I'm dreaming )when I first used it in
8.1.5 on NT is that the logon trigger did not run under the user who is
logging on but under the pseudo process number 1.

This is not the case any more.

Regards

Waleed

-Original Message-
Sent: Wednesday, December 12, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L




Ganesh,

Are you sure about logon triggers not firing for users
with the DBA role enabled?

I've used them on 8.1.6 and 8.1.7, and they fire on
my DBA account.

Jared




 

Ganesh Raja


ulf.com> cc:

Sent by: Subject: RE: After logon
trigger   
[EMAIL PROTECTED]

om

 

 

12/11/01 11:30

PM

Please respond

to ORACLE-L

 

 





Create it Once not every time some one Logs in...

The table is notsimilar to temporary tables in SQl... They are Different..

The Table is visible to all sessions if u say they are Global temporary
Tables.

Yes Logon triggers Fire Every time the User logon... But the second time
onwards u will get a Error... The Logon triggers dont fire for Users with
the DBA Role Enabled.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337 Ext 420
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 12, 2001 11:00 AM
 To: Multiple recipients of list ORACLE-L
 Subject: After logon trigger


 Hi

 I am trying to use an after logon trigger to create a session temp
 table rather that create it at the time the procedure that uses it
 calls it. Two reasons for doing this is for performance ? the other is
 so that I can reference it in a cursor.

 1) Do logon triggers not work if I logon with toad or similar tools

 2) If 1 is wrong why when I have the following trigger in the database
 cant I see the table or use it after logging on

 TRIGGER create_temp_table
 AFTER LOGON ON DATABASE
 DECLARE
 v_CreateString VARCHAR2(100);
 BEGIN
 v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part
 NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS';
 EXECUTE IMMEDIATE  v_CreateString;

 END;

 TIA

 Peter McLarty   E-mail: [EMAIL PROTECTED]
 Technical ConsultantWWW: http://www.Mincom.com
 APAC Technical Services Phone: +61 (0)7 3303 3461
 Brisbane,  AustraliaMobile: +61 (0)402 094 238

 --Facsimile: +61 (0)7 3303
 3048

 --
 This transmission is for the intended addressee only and is
 confidential information. If you have received this transmission in
 error, please delete it and notify the sender. The contents of this
 e-mail are the opinion of the writer only and are not endorsed by the
 Mincom Group of companies unless expressly stated otherwise.



-- 
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: Khedr, Waleed
  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: select data using trigger

[DENNIS WILLIAMS]

Kevin Loney, the noted Oracle author recently presented some studies he did
on this issue at our TCOUG meeting. In a nutshell, his results were:
- If the table has no indexes and you create one, the insert rate
will drop to about 30% of initial.
- As each successive index is added, the insert rate will decrease.
However the amount of decrease will be smaller.
  - Bottom line: If your table has one index, adding another will
slightly decrease performance. If your table already has 15 indexes, one
more index ain't gonna matter much. 
  - There is no "threshold" where performance suddenly drops off.

My apologies to Kevin if I have misrepresented his findings. He presented
much more analysis and I really appreciated his work. I look forward to
their inclusion in a future book.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, December 11, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L


Well ...

According to a document on Metalink .. it is pretty safe to assume the cost
of a DML action on an index as 3 times of that of on the table. So, if
inserting one record costs you one unit, on your table with 15 indexes it
would be  

(1 * 1 table) + (3 * 15 indexes) = 46 units.

And this is for each row ...

HTH
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!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: export database from AIX to Sun

[Jared . Still]

http://sun.systemnews.com/system-news/jobdir/submitted/2001.05/3444/3444.html
http://www.dhbrown.com

Jared



   
 
Kevin Lange
 
<[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
om>  cc:   
 
Sent by: Subject: RE: export database from AIX to 
Sun   
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 12:45 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I am with Mitchell.I still say AIX is the best of the two .   I don't
case what Solaris is adding and I don't care how developer friendly.
>From an Admin point of view I see no comparison.

And who the heck is D. H. Brown and why should I listen to their reports ??

-Original Message-
Sent: Wednesday, December 12, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L



I still prefer Aix for it logical volume manager as well as support from
IBM
that is much better then Sun and Oracle.  I think Oracle is the worst on
serive support.  Hope my opinion is not offending anybody here.

Mitchell

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


>
> Kevin,
>
> Keep up on your D.H. Brown reports!  :)
>
> Solaris surpassed AIX this year.  I used to feel the same
> way from the admin sense of AIX, but Solaris is much more
> developer friendly than AIX.
>
> IBM seems to be favoring Linux now anyway.
>
> Jared
>
>
>
>
> Kevin Lange
> <[EMAIL PROTECTED]   To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> om>  cc:
> Sent by: Subject: RE: export database
from AIX to Sun
> [EMAIL PROTECTED]
> om
>
>
> 12/12/01 10:00
> AM

> Please respond
> to ORACLE-L
>
>
>
>
>
>
> first of all ...  WHY would you want to leave AIX for SUN
> ...  What a step down .
>
> Second  An Export file is an Export file is an Export file . or
so
> its said.
>
> The export should be the same for all OS's so it should work on whatever
OS
> you decide to move it to.  Only difference might be limits on the OS as
to
> file size.
>
> -Original Message-
> Sent: Wednesday, December 12, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus:
>
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
>
>
> Thanks in advance
> Mitchell
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California  

Re: Recommenations for a DB conversion using SQL Loaderf

[orantdba]

Hi Ken,

You will use the exceptions into when re-enabling your constratings.

--John

[EMAIL PROTECTED] wrote:

>Thanks for the info.  I looked in Oracle8i Utilities in the SQL Loader
>section and could not find anything about the 'exceptions into' clause.
>
>Where should I look?
>
>Thanks,
>Ken
>
>
> -Original Message-
>Sent:   Wednesday, December 12, 2001 12:41 PM
>To: Multiple recipients of list ORACLE-L
>Subject:Re: Recommenations for a DB conversion using SQL Loaderf
>
>
>
>Ken,
>
>That's one way to do it.  If your data is very large it will make the
>loading much faster.
>
>You can alleviate this by loading the tables in order of parents
>first.  If you don't have an database diagram you can generate
>this information from dba_constraints.
>
>The easiest way is probably to disable the constraints, load
>the data, then enable the constraints.
>
>Be sure to thouroghly read the fine manual regarding constraints,
>particularly the 'exceptions into' clause.
>
>By redirecting exception rowids into another table you can
>easily determine any rows that are causing a problem.
>
>The way I do it if there is a lot of data and constraints to deal
>with is to send exceptions to an exceptions table, move any
>exception rows to another table, enable the constraint, and
>then determine why the exception rows were excepted,
>correct the problem and insert the row.
>
>I haven't done this for awhile, and there may be new features
>in 'ALTER TABLE ENABLE CONSTRAINT' that would change
>this scenario somewhat, hence the RTFM.
>
>HTH
>
>Jared
>
>
>
>
> 
>
>Ken Janusz
>
>ORACLE-L <[EMAIL PROTECTED]>
>fsys.com>cc:
>
>Sent by: Subject: Recommenations for a
>DB conversion using SQL Loaderf  
>[EMAIL PROTECTED]
>
>om
>
> 
>
> 
>
>12/12/01 08:45
>
>AM
>
>Please respond
>
>to ORACLE-L
>
> 
>
> 
>
>
>
>
>
>I am working on a one time DB conversion project for a state government
>entity.  I have a DB (8.1.7 on W2000 server) setup without the application
>SW that I am using to load the data into from flat files.  When I get this
>data loaded I will then load it into the production tables at the client
>site.  I will not be running any applications on this DB, it's for
>conversion purposes only.  I am running into some constraint violation
>problems since I am loading the data to each table one at a time.  Would it
>be prudent to disable the constraints until I get all the data loaded?
>Any and all suggestions are welcome.
>Ken
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ken Janusz
>  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: orantdba
  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).

Architecture Options

[Tracy Rahmlow]

We are currently looking to create some new systems within our shop and
struggling to choose what the architecture should look.  Everything from
2-tier/n-tier, choice of middleware(whatever that is,since there appears to be
many definitions), presentation(browser based vs windows gui), app servers, web
servers, languages to use(vb, java, c++ ...) and when (eg write batch in pl/sql
procedures w/i the db or separate components that reside outside of the
database) yada yada yada.   Does anybody know of any sites where we can go to
obtain more information(points to consider, pros/cons) of particular
tools/languages/models to aid us in making our decisions.  Or am I living in a
dreamworld?  In other words, if there were no barriers(cost, training...)  how
would you design the archicture to support an oltp application of approximately
500 users, yet provide flexibility, scaleability and all those buzzwords.  In
addition, what would the architecture look like for integrating a datawarehouse
with an oltp environment?

Oh, by the way we have decided to continue to use Oracle, that is not on the
table.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  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 view for hidden objects

[Seema Singh]

Which view is used to see hidden tables?
Thanks
-Seema



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Outer join sql SOLVED!

[Johnston, Steve]

Brian and all, thanks for the help, here is the sql that does what I wanted to do!  
This gives me all the leave types in table 'a' and either a sum or null for values 
from table 'b'.  Thanks again!

SELECT
a.LEAVE_CATEG_ID,
a.LEAVE_TYPE_CD,
a.LPET_LONG_DD, 
Sum(l.ORIGINAL_INPUT_AM)
 FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
WHERE a.LEAVE_TYPE_CD = l.evnt_type_cd(+) 
AND l.INTERNAL_EMPL_ID(+)='000357'
AND l.EFFECTIVE_DT(+) Between TO_DATE('01/01/2001','MM/DD/') 
And TO_DATE('12/31/2001','MM/DD/')
GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD


-- Original Message --
Reply-To: [EMAIL PROTECTED]
Date: Wed, 12 Dec 2001 10:15:33 -0800

>SELECT a.LEAVE_CATEG_ID,
>a.LEAVE_TYPE_CD,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Steve
  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: Recommenations for a DB conversion using SQL Loaderf

[Jared . Still]

'ALTER TABLE' and the 'constraint clause' in the SQL reference.

Jared




   
 
Ken Janusz 
 

fsys.com>cc:   
 
Sent by: Subject: RE: Recommenations for a DB 
conversion using SQL Loaderf  
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 11:40 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Thanks for the info.  I looked in Oracle8i Utilities in the SQL Loader
section and could not find anything about the 'exceptions into' clause.

Where should I look?

Thanks,
Ken


 -Original Message-
Sent:   Wednesday, December 12, 2001 12:41 PM
To:Multiple recipients of list ORACLE-L



Ken,

That's one way to do it.  If your data is very large it will make the
loading much faster.

You can alleviate this by loading the tables in order of parents
first.  If you don't have an database diagram you can generate
this information from dba_constraints.

The easiest way is probably to disable the constraints, load
the data, then enable the constraints.

Be sure to thouroghly read the fine manual regarding constraints,
particularly the 'exceptions into' clause.

By redirecting exception rowids into another table you can
easily determine any rows that are causing a problem.

The way I do it if there is a lot of data and constraints to deal
with is to send exceptions to an exceptions table, move any
exception rows to another table, enable the constraint, and
then determine why the exception rows were excepted,
correct the problem and insert the row.

I haven't done this for awhile, and there may be new features
in 'ALTER TABLE ENABLE CONSTRAINT' that would change
this scenario somewhat, hence the RTFM.

HTH

Jared






Ken Janusz


fsys.com>cc:

Sent by: Subject: Recommenations for a
DB conversion using SQL Loaderf
[EMAIL PROTECTED]

om





12/12/01 08:45

AM

Please respond

to ORACLE-L









I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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   

RE: Recommenations for a DB conversion using SQL Loaderf

[Rachel Carmichael]

it's not sql loader -- it's part of the sql command to enable the
constraint

look at 'alter table' in the SQL manual

--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> Thanks for the info.  I looked in Oracle8i Utilities in the SQL
> Loader
> section and could not find anything about the 'exceptions into'
> clause.
> 
> Where should I look?
> 
> Thanks,
> Ken
> 
> 
>  -Original Message-
> Sent: Wednesday, December 12, 2001 12:41 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Recommenations for a DB conversion using SQL Loaderf
> 
> 
> 
> Ken,
> 
> That's one way to do it.  If your data is very large it will make the
> loading much faster.
> 
> You can alleviate this by loading the tables in order of parents
> first.  If you don't have an database diagram you can generate
> this information from dba_constraints.
> 
> The easiest way is probably to disable the constraints, load
> the data, then enable the constraints.
> 
> Be sure to thouroghly read the fine manual regarding constraints,
> particularly the 'exceptions into' clause.
> 
> By redirecting exception rowids into another table you can
> easily determine any rows that are causing a problem.
> 
> The way I do it if there is a lot of data and constraints to deal
> with is to send exceptions to an exceptions table, move any
> exception rows to another table, enable the constraint, and
> then determine why the exception rows were excepted,
> correct the problem and insert the row.
> 
> I haven't done this for awhile, and there may be new features
> in 'ALTER TABLE ENABLE CONSTRAINT' that would change
> this scenario somewhat, hence the RTFM.
> 
> HTH
> 
> Jared
> 
> 
> 
> 
>  
> 
> Ken Janusz
> 
>  of list
> ORACLE-L <[EMAIL PROTECTED]>
> fsys.com>cc:
> 
> Sent by: Subject: Recommenations
> for a
> DB conversion using SQL Loaderf  
> [EMAIL PROTECTED]
> 
> om
> 
>  
> 
>  
> 
> 12/12/01 08:45
> 
> AM
> 
> Please respond
> 
> to ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> I am working on a one time DB conversion project for a state
> government
> entity.  I have a DB (8.1.7 on W2000 server) setup without the
> application
> SW that I am using to load the data into from flat files.  When I get
> this
> data loaded I will then load it into the production tables at the
> client
> site.  I will not be running any applications on this DB, it's for
> conversion purposes only.  I am running into some constraint
> violation
> problems since I am loading the data to each table one at a time. 
> Would it
> be prudent to disable the constraints until I get all the data
> loaded?
> Any and all suggestions are welcome.
> Ken
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   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: Ken Janusz
>   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!?
Check out Ya

which view used ?

[Seema Singh]

Hi
which view is used to see all tables in database?I think all_all_tables 
right? Including v$ and x$ tables
Thanks
-seema


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: DB SIZE ?

[Jack C. Applewhite]

Seema,

Several possible solutions - you pick.

- Delete Data
- Drop Tables
- Drop Indexes
- Drop Tablespaces

That ought to get you started.  ;-)

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Sent: Wednesday, December 12, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L



hi
Just a thought.How do we reduce Database size?
Thanks
-Seema



-- 
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: export database from AIX to Sun

[Kevin Lange]

I am with Mitchell.I still say AIX is the best of the two .   I don't
case what Solaris is adding and I don't care how developer friendly.
>From an Admin point of view I see no comparison.  

And who the heck is D. H. Brown and why should I listen to their reports ??

-Original Message-
Sent: Wednesday, December 12, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L



I still prefer Aix for it logical volume manager as well as support from IBM
that is much better then Sun and Oracle.  I think Oracle is the worst on
serive support.  Hope my opinion is not offending anybody here.

Mitchell

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


>
> Kevin,
>
> Keep up on your D.H. Brown reports!  :)
>
> Solaris surpassed AIX this year.  I used to feel the same
> way from the admin sense of AIX, but Solaris is much more
> developer friendly than AIX.
>
> IBM seems to be favoring Linux now anyway.
>
> Jared
>
>
>
>
> Kevin Lange
> <[EMAIL PROTECTED]   To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> om>  cc:
> Sent by: Subject: RE: export database
from AIX to Sun
> [EMAIL PROTECTED]
> om
>
>
> 12/12/01 10:00
> AM

> Please respond
> to ORACLE-L
>
>
>
>
>
>
> first of all ...  WHY would you want to leave AIX for SUN
> ...  What a step down .
>
> Second  An Export file is an Export file is an Export file . or so
> its said.
>
> The export should be the same for all OS's so it should work on whatever
OS
> you decide to move it to.  Only difference might be limits on the OS as to
> file size.
>
> -Original Message-
> Sent: Wednesday, December 12, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus:
>
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
>
>
> Thanks in advance
> Mitchell
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTE

PVCS and Oracle PL/SQL code

[Jamadagni, Rajendra]

Hi,

I'd like to hear from people who use PVCS to manage their pl/sql source
code. I am very much interested in finding if you use branching/merging for
code in development and maintenance mode. I know this (creating branches and
merging branches) can be done for text files, just want to get some feedback
from someone who has been through this.

BTW can this be done for FMBs? I don't think so, but I have been asked this
question.

Thanks again
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!




*2

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 corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

Re: Recommenations for a DB conversion using SQL Loader

[Stephen Andert]

Depending on how much data you have, look at doing a little tuning of
the BINDSIZE and ROWS parameters. Send me a personal e-mail if you want
more information on that.


Stephen Andert
Scottsdale, Arizona
>>> [EMAIL PROTECTED] 12/12/01 11:35 AM >>>
Ken,

A few things you could try here:

1) disable the foreign key constraints for the load
or
2) load the parent tables before the child tables

If you have a huge amount, you might want to consider dropping all of
the
indexes, except for the primary and unique key constraints.  (I don't
like
to take chances when it comes to data integrity.)  This would save you a
boatload of time.

Regards,

Jeff

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 9:45 AM


I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the
application
SW that I am using to load the data into from flat files.  When I get
this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would
it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  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: export database from AIX to Sun

[mitchell]

I still prefer Aix for it logical volume manager as well as support from IBM
that is much better then Sun and Oracle.  I think Oracle is the worst on
serive support.  Hope my opinion is not offending anybody here.

Mitchell

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


>
> Kevin,
>
> Keep up on your D.H. Brown reports!  :)
>
> Solaris surpassed AIX this year.  I used to feel the same
> way from the admin sense of AIX, but Solaris is much more
> developer friendly than AIX.
>
> IBM seems to be favoring Linux now anyway.
>
> Jared
>
>
>
>
> Kevin Lange
> <[EMAIL PROTECTED]   To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> om>  cc:
> Sent by: Subject: RE: export database
from AIX to Sun
> [EMAIL PROTECTED]
> om
>
>
> 12/12/01 10:00
> AM

> Please respond
> to ORACLE-L
>
>
>
>
>
>
> first of all ...  WHY would you want to leave AIX for SUN
> ...  What a step down .
>
> Second  An Export file is an Export file is an Export file . or so
> its said.
>
> The export should be the same for all OS's so it should work on whatever
OS
> you decide to move it to.  Only difference might be limits on the OS as to
> file size.
>
> -Original Message-
> Sent: Wednesday, December 12, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus:
>
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
>
>
> Thanks in advance
> Mitchell
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   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: 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).

Re: export database from AIX to Sun

[Rachel Carmichael]

okay let me modify my statement...

that's the only SIMPLE way to do it


--- [EMAIL PROTECTED] wrote:
> 
> Unless of course you want to do it some other way, like dump to
> flat files and use sqlloadder.  :)
> 
> Jared
> 
> 
> 
> 
>  
>   
> Rachel   
>   
> Carmichael   To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
>
> ahoo.com>Subject: Re: export
> database from AIX to Sun   
> Sent by: 
>   
> [EMAIL PROTECTED]   
>   
> om   
>   
>  
>   
>  
>   
> 12/12/01 09:50   
>   
> AM   
>   
> Please respond   
>   
> to ORACLE-L  
>   
>  
>   
>  
>   
> 
> 
> 
> 
> in fact, that's the only way to move a database from one platform to
> another.
> 
> 
> --- mitchell <[EMAIL PROTECTED]> wrote:
> > Hi Gurus:
> >
> > It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and
> > imp to
> > Sun Soloris 2.7 Oracle 8.1.7
> > I have only done on same os. env before.
> >
> >
> > Thanks in advance
> > Mitchell
> >
> > --
> > 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).
> 
> 
> __
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   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).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://a

Re: Costs in explain plan

[Greg Moore]

>> costs that are displayed in explain plan

Jonathan Lewis has an interesting set of examples of explain plans and
discusses the Cost of each step in his book, Practical Oracle, starting on
page 131.

If a step for an index has (Cost=3 Card=5) this means Oracle expects to
access 3 blocks (header block, branch block and leaf block of the index) and
is looking to identify 5 rows.  Oracle is predicting that all 5 rows will be
in a single index leaf block.

If the step just above this one, for the table access, has (Cost=8 Card=5)
this means Oracle expects to access a total of 8 blocks, consisting of the
original 3 for the index step plus another 5 from the table.  Oracle is
predicting that the 5 table rows will be in 5 different table blocks.

Lewis presents this material using phrases like "I am inclined to believe"
and "I assume" so apparently this description is based on his examination of
many plans and his deductions about how to interpret these numbers.  Still,
he provides several examples that are clearly explained and he concludes
that it is simple math and that's it's possible to understand the
calculations Oracle is making.

It's up to you to know whether the blocks are likely to be in memory or not
(index header and branch blocks on a frequently accessed index - probably
yes).

These are Oracle's best estimates based on the statistics available.  It may
turn out differently, e.g., all the table rows may be in a single block.

The interesting point about his explanation is how different it is from what
appears elsewhere.  Some authors are quite vague, implying that Cost is a
number with no meaning, and they conclude that you can't compare the cost
for two different SQL's.  Lewis seems to disagree 100%.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  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: Recommenations for a DB conversion using SQL Loaderf

[Ken Janusz]

Thanks for the info.  I looked in Oracle8i Utilities in the SQL Loader
section and could not find anything about the 'exceptions into' clause.

Where should I look?

Thanks,
Ken


 -Original Message-
Sent:   Wednesday, December 12, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Recommenations for a DB conversion using SQL Loaderf



Ken,

That's one way to do it.  If your data is very large it will make the
loading much faster.

You can alleviate this by loading the tables in order of parents
first.  If you don't have an database diagram you can generate
this information from dba_constraints.

The easiest way is probably to disable the constraints, load
the data, then enable the constraints.

Be sure to thouroghly read the fine manual regarding constraints,
particularly the 'exceptions into' clause.

By redirecting exception rowids into another table you can
easily determine any rows that are causing a problem.

The way I do it if there is a lot of data and constraints to deal
with is to send exceptions to an exceptions table, move any
exception rows to another table, enable the constraint, and
then determine why the exception rows were excepted,
correct the problem and insert the row.

I haven't done this for awhile, and there may be new features
in 'ALTER TABLE ENABLE CONSTRAINT' that would change
this scenario somewhat, hence the RTFM.

HTH

Jared




 

Ken Janusz


fsys.com>cc:

Sent by: Subject: Recommenations for a
DB conversion using SQL Loaderf  
[EMAIL PROTECTED]

om

 

 

12/12/01 08:45

AM

Please respond

to ORACLE-L

 

 





I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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: Ken Janusz
  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: export database from AIX to Sun

[Jared . Still]

Kevin,

Keep up on your D.H. Brown reports!  :)

Solaris surpassed AIX this year.  I used to feel the same
way from the admin sense of AIX, but Solaris is much more
developer friendly than AIX.

IBM seems to be favoring Linux now anyway.

Jared



   
 
Kevin Lange
 
<[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
om>  cc:   
 
Sent by: Subject: RE: export database from AIX to 
Sun   
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 10:00 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




first of all ...  WHY would you want to leave AIX for SUN
...  What a step down .

Second  An Export file is an Export file is an Export file . or so
its said.

The export should be the same for all OS's so it should work on whatever OS
you decide to move it to.  Only difference might be limits on the OS as to
file size.

-Original Message-
Sent: Wednesday, December 12, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus:

It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
Sun Soloris 2.7 Oracle 8.1.7
I have only done on same os. env before.


Thanks in advance
Mitchell

--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
  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: Recommenations for a DB conversion using SQL Loader

[Loughmiller, Greg]

Previous conversion that we did-we also built the indexes after the data was
there.. we had a ton of data.. And it was 3x faster to build the indexes and
add constraints after the data got to the "destination"..

Greg

-Original Message-
Sent: Wednesday, December 12, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L


Ken,

A few things you could try here:

1) disable the foreign key constraints for the load
or
2) load the parent tables before the child tables

If you have a huge amount, you might want to consider dropping all of the
indexes, except for the primary and unique key constraints.  (I don't like
to take chances when it comes to data integrity.)  This would save you a
boatload of time.

Regards,

Jeff

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 9:45 AM


I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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: JeffCox
  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: Loughmiller, Greg
  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: Strip Sizes

[Todd Carlson]

Thanks.

Todd


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L



-- Todd Carlson <[EMAIL PROTECTED]> on 12/12/01 08:50:26 -0800

> I have a box (HP) with three controllers, not including the OS, with 3
> 18 gig disks each. The app is for testing our product's load times in
an
> insert intensive environment. With RAID 0, what OS block and stripe
size
> should I use with an 8k Oracle Block size?
> 
> I have been reading Oracle Performance Tuning 101, but before I
> implement anything I want the opinion of the list.

If you can make the stripe == system i/o page (variable on HP)
then you'll get the best throughput. If Oracle is stuck with
8K page I/O then use an 8k stripe (e.g., 4 PV's at 2K each).


--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Todd Carlson
  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: export database from AIX to Sun

[Jared . Still]

Unless of course you want to do it some other way, like dump to
flat files and use sqlloadder.  :)

Jared




   
 
Rachel 
 
Carmichael   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: Re: export database from AIX to 
Sun   
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 09:50 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




in fact, that's the only way to move a database from one platform to
another.


--- mitchell <[EMAIL PROTECTED]> wrote:
> Hi Gurus:
>
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and
> imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
>
>
> Thanks in advance
> Mitchell
>
> --
> 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).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  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[2]: Converting UPU Licenses

[Robert Eskridge]

Gene,

Perhaps I'm not looking at it right.  I can find current pricing on
that page but not how to convert existing UPU licenses.

For example, lets say someone had a 2x300mhz Sun Sparc and last year
licensed the appropriate 2x300x1.5=900 UPU's. Now they are pricing out
what it would take to upgrade the processor to 4x400mhz cpu's. Under
the UPU scheme you'd just say the new one is 4x400x1.5=2400 UPU's so
you would need to purchase licenses for an additional 2400-900=1500
UPU's.

Under the new scheme what does one do?  Just purchase two new
processor licenses?  The phrase "formula to convert" in the press
release hints otherwise.  I suspect that some X UPU's = 1 processor
license

-rje

G> try this site:
G> 
https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&respid=22372

 [EMAIL PROTECTED] 12/12/01 12:50PM >>>
bry> Hello everyone.  I've been off the list for a while, so I hope this
bry> subject hasn't been beaten to death while I was gone.  I did some
bry> searches in the archives but didn't come up with anything.

bry> When Oracle announced the new $15,000/$40,000 per CPU pricing back in
bry> June, the announcement said there would be an "easy formula to convert
bry> UPU's" to the new scheme within a week.  Unfortunately I can't find
bry> that formula.  Does anyone have it?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Eskridge
  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: Outer join sql help?

[Johnston, Steve]

I want to show all the available leave types in table "a" even if there are no records 
in table "l"

-- Original Message --
Reply-To: [EMAIL PROTECTED]
Date: Wed, 12 Dec 2001 10:15:33 -0800

>SELECT a.LEAVE_CATEG_ID,
>a.LEAVE_TYPE_CD,
>a.LPET_LONG_DD, 
>Sum(l.ORIGINAL_INPUT_AM)
>  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
> WHERE a.LEAVE_TYPE_CD(+) = l.evnt_type_cd
>   AND l.INTERNAL_EMPL_ID='000357'
>   AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
>  And TO_DATE('12/31/2001','MM/DD/')
> GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;
>
>This should work if you are looking for LEAVE_DETL_TBL records without
>records in EFF_LEVPOL_EVNT_TYPE, which does not sound right.
>
>I'm thinking you want the "a" records even when there is no supporting "l"
>records:
>SELECT a.LEAVE_CATEG_ID,
>a.LEAVE_TYPE_CD,
>a.LPET_LONG_DD, 
>Sum(l.ORIGINAL_INPUT_AM)
>  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
> WHERE l.LEAVE_TYPE_CD(+) = a.evnt_type_cd
>   AND l.INTERNAL_EMPL_ID(+) = '000357'
>   AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
>  And TO_DATE('12/31/2001','MM/DD/')
> GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;
>
>But then the date range gives you a problem, so:
>SELECT a.LEAVE_CATEG_ID,
>a.LEAVE_TYPE_CD,
>a.LPET_LONG_DD, 
>Sum(decode(sign(l.EFFECTIVE_DT -
>TO_DATE('01/01/2001','MM/DD/'),
>  1,0,NULL,0,
>  decode(l.EFFECTIVE_DT -
>TO_DATE('12/31/2001','MM/DD/'),
>1, 0 , l.ORIGINAL_INPUT_AM
>  )  )  )
>  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
> WHERE l.LEAVE_TYPE_CD(+) = a.evnt_type_cd
>   AND l.INTERNAL_EMPL_ID(+) = '000357'
> GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;
>
>Nasty - or is my initial guess off base?
>
>Brian Norrell
>Manager, MPI Development
>QuadraMed
>511 E John Carpenter Frwy, Su 500
>Irving, TX 75062
>(972) 831-6600
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Norrell, Brian
>  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: Johnston, Steve
  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: After logon trigger

[Jared . Still]

Ganesh,

Are you sure about logon triggers not firing for users
with the DBA role enabled?

I've used them on 8.1.6 and 8.1.7, and they fire on
my DBA account.

Jared




   
 
Ganesh Raja
 

ulf.com> cc:   
 
Sent by: Subject: RE: After logon trigger  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/11/01 11:30 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Create it Once not every time some one Logs in...

The table is notsimilar to temporary tables in SQl... They are Different..

The Table is visible to all sessions if u say they are Global temporary
Tables.

Yes Logon triggers Fire Every time the User logon... But the second time
onwards u will get a Error... The Logon triggers dont fire for Users with
the DBA Role Enabled.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337 Ext 420
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 12, 2001 11:00 AM
 To: Multiple recipients of list ORACLE-L
 Subject: After logon trigger


 Hi

 I am trying to use an after logon trigger to create a session temp
 table rather that create it at the time the procedure that uses it
 calls it. Two reasons for doing this is for performance ? the other is
 so that I can reference it in a cursor.

 1) Do logon triggers not work if I logon with toad or similar tools

 2) If 1 is wrong why when I have the following trigger in the database
 cant I see the table or use it after logging on

 TRIGGER create_temp_table
 AFTER LOGON ON DATABASE
 DECLARE
 v_CreateString VARCHAR2(100);
 BEGIN
 v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part
 NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS';
 EXECUTE IMMEDIATE  v_CreateString;

 END;

 TIA

 Peter McLarty   E-mail: [EMAIL PROTECTED]
 Technical ConsultantWWW: http://www.Mincom.com
 APAC Technical Services Phone: +61 (0)7 3303 3461
 Brisbane,  AustraliaMobile: +61 (0)402 094 238

 --Facsimile: +61 (0)7 3303
 3048

 --
 This transmission is for the intended addressee only and is
 confidential information. If you have received this transmission in
 error, please delete it and notify the sender. The contents of this
 e-mail are the opinion of the writer only and are not endorsed by the
 Mincom Group of companies unless expressly stated otherwise.



-- 
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: Recommenations for a DB conversion using SQL Loaderf

[Jared . Still]

Ken,

That's one way to do it.  If your data is very large it will make the
loading much faster.

You can alleviate this by loading the tables in order of parents
first.  If you don't have an database diagram you can generate
this information from dba_constraints.

The easiest way is probably to disable the constraints, load
the data, then enable the constraints.

Be sure to thouroghly read the fine manual regarding constraints,
particularly the 'exceptions into' clause.

By redirecting exception rowids into another table you can
easily determine any rows that are causing a problem.

The way I do it if there is a lot of data and constraints to deal
with is to send exceptions to an exceptions table, move any
exception rows to another table, enable the constraint, and
then determine why the exception rows were excepted,
correct the problem and insert the row.

I haven't done this for awhile, and there may be new features
in 'ALTER TABLE ENABLE CONSTRAINT' that would change
this scenario somewhat, hence the RTFM.

HTH

Jared




   
 
Ken Janusz 
 

fsys.com>cc:   
 
Sent by: Subject: Recommenations for a DB 
conversion using SQL Loaderf  
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 08:45 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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).

Reports generated from OEM Change Management Pack 2.2

[Taylor, Shirley]

Hi all,
I've been looking on Metalink and in the docs but cannot find any reference
to the 'state' that is mentioned in the html output of the comparison
report. In my report there are only states 5 and 6 mentioned but can anyone
point me at some docs to tell me what they mean.
Thanks heaps,
Shirley
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Taylor, Shirley
  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: export database from AIX to Sun

[mitchell]

Thanks Kevin for your advise.

We still keep both AIX and SUN.  It is money talking to decide we have more
Suns.


Mitchell



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 1:00 PM


> first of all ...  WHY would you want to leave AIX for SUN
>   What a step down .
>
> Second  An Export file is an Export file is an Export file . or so
> its said.
>
> The export should be the same for all OS's so it should work on whatever
OS
> you decide to move it to.  Only difference might be limits on the OS as to
> file size.
>
> -Original Message-
> Sent: Wednesday, December 12, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus:
>
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
>
>
> Thanks in advance
> Mitchell
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
>   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).

Re: Standby Database - Log Shipping

[Anjan Thakuria]

Ron,

There is an excellent paper on how to set it up step-by-step for managed
recovery (logs applied automatically) on metalink. I like to follow these
to start with and read the manual for details.

They are 149286.1, 97010.1, 120855.1, 67488.1 etc. to start with.

Also consieder dataguard I am testing it as of now and looks good so far.

HTH

"Smith, Ron L." wrote:

> Does anyone know where I can find a paper on how to set up a standby
> database?  I am talking
> about a database that is always in recovery mode and archive logs are
> applied throughout the
> day to keep it up to date.
>
> Thanks!
> Ron Smith
> --
> 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).


begin:vcard 
n:Thakuria;Anjan
tel;work:817-963-3291
x-mozilla-html:TRUE
url:www.eds.com
org:EDS;Midrange Database Engineering
adr:;;;Fort Worth;Texas;76155;U.S.A
version:2.1
email;internet:[EMAIL PROTECTED]
title:Infrastructure Specialist
fn:Anjan Thakuria
end:vcard

RE: Spooling to a flat file via SQL*Plus

[Jared . Still]

Better yet, convert comma's into something else
before dumping to the file.

look at dump.sql at www.cybcon.com/~jkstill

It does the same thing for double quotes.  All double quotes are
converted to something else ( I forget what ) and then the data
is dumped to a double quote and comma delimited file.

Jared



   
 
Ken Janusz 
 

fsys.com>cc:   
 
Sent by: Subject: RE: Spooling to a flat file via 
SQL*Plus  
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/12/01 07:40 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Cherie:

If there are any commas in the date fields you will have problems with a
comma delimited file.  You may want to try "~" tilde delimited instead.

My $0.02,

Ken

 -Original Message-
Sent:   Wednesday, December 12, 2001 9:00 AM
To:Multiple recipients of list ORACLE-L


I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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

RE: Outer join sql help?

[Norrell, Brian]

SELECT a.LEAVE_CATEG_ID,
 a.LEAVE_TYPE_CD,
 a.LPET_LONG_DD, 
 Sum(l.ORIGINAL_INPUT_AM)
  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
 WHERE a.LEAVE_TYPE_CD(+) = l.evnt_type_cd
   AND l.INTERNAL_EMPL_ID='000357'
   AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
  And TO_DATE('12/31/2001','MM/DD/')
 GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;

This should work if you are looking for LEAVE_DETL_TBL records without
records in EFF_LEVPOL_EVNT_TYPE, which does not sound right.

I'm thinking you want the "a" records even when there is no supporting "l"
records:
SELECT a.LEAVE_CATEG_ID,
 a.LEAVE_TYPE_CD,
 a.LPET_LONG_DD, 
 Sum(l.ORIGINAL_INPUT_AM)
  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
 WHERE l.LEAVE_TYPE_CD(+) = a.evnt_type_cd
   AND l.INTERNAL_EMPL_ID(+) = '000357'
   AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
  And TO_DATE('12/31/2001','MM/DD/')
 GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;

But then the date range gives you a problem, so:
SELECT a.LEAVE_CATEG_ID,
 a.LEAVE_TYPE_CD,
 a.LPET_LONG_DD, 
 Sum(decode(sign(l.EFFECTIVE_DT -
TO_DATE('01/01/2001','MM/DD/'),
  1,0,NULL,0,
  decode(l.EFFECTIVE_DT -
TO_DATE('12/31/2001','MM/DD/'),
1, 0 , l.ORIGINAL_INPUT_AM
  )  )  )
  FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
 WHERE l.LEAVE_TYPE_CD(+) = a.evnt_type_cd
   AND l.INTERNAL_EMPL_ID(+) = '000357'
 GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;

Nasty - or is my initial guess off base?

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Norrell, Brian
  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).

DB SIZE ?

[Seema Singh]

hi
Just a thought.How do we reduce Database size?
Thanks
-Seema


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Outer join sql help?

[Mercadante, Thomas F]

Steve,

Generally,  Sum and Group by functions do not prevent data from being
returned.

I'm not sure what you mean by not giving you the rows you expect.  I would
look closely at the where clause to be sure you are selecting all the
records you want to get.

Select the rows without the group by to see what records seem to be missing.
Look especially closely at the date columns.  Your BETWEEN clause only
selects dates with time stamps between  1/1/2001 00:00:00 and 12/31/2001
00:00:00 - note that records with dates of 12/31 will not be selected if
they have a time stamp > 0.  You might try changing the between clause to:

AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
And TO_DATE('12/31/2001 235959','MM/DD/ hh24miss')

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 12, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L


This sql doesn't give me the additional rows I'm expecting.. Is this because
of the sum and group by expressions?  Is there a way around this behaviour?
Oracle 8.1.6

SELECT
a.LEAVE_CATEG_ID,
a.LEAVE_TYPE_CD,
a.LPET_LONG_DD, 
Sum(l.ORIGINAL_INPUT_AM)
 FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
WHERE a.LEAVE_TYPE_CD(+) = l.evnt_type_cd AND
l.INTERNAL_EMPL_ID='000357'
AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
And TO_DATE('12/31/2001','MM/DD/')
GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Steve
  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: Mercadante, Thomas F
  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: Converting UPU Licenses

[Gene Sais]

try this site:
https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&respid=22372

>>> [EMAIL PROTECTED] 12/12/01 12:50PM >>>
Hello everyone.  I've been off the list for a while, so I hope this
subject hasn't been beaten to death while I was gone.  I did some
searches in the archives but didn't come up with anything.

When Oracle announced the new $15,000/$40,000 per CPU pricing back in
June, the announcement said there would be an "easy formula to convert
UPU's" to the new scheme within a week.  Unfortunately I can't find
that formula.  Does anyone have it?

-rje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Robert Eskridge
  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: Gene Sais
  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: export database from AIX to Sun

[Rachel Carmichael]

in fact, that's the only way to move a database from one platform to
another.


--- mitchell <[EMAIL PROTECTED]> wrote:
> Hi Gurus:
> 
> It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and
> imp to
> Sun Soloris 2.7 Oracle 8.1.7
> I have only done on same os. env before.
> 
> 
> Thanks in advance
> Mitchell
> 
> -- 
> 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).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Strip Sizes

[lembark]

-- Todd Carlson <[EMAIL PROTECTED]> on 12/12/01 08:50:26 -0800

> I have a box (HP) with three controllers, not including the OS, with 3
> 18 gig disks each. The app is for testing our product's load times in an
> insert intensive environment. With RAID 0, what OS block and stripe size
> should I use with an 8k Oracle Block size?
> 
> I have been reading Oracle Performance Tuning 101, but before I
> implement anything I want the opinion of the list.

If you can make the stripe == system i/o page (variable on HP)
then you'll get the best throughput. If Oracle is stuck with
8K page I/O then use an 8k stripe (e.g., 4 PV's at 2K each).


--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: export database from AIX to Sun

[Kevin Lange]

first of all ...  WHY would you want to leave AIX for SUN
  What a step down .

Second  An Export file is an Export file is an Export file . or so
its said.

The export should be the same for all OS's so it should work on whatever OS
you decide to move it to.  Only difference might be limits on the OS as to
file size.

-Original Message-
Sent: Wednesday, December 12, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus:

It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
Sun Soloris 2.7 Oracle 8.1.7
I have only done on same os. env before.


Thanks in advance
Mitchell

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  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: Recommenations for a DB conversion using SQL Loader

[JeffCox]

Ken,

A few things you could try here:

1) disable the foreign key constraints for the load
or
2) load the parent tables before the child tables

If you have a huge amount, you might want to consider dropping all of the
indexes, except for the primary and unique key constraints.  (I don't like
to take chances when it comes to data integrity.)  This would save you a
boatload of time.

Regards,

Jeff

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 9:45 AM


I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  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: JeffCox
  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).

Converting UPU Licenses

[Robert Eskridge]

Hello everyone.  I've been off the list for a while, so I hope this
subject hasn't been beaten to death while I was gone.  I did some
searches in the archives but didn't come up with anything.

When Oracle announced the new $15,000/$40,000 per CPU pricing back in
June, the announcement said there would be an "easy formula to convert
UPU's" to the new scheme within a week.  Unfortunately I can't find
that formula.  Does anyone have it?

-rje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Eskridge
  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: Standby Database - Log Shipping

[Rachel Carmichael]

check out metalink and search for anything by Lawrence To

he's in Oracle's Center for Expertise and he concentrates on
standby. his papers are fantastic -- he's my idol :)


--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> Does anyone know where I can find a paper on how to set up a standby
> database?  I am talking
> about a database that is always in recovery mode and archive logs are
> applied throughout the
> day to keep it up to date.
> 
> Thanks!
> Ron Smith
> -- 
> 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).


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Listeners listening to multiple IPs

[Dave Morgan]

Hi All,
Yet I hard code IP addresses into the listener.ora (I
do not want the db server to be dependant on another
server, if DNS is down the listener will not come up)

and I have no problems having it listen to multiple IP's,
either as two listener's with different names or one 
listener listening on 2..n IP addresses.

Just add another DESCRIPTION/ADDRESS entry to the DESCRIPTION
LIST in listener.ora.

Been this way since 7.2.2.4 I think.

Client side tnsnames is different, follow Rachel's advice.

Dave

Rachel wrote:

> Subject: RE: Listeners listening to multiple IPs

> well yeah... 

>that's the whole point of USING DNS, so that it will work like that


--- Djordje Jankovic <[EMAIL PROTECTED]> wrote:
> I am not talking whether putting DNS entry works, but am just
> pointing to
> the fact that oracle behaves differently if you put hardcoded IP - it
> than
> listens to one IP only, and if you put the dns name - listens to all
> IPs.
> 
-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  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).

Outer join sql help?

[Johnston, Steve]

This sql doesn't give me the additional rows I'm expecting.. Is this because of the 
sum and group by expressions?  Is there a way around this behaviour?
Oracle 8.1.6

SELECT
a.LEAVE_CATEG_ID,
a.LEAVE_TYPE_CD,
a.LPET_LONG_DD, 
Sum(l.ORIGINAL_INPUT_AM)
 FROM EFF_LEVPOL_EVNT_TYPE_TBL a, LEAVE_DETL_TBL l
WHERE a.LEAVE_TYPE_CD(+) = l.evnt_type_cd AND l.INTERNAL_EMPL_ID='000357'
AND l.EFFECTIVE_DT Between TO_DATE('01/01/2001','MM/DD/') 
And TO_DATE('12/31/2001','MM/DD/')
GROUP BY a.LEAVE_CATEG_ID, a.LEAVE_TYPE_CD, a.LPET_LONG_DD;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Steve
  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: export database from AIX to Sun

[mitchell]

Hi Gurus:

It is possible to exp database  from aix 4.3.3. oracle 8.0.5.1 and imp to
Sun Soloris 2.7 Oracle 8.1.7
I have only done on same os. env before.


Thanks in advance
Mitchell

-- 
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).

Re: OT:Orlando support telephone number

[Susan M. Trumpet]

Thanks!

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 12:15 PM


Susan,
The contact # for Oracle that I have on the east coast is:
650-551-8900 cust support
800-223-1711 tech support
ROR mª¿ªm

>>> [EMAIL PROTECTED] 12/12/01 10:20AM >>>
Hi

Anyone knows the telephone number for Oracle Orlando support center? I had
it but I can't seem to find it now. I usually log my TARs via iTAR now and
my manager needs the number.

Thanks
Susan

--
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Susan M. Trumpet
  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).

Patch sets

[Vincent, Denise]

I'm new here, so please forgive me if this isn't the right forum to ask this
question.

We are deploying forms through Oracle's 9iAS Forms Server over the Web.  In
regards to the Developer 6i patch sets available and running forms over the
Web, do we need to apply the Developer 6i patch set to the iAS server in
addition to applying the patches on the developer's computer?  Do we need to
regenerate all the forms with the new patch set before we deploy them over
the Web?  I've download the Forms 6i Patch 8 and it appears to also contain
patches for the iAS server. The statement on the readme file included with
the patch is,
"Under most circumstances, you DO NOT need to install any of these
patches. However, if you are instructed by Oracle Worldwide Support to
install any of these patches, please read through this README file before
starting your installation." I've got a TAR open with Oracle, but I haven't
been able to speak with anyone yet.  If anyone out there has applied these
patches to either just the Developer 6i or the Developer 6i and iAS server
I'd appreciate any advise you may offer.


Denise Vincent
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vincent, Denise
  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: Anybody have an opinion on!

[Mark Leith]

Kevin,

There are two versions of SQLExpert - Pro & Dev.

Pro gives full functionality, allowing a DBA to scan the SGA for offensive
SQL (SQL Inspector), and source files etc. (SQL Scanner), as well as object
DDL extraction (Object Extractor). This version is priced at £3,285 for a
single copy.

Dev provides all of the SQL / PL/SQL creation, optimisation etc. but doesn't
provide the interactive collection modules and alike, as a developer doesn't
really need that functionality. You can only buy Dev in "Packs" though,
starting with a pack of 3 clients priced at £3,695.

As I mentioned, you only have to buy the client though - so you can touch
any Oracle (or Sybase, SQLServer or DB2 if you are that way inclined ;P)
database within your environment. The Sybase version is now only available
through Sybase themselves though (It's now branded as Sybase SQLExpert, like
Sybase Central).

Let me know if you want to try it out Kevin - I can either send you a CD or
you can download it from our site (only available through an emailed link).

Regards

Mark

-Original Message-
Kevin
Sent: 12 December 2001 16:21
To: Multiple recipients of list ORACLE-L


Hey Mark,

What is the cost for licensing on this product?

K.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 12 December 2001 15:15
To: Multiple recipients of list ORACLE-L


Hi Dick,

My opinion on this tool is extremely high - considering it is in fact not a
competitor, but one of the tools we sell :)

You won't find it listed on our web site, though it's sister tool
(SQLExpert) is listed. My personal opinion is that there is no other tool in
the market place that can rival what SQL/DBExpert can provide! Even *after*
looking at the competition in depth at the UKOUG on Monday.

To give you an idea of what it does:

Harvest your SQL / PL/SQL code from the system you are interested in (either
from memory, source code, binary files etc.. through a scan or SQL monitor)
then submit it to the optimisation engine - which will re-write the SQL
statement in as many, semantically equivalent, statements as is possible to
return the same output. It will then scan this new set of statements, and
show you all of those with alternate execution plans, run them through a
batch process to find those with better response/elapsed times, and bingo
you have a fully tuned statement. No other tool in the market will actually
do this - they add the major hints and alike, and tell you to analyse, or
create indexes etc.. I've seen SQLExpert take a SQL statement that did a
select from a view, rewrite the view in to the actual statement against the
underlying tables, and come back with a 40-45% improvement on response
times!

It also handles PL/SQL debugging, stored outlines etc. It's priced on a per
client basis, so you don't have to buy a license for every instance/server
that you want to tune, and it's easy to install and use.

To sum up - if you want a SQL *optimisation* tool, then go with
SQL/DBExpert! We only sell what we consider to be best of breed tools that
are in the market place, as long as they are easy to install/use, and
reasonably priced. SQLExpert fitted the bill for us, and it is going down
VERY well in the UK market place!

There is plenty of info on both leccotech.com, and cool-tools.co.uk for the
tools, but if you want any further info, give me a shout direct and I'll see
if I can answer any further questions that you have.

Regards

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 12 December 2001 13:00
To: Multiple recipients of list ORACLE-L


Folks,

I found an e-mail in my inbox this morning from my boss about a product
called Lecco DB Expert(http://www.leccotech.com/).  Anybody ever use this
one or
have an opinion?

Mark,

Since this is a competitor to Cool-Tools your welcome to get up on the
soap
box.

Dick Goulet
--
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: Mark Leith
  INET: [EMAIL PROTECTED]

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

Re: Fwd: Re: Serial# changes when rolling back

[Jared . Still]

Oops, sorry, I misread your post.

Jared





--  Forwarded Message  --
Date: Wed, 12 Dec 2001 15:24:14 +0800
To: Jared Still <[EMAIL PROTECTED]>


The problem is not with killing a session.
If a user exited normally _before_ you executed the kill, it is likely that
the Sid has been allocated to another user because the former user
did a clean exit and released his Sid immediately.

Hemant



Jared Still <[EMAIL PROTECTED]>   12/12/2001 02:34 PM

 To: [EMAIL PROTECTED], CHITALE Hemant Krishnarao/Prin
 DBA/CSM/ST Group@ST Domain
 cc:
 Subject: Re: Serial# changes when rolling back









Past experience with this problem seems to indicate that you might
be mistaken in that.  Though the serial # may increment, I've never
seen another session take the SID until the session holding it is
completely gone.

This should be fairly easy to test if you want to bother.  Start a
sufficiently large transaction that it will take some time to rollback,
kill it, and login with  a new session and check v$session.

Jared

On Tuesday 11 December 2001 16:30, [EMAIL PROTECTED] wrote:
> One explanation I had heard for the combination of Sid+Serial# goes
> something like this ...
> say you identify a particular session to monitor ... you then decide to
> kill it.
> However, it could so happen that that user logged out between the time

you

> decided to kill the session and the time you actually killed the session
> (even
> if you have scripted the kill command).  When a user logs out, the Sid is
> available to the next user who logs in.  Since another user might be
> holding
> the same Sid at the time you come around to kill the Sid, you might
> actually
> kill the wrong user-session.  To avoid this, the next user, getting the
> same
> Sid gets a different Serial# and your kill must be on Sid+Serial#

together.

> That still does not explain why pmon increments the Serial#, though.
>
> Hemant
>
>
>
> Deepak Thapliyal <[EMAIL PROTECTED]>  12/12/2001 06:26 AM
> Sent by: [EMAIL PROTECTED]
>
> Please respond to ORACLE-L
>
>  To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin

DBA/CSM/ST

> Group) Subject: Re: Serial# changes when rolling back
>
>
>
>
>
>
>
>
> yeah i did read this thread but still wonder why
> oracle needs to use serial# column at all.  Does the
> SID not gaurentee uniqueness for a session ... damn
> the name says so atleast (session identifier)..
>
> or maybe they just coded it like that and make some
> use of the serial #
>
> Deepak
>
> --- [EMAIL PROTECTED] wrote:
> > Check this Oracle Note :
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Doc ID:
> >
> > Note:1020545.102
> >
> > Subject:
> >
> > ORA-00026: CANNOT KILL SESSION;
> >
> > SERIAL# KEEPS CHANGING
> >
> > Type:
> >
> > PROBLEM
> >
> > Status:
> >
> > PUBLISHED
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Content Type:
> >
> >   TEXT/PLAIN
> >
> > Creation Date:
> >
> >   23-NOV-1999
> >
> > Last Revision Date:
> >
> >   24-AUG-2000
> >
> >
> >
> >
> >
> > Problem Description
> >
> > ---
> >
> >
> >
> > You have killed a process at
> >
> > the operating system level that
> >
> > was
> >
> > running a long-running
> >
> > transaction.  Now, you are
> >
> > trying to issue
> >
> > the command:
> >
> >
> >
> > alter system kill session
> >
> > ', ';
> >
> >
> >
> > To kill the associated Oracle
> >
> > session, but you can't kill it.
> >
> > You
> >
> > may receive the following
> >
> > error:
> >
> >
> >
> > ORA-00026:  missing or
> >
> > invalid session id
> >
> > Cause:  The session ID
> >
> > string specified in the ALTER
> >
> > SYSTEM
> >
> > KILL SESSION
> >
> > command was invalid, or no
> >
> > string was
> >
> > specified.
> >
> >Action:  Retry the
> >
> > command with a valid session
> >
> > ID.
> >
> >
> >
> > In v$session, you notice that
> >
> > the serial# for the session
> >
> > keeps
> >
> > changing.  Also, pmon may be
> >
> > creating a trace file that
> >
> > keeps growing.
> >
> >
> >
> >
> >
> > Solution Description
> >
> > 
> >
> >
> >
> > It is best to let pmon roll
> >
> > back the changes.  If you
> >
> > shutdown at this
> >
> > point, this work will

RE: Standby Database - Log Shipping

[Baker, Barbara]

Lawrence To has a couple.  I believe I got both of them from metalink
Oracle8i Standby Database   (try 76451.1
Graceful Switchover and Switchback
HTH
Barb


> --
> From: Smith, Ron L.[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, December 12, 2001 9:15 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Standby Database - Log Shipping
> 
> Does anyone know where I can find a paper on how to set up a standby
> database?  I am talking
> about a database that is always in recovery mode and archive logs are
> applied throughout the
> day to keep it up to date.
> 
> Thanks!
> Ron Smith
> -- 
> 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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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).

Strip Sizes

[Todd Carlson]

I have a box (HP) with three controllers, not including the OS, with 3
18 gig disks each. The app is for testing our product's load times in an
insert intensive environment. With RAID 0, what OS block and stripe size
should I use with an 8k Oracle Block size?

I have been reading Oracle Performance Tuning 101, but before I
implement anything I want the opinion of the list.


Thanks,
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Todd Carlson
  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: Standby Database - Log Shipping

[SARKAR, Samir]

Metalink Note : 120855.1

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 12 December 2001 16:16
To: Multiple recipients of list ORACLE-L


Does anyone know where I can find a paper on how to set up a standby
database?  I am talking
about a database that is always in recovery mode and archive logs are
applied throughout the
day to keep it up to date.

Thanks!
Ron Smith
-- 
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).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  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: Orlando support telephone number

[Tieu, Linh K.]

Try 1-800-223-1711.

 

-Original Message-
From: Susan M. Trumpet
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001
10:21 AM
To: Multiple recipients of list
ORACLE-L
Subject: OT:Orlando support
telephone number

 



Hi





 





Anyone knows the telephone number
for Oracle Orlando support center? I had it but I can't seem to find it now. I
usually log my TARs via iTAR now and my manager needs the number.





 





Thanks





Susan

Recommenations for a DB conversion using SQL Loaderf

[Ken Janusz]

I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?  
Any and all suggestions are welcome.
Ken

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  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: Anybody have an opinion on!

[Mark Leith]

Man this guy wrote the longest review of a tool I have EVER seen! There is a
copy of it up on our web site, under SQLExpert/Product reviews.. If you
haven't already read it Dick, take a look - it is bang on target for what
the users of the tool in the "real world" are also saying.. (even if it does
take an hour to read ;P).. The product is also a couple of versions down the
line now from when the review was done..

This is the kind of line I like - "Before going on, LECCO SQL Expert did an
excellent job of choosing the best SQL, which was the SQL where the
correlated subquery was converted to a non-correlated SQL statement,
allowing Oracle to merge both subqueries. The total elapsed time was 0.12
seconds, whereas I stopped the execution of the original after four
minutes."

Now THAT'S optimisation!

Enough of my "sales critter" drivel now - Dick, if you do take a look at the
tool, let me know what you think? I'd love your personal feedback!

Dorothy

-Original Message-
Sent: 12 December 2001 15:45
To: Multiple recipients of list ORACLE-L


Is it just me, or does anyone else know and think that
Eddy Kosciusko's involvement in the evaluation/development
of this tool might well be worth the price?

:-)


-Original Message-

Hi Dick,

My opinion on this tool is extremely high - considering it is in fact not a
competitor, but one of the tools we sell :)


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  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: Mark Leith
  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: Spooling to a flat file via SQL*Plus

[Hand, Michael T]

Cheri,

What about
INSERT INTO new_table SELECT a,SUBSTR(b,1,255),c,d,e FROM old_table;

Just a thought.

Mike

-Original Message-
Sent: Wednesday, December 12, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L



I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: Pwer Point Presentation for 9i Real Application Cluster (RAC)

[Rachel Carmichael]

Hey Steve, welcome :)

I've been downloading the papers from the conference website, most of
them are out there now. 


--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> Helmut:
>There were many papers presented at Oracle Open World last week. 
> I would
> suggest waiting a week or so and then look at OTN for this
> information.
> There should already be some stuff on there now.
>  
> Thank You
>  
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct:  (248) 865-4350
> Mobile:  (248) 408-2918
> Email:  
> [EMAIL PROTECTED]
> Web:    www.compuware.com
>  
>  
> -Original Message-
> Sent: Wednesday, December 12, 2001 3:36 AM
> To: Multiple recipients of list ORACLE-L
>  
> Hi! 
> My company is thinking about having a closer look at 9i Real
> Application
> Clusters. Does anybody out there have any white papers or Power Point
> presentations on that topic?
> Thanks, 
> Helmut 
> 


__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Anybody have an opinion on!

[Thomas, Kevin]

Hey Mark,

What is the cost for licensing on this product?

K.
"my computer beat me at chess but i won when it came to kick boxing."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 12 December 2001 15:15
To: Multiple recipients of list ORACLE-L


Hi Dick,

My opinion on this tool is extremely high - considering it is in fact not a
competitor, but one of the tools we sell :)

You won't find it listed on our web site, though it's sister tool
(SQLExpert) is listed. My personal opinion is that there is no other tool in
the market place that can rival what SQL/DBExpert can provide! Even *after*
looking at the competition in depth at the UKOUG on Monday.

To give you an idea of what it does:

Harvest your SQL / PL/SQL code from the system you are interested in (either
from memory, source code, binary files etc.. through a scan or SQL monitor)
then submit it to the optimisation engine - which will re-write the SQL
statement in as many, semantically equivalent, statements as is possible to
return the same output. It will then scan this new set of statements, and
show you all of those with alternate execution plans, run them through a
batch process to find those with better response/elapsed times, and bingo
you have a fully tuned statement. No other tool in the market will actually
do this - they add the major hints and alike, and tell you to analyse, or
create indexes etc.. I've seen SQLExpert take a SQL statement that did a
select from a view, rewrite the view in to the actual statement against the
underlying tables, and come back with a 40-45% improvement on response
times!

It also handles PL/SQL debugging, stored outlines etc. It's priced on a per
client basis, so you don't have to buy a license for every instance/server
that you want to tune, and it's easy to install and use.

To sum up - if you want a SQL *optimisation* tool, then go with
SQL/DBExpert! We only sell what we consider to be best of breed tools that
are in the market place, as long as they are easy to install/use, and
reasonably priced. SQLExpert fitted the bill for us, and it is going down
VERY well in the UK market place!

There is plenty of info on both leccotech.com, and cool-tools.co.uk for the
tools, but if you want any further info, give me a shout direct and I'll see
if I can answer any further questions that you have.

Regards

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 12 December 2001 13:00
To: Multiple recipients of list ORACLE-L


Folks,

I found an e-mail in my inbox this morning from my boss about a product
called Lecco DB Expert(http://www.leccotech.com/).  Anybody ever use this
one or
have an opinion?

Mark,

Since this is a competitor to Cool-Tools your welcome to get up on the
soap
box.

Dick Goulet
--
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: Mark Leith
  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: Thomas, Kevin
  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).

Standby Database - Log Shipping

[Smith, Ron L.]

Does anyone know where I can find a paper on how to set up a standby
database?  I am talking
about a database that is always in recovery mode and archive logs are
applied throughout the
day to keep it up to date.

Thanks!
Ron Smith
-- 
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: OT:Orlando support telephone number

[Ron Rogers]

Susan,
The contact # for Oracle that I have on the east coast is:
650-551-8900 cust support
800-223-1711 tech support
ROR mª¿ªm

>>> [EMAIL PROTECTED] 12/12/01 10:20AM >>>
Hi

Anyone knows the telephone number for Oracle Orlando support center? I had it but I 
can't seem to find it now. I usually log my TARs via iTAR now and my manager needs the 
number.

Thanks
Susan

--
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: Spooling to a flat file via SQL*Plus

[Cherie_Machler]

Tom,

Virtual beverage of choice to you.  The insert worked like a charm.
I was having difficulty with the substring command but this worked
fine.   Didn't need to do the SQL*Load.

Many thanks.   It's a zoo here today.

Cherie Machler
Oracle DBA
Gelco Information Network


   
 
"Mercadante,   
 
Thomas F"  To: "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc: "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>  
ate.ny.us> Subject: RE: Spooling to a flat file 
via SQL*Plus
   
 
12/12/01 09:35 
 
AM 
 
   
 
   
 




CHerie,

Why not just move the data directly using sqlplus rather than go the
sqlloader route:

insert new_cd_experience(KS_EXPERIENCEID,EXP_NOTES,
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED)
select KS_EXPERIENCEID,substr(EXP_NOTES,1,255),
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED
from old_cd_experience;

otherwise to spool a file you would:

set head off
set lines 200
set pages 1 <=== make larger than the number of rows to export
spool cd_exp.dat
select KS_EXPERIENCEID || ',' ||substr(EXP_NOTES,1,255) || ',' ||
   EXP_QA_STATE || ',' ||TEMP_RN || ',' ||EXP_REVIEW_NEEDED
from old_cd_experience;
spool off;


hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 12, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L



I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).




-- 
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).

RE: Spooling to a flat file via SQL*Plus

[Martin Kendall]

Just in case there are MORE than 1 Rows, you can simply set
PAGES 0 instead.

Martin

-Original Message-
Thomas F
Sent: 12 December 2001 15:35
To: Multiple recipients of list ORACLE-L


CHerie,

Why not just move the data directly using sqlplus rather than go the
sqlloader route:

insert new_cd_experience(KS_EXPERIENCEID,EXP_NOTES,
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED)
select KS_EXPERIENCEID,substr(EXP_NOTES,1,255),
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED
from old_cd_experience;

otherwise to spool a file you would:

set head off
set lines 200
set pages 1 <=== make larger than the number of rows to export
spool cd_exp.dat
select KS_EXPERIENCEID || ',' ||substr(EXP_NOTES,1,255) || ',' ||
   EXP_QA_STATE || ',' ||TEMP_RN || ',' ||EXP_REVIEW_NEEDED
from old_cd_experience;
spool off;


hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 12, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L



I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  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: Martin Kendall
  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: Anybody have an opinion on!

[Mohan, Ross]

Is it just me, or does anyone else know and think that
Eddy Kosciusko's involvement in the evaluation/development
of this tool might well be worth the price?

:-)


-Original Message-

Hi Dick,

My opinion on this tool is extremely high - considering it is in fact not a
competitor, but one of the tools we sell :)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: Spooling to a flat file via SQL*Plus

[Mercadante, Thomas F]

CHerie,

Why not just move the data directly using sqlplus rather than go the
sqlloader route:

insert new_cd_experience(KS_EXPERIENCEID,EXP_NOTES,
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED)
select KS_EXPERIENCEID,substr(EXP_NOTES,1,255),
 EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED
from old_cd_experience;

otherwise to spool a file you would:

set head off
set lines 200
set pages 1 <=== make larger than the number of rows to export
spool cd_exp.dat
select KS_EXPERIENCEID || ',' ||substr(EXP_NOTES,1,255) || ',' ||
   EXP_QA_STATE || ',' ||TEMP_RN || ',' ||EXP_REVIEW_NEEDED
from old_cd_experience;
spool off;


hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 12, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L



I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  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: Spooling to a flat file via SQL*Plus

[Ramon Estevez]

Hi Cherie,

SET HEADING OFF
SPOOL C:\TEMP\output.txt

SELECT KS_EXPERIENCEID||','||SUBSTR(EXP_NOTES, 1,
255)||'-'||EXP_QA_STATE||'-'
   ||TEMP_RN||','||EXP_REVIEW_NEEDED
FROM YOURTABLE

set heading on
spool off

This would create your file.

Luck

Ramon E. Estevez
[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: Wednesday, 12 December, 2001 10:00 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Spooling to a flat file via SQL*Plus



I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon Estevez
  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: Spooling to a flat file via SQL*Plus

[Ken Janusz]

Cherie:

If there are any commas in the date fields you will have problems with a
comma delimited file.  You may want to try "~" tilde delimited instead.

My $0.02,

Ken

 -Original Message-
Sent:   Wednesday, December 12, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Spooling to a flat file via SQL*Plus


I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  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: Instr function ?

[steven wndy]

Larry:
That works! Thanks.
But I will have up to 2000 data need to pick up. I
won't hard code to 2000 fields. Is there a better way
to loop this or to put in an array?

Thanks a lot.

Steven

--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> Steven,
> 
> For a "pure" SQL solution, you can use INSTR to get
> the n'th occurrence of
> an item. So, you know item 2 is surrounded by the
> 1st and 2nd occurence,
> item 3 by the 2nd and 3rd occurence, etc. The SQL
> looks a little nasty but I
> took it down through item 9 for you to see:
> 
>   1  select substr(foo,1,instr(foo,'^',1,1)-1) f1,
>   2 substr(foo,instr(foo,'^',1,1)+1, -- find
> the first ^ and add 1
>   3   
> instr(foo,'^',1,2)-instr(foo,'^',1,1)-1) f2, -- find
> the second occurence minus the first occurence
>   4 substr(foo,instr(foo,'^',1,2)+1,
>   5   
> instr(foo,'^',1,3)-instr(foo,'^',1,2)-1) f3,
>   6 substr(foo,instr(foo,'^',1,3)+1,
>   7   
> instr(foo,'^',1,4)-instr(foo,'^',1,3)-1) f4,
>   8 substr(foo,instr(foo,'^',1,4)+1,
>   9   
> instr(foo,'^',1,5)-instr(foo,'^',1,4)-1) f5,
>  10 substr(foo,instr(foo,'^',1,5)+1,
>  11   
> instr(foo,'^',1,6)-instr(foo,'^',1,5)-1) f6,
>  12 substr(foo,instr(foo,'^',1,6)+1,
>  13   
> instr(foo,'^',1,7)-instr(foo,'^',1,6)-1) f7,
>  14 substr(foo,instr(foo,'^',1,7)+1,
>  15   
> instr(foo,'^',1,8)-instr(foo,'^',1,7)-1) f8,
>  16 substr(foo,instr(foo,'^',1,8)+1,
>  17   
> instr(foo,'^',1,9)-instr(foo,'^',1,8)-1) f9
>  18* from steven
> SQL> /
> 
> F1  F2  F3  F4  
>F5
> --- --- ---
> --- 
> ---
> F6  F7  F8  F9
> --- --- ---
> ---
> CIRCUITS1   12/31/01
>
> CIRCUITS
> 
> DESKTOP-01  333
>
> DESKTOP
> 
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of
> > steven wndy
> > Sent: Tuesday, December 11, 2001 5:50 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Instr function ?
> >
> >
> > Hello:
> >
> > My table has a column (EVFIELDS) contain the
> > concatenated information pass in (up to 20 fileds
> from
> > other tables which will be used to update into our
> > database), each piece of information will be
> separated
> > by ^ in this column and some info are nullable,
> then
> > the data for this column would be like:
> > 1/
> >
>
CIRCUITS1^^12/31/01^^CIRCUITS^
> > ^^
> >
> > 2/
> > DESKTOP-01^333^^^DESKTOP
> > ^^^
> >
> > The first example above I have data in pos1, pos3,
> > pos9, and others are NULL;
> > The second example there are data in pos1,
> pos2,pos9,
> > and others are NULL;
> >
> > I tried INSTR. But how do I find the start and end
> > points for the postion like pos3 or pos11?
> > In another word, how can I filter/select those
> data
> > out of these ^? Should I loop for the postion 1
> to
> > 2000? Any idea?
> >
> > Desc c_eventout:
> > EVTYPE VARCHAR2(64)
> > EVTIME DATE
> > EVUSER VARCHAR2(64)
> > EVFIELDS   VARCHAR2(2000)
> > EVSEPCHAR  VARCHAR2(1)
> >
> > Thanks for your reply
> >
> >
> > Steven
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Larry Elkins
>   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!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: steven wndy
  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 EX

RE: HP AutoRaid vol configuration

[Jesse, Rich]

I gotta go with Scott here.  Even though we've tweaked out our AutoRAID, it
will still take about 12 HOURS to restore 24GB of datafiles from DLT tape.
I think the time drops to little under 2 hours on a 4-wide stripe (w/mirror,
of course).  And you can glean from tbat why we've moved our online redos
off of the A-Raid.  That did help a lot, but we've got nowhere else to go
with the control, temp, and rbs datafiles.  Ick.

You'll need a lot of memory to help compensate for the A-Raid.  Of course
that ain't gonna do you squat when it comes time to restore.  With 10 36GBs,
I'm guessing your DB to be in the neighborhood of 100GB?  Look for almost 2
*DAYS* of downtime to restore from tape.  And it WILL happen!

Good luck!

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Wednesday, December 12, 2001 07:15
To: Multiple recipients of list ORACLE-L


Autoraid?  Abandon all hope of achieveing anything resembling decent
throughput.  Other than that, go with HP's recommendations.

--Scott


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 11:20 PM


> HP 9000/L2000
>
> HP SureStore 12h AutoRaid
>
> 10-36G drives  (useable space)
>
> Oracle 8.1.7  (Production box)
> Oracle Apps 11.0.3
> 2 OLTP db with web services
> 1 small data mart
>
> 1) HP recommends 4-6 LUNs.  Do I just divide up the storage equally, or is
> there a reason to think about different size LUNs?
>
> 2) Are there reasons to have 4-5 lvols per LUN vs 1 or 2 lvols?
>
> Thanks.
>
> e: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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:Orlando support telephone number

[Susan M. Trumpet]

Hi
 
Anyone knows the telephone number for Oracle 
Orlando support center? I had it but I can't seem to find it now. I usually log 
my TARs via iTAR now and my manager needs the number.
 
Thanks
Susan

RE: Anybody have an opinion on!

[Mark Leith]

Hi Dick,

My opinion on this tool is extremely high - considering it is in fact not a
competitor, but one of the tools we sell :)

You won't find it listed on our web site, though it's sister tool
(SQLExpert) is listed. My personal opinion is that there is no other tool in
the market place that can rival what SQL/DBExpert can provide! Even *after*
looking at the competition in depth at the UKOUG on Monday.

To give you an idea of what it does:

Harvest your SQL / PL/SQL code from the system you are interested in (either
from memory, source code, binary files etc.. through a scan or SQL monitor)
then submit it to the optimisation engine - which will re-write the SQL
statement in as many, semantically equivalent, statements as is possible to
return the same output. It will then scan this new set of statements, and
show you all of those with alternate execution plans, run them through a
batch process to find those with better response/elapsed times, and bingo
you have a fully tuned statement. No other tool in the market will actually
do this - they add the major hints and alike, and tell you to analyse, or
create indexes etc.. I've seen SQLExpert take a SQL statement that did a
select from a view, rewrite the view in to the actual statement against the
underlying tables, and come back with a 40-45% improvement on response
times!

It also handles PL/SQL debugging, stored outlines etc. It's priced on a per
client basis, so you don't have to buy a license for every instance/server
that you want to tune, and it's easy to install and use.

To sum up - if you want a SQL *optimisation* tool, then go with
SQL/DBExpert! We only sell what we consider to be best of breed tools that
are in the market place, as long as they are easy to install/use, and
reasonably priced. SQLExpert fitted the bill for us, and it is going down
VERY well in the UK market place!

There is plenty of info on both leccotech.com, and cool-tools.co.uk for the
tools, but if you want any further info, give me a shout direct and I'll see
if I can answer any further questions that you have.

Regards

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 12 December 2001 13:00
To: Multiple recipients of list ORACLE-L


Folks,

I found an e-mail in my inbox this morning from my boss about a product
called Lecco DB Expert(http://www.leccotech.com/).  Anybody ever use this
one or
have an opinion?

Mark,

Since this is a competitor to Cool-Tools your welcome to get up on the
soap
box.

Dick Goulet
--
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: Mark Leith
  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).

Spooling to a flat file via SQL*Plus

[Cherie_Machler]

I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

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).

RE: Listeners listening to multiple IPs

[mohammed bhatti]

How about one listener listening to two IPs.  I have
the following working in a development area:

LISTENER =
 (ADDRESS_LIST =
 (ADDRESS= (PROTOCOL= IPC)(KEY= db1))
 (ADDRESS= (PROTOCOL= IPC)(KEY= db1.world))
 (ADDRESS= (PROTOCOL= IPC)(KEY= extproc0))
 (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
 (ADDRESS= (PROTOCOL= TCP)(Host= dbsrvr01)(Port=1521))
 (ADDRESS= (PROTOCOL= TCP)(Host=
dbsrvr01b)(Port=1521))
)

--- Djordje Jankovic <[EMAIL PROTECTED]>
wrote:
> I am not talking whether putting DNS entry works,
> but am just pointing to
> the fact that oracle behaves differently if you put
> hardcoded IP - it than
> listens to one IP only, and if you put the dns name
> - listens to all IPs.
> 
> Djordje
> 
> > -Original Message-
> > From: Rachel Carmichael
> [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 11, 2001 11:50 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Listeners listening to multiple IPs
> > 
> > 
> > it's not so much a feature of the listener as it
> is of DNS as far as I
> > know. One of the reasons it's best not to
> hard-code IP addresses into
> > the listener.ora is because when you do a
> failover, or 
> > combine machines
> > as you have, the listener.ora and tnsnames.ora
> files need to be
> > updated.
> > 
> > If you use DNS and let the DNS server resolve the
> address, you don't
> > have to change anything.
> > 
> > This has been around for as long as I can remember
> using the listener,
> > which means going back to version 6
> > 
> > Rachel
> > 
> > --- Djordje Jankovic <[EMAIL PROTECTED]>
> wrote:
> > > Something I learned today, but haven't seen it
> documented anywhere
> > > and would
> > > like to see whether anybody has come across it.
> > > 
> > > We have a Sun server (call it oracle.acme.com). 
> It came to life by
> > > combining two machines (oracle1.acme.com and
> oracle2.acme.com).  So
> > > now it
> > > has two IP addresses: hme0: x.y.z.001 - from
> oracle1 and hme1:
> > > x.y.z.002 -
> > > from oracle2.  There are few databases there
> (some of them were on
> > > oracle1
> > > some on oracle2) and one listener listening to
> all of them.
> > > 
> > > If you configure listener.ora file so that
> HOST=x.y.z.001, or
> > > HOST=x.y.z.002
> > > that listener listens to that ONE IP only. 
> However, if you put
> > > HOST=oracle.acme.com in listener.ora than it
> listens to all IPs (in
> > > netstat
> > > -an you see that it is listening to "*.1521"
> instead of to
> > > "oracle.acme.com.1521").  That would mean that
> oracle does not
> > > resolve DNS
> > > at replaces it with IP but first checks whether
> this is the primary
> > > IP for
> > > that box.  
> > > 
> > > So, once we have put HOST=oracle.acme.com, all
> the connections were
> > > OK
> > > (coming from clients with tnsnames files that
> are pointing to old
> > > oracle1.acme.com and oracle2.acme.com)  Of
> course DNS was changed..
> > > 
> > > Anybody has come across this undocumented
> feature ?  Any explanation
> > > to that
> > > ?
> > > 
> > > Djordje
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > -- 
> > > Author: Djordje Jankovic
> > >   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!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> > your unique holiday gifts! Buy at
> http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Rachel Carmichael
> >   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: Djordje Jankovic
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego

RE: Update table problem

[Ramon Estevez]

Harvinder,

You have to combine the functions instr and substr.

you make a string with all the fields.

first_space := instr(string, ' ', 1, 1); --> The first white space beginning
from position 1
part1 := substr(string, 1, first_space -1);
part2 := substr(string, first_space + 1, 99);

update table
   set field = part1||part2;

HTH,

Regards,

Ramon E. Estevez
[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Harvinder
Singh
Enviado el: Tuesday, 11 December, 2001 5:26 PM
Para: Multiple recipients of list ORACLE-L
Asunto: Update table problem


Hi,

We inserted data into 1 of the column as
test 1 abc
while the actual value is
 test1abc without spaces.
There are about 1 million rows in a table.
Is there a way to update the table column and remove the extra space .

Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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: Ramon Estevez
  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: Anybody have an opinion on!

[Hallas John]

Title: RE: Anybody have an opinion on!





Dick,
Your boss wasn't having a dig at you was he :-)
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 13:00
To: Multiple recipients of list ORACLE-L
Subject: Anybody have an opinion on!



Folks,


    I found an e-mail in my inbox this morning from my boss about a product
called Lecco DB Expert(http://www.leccotech.com/).  Anybody ever use this one or
have an opinion?


Mark,


    Since this is a competitor to Cool-Tools your welcome to get up on the soap
box.


Dick Goulet
-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=