Materialized View over 2 tables

[Daiminger, Helmut]

Title: Materialized View over 2 tables





Hi!


Can I have a materialized view to be refreshed "fast", when it is created over 2 base tables? Fast refreshes work fine as long as the materialized view is based on 1 base table. But if the view is based on more base tables, it only seems to work with a complete refresh.

Does anybody have any experience with that problem?


This is 8.1.7 on Sun Solaris.


Thanks,
Helmut

Re: export database with Query option

[C.S.Venkata Subramanian]

Try this
 exp scott/tiger tables=emp query=\"where sal>=2000 \"
Venkat

--

On Mon, 29 Oct 2001 22:15:18  
 nshah wrote:
>Hi,
>
>Can you help me, regarding oracle export database utility  with Query option.
>
>Our OS is the WinNT 4.0. 
>Database 8i  
>Server compaq raid 5
>
>I am trying to export the employee table which has sal > 2000.
>
>exp scott/tiger tables=emp query= ?
>
>Neel
>-- 
>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).
>


Make a difference, help support the relief efforts in the U.S.
http://clubs.lycos.com/live/events/september11.asp
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

RE: How can I tell if a procedure/package is running?

[K Gopalakrishnan]

I think 1 is NULL mode and 3 is EXCLUSIVE mode.
No idea abt 0.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
Sent: Monday, October 29, 2001 10:00 PM
To: Multiple recipients of list ORACLE-L

out of curiosity...
what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD)

> --
> From: Steve Adams[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2001 10:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How can I tell if a procedure/package is running?
>
> Hi Doug,
>
> You can look at the mode in which the stored procedure or package is
> pinned in the library cache. This information is in
> X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in
> shared mode by one or more sessions. If necessary,
> you can join to X$KGLPN to find the sessions holding the pins. See
> "executing_packages.sql" at
> http://www.ixora.com.au/scripts/misc.htm#executing_packages for an
> example.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/  -  For DBAs
> @   http://www.secularislam.org/call.htm  -  For Muslims
> @   http://www.christianity.net.au/   -  For all
>
> -Original Message-
>
> How can I tell if a stored procedure or package is in the middle of
> execution?
>
>
> --
> ---
> You can view this message online at
> http://www.ixora.com.au/q+a/0110/30141015.htm
> To unsubscribe from Ixora Answers send a blank email to
> [EMAIL PROTECTED]
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Adams
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Rahul
  INET: [EMAIL PROTECTED]

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

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


_
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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 can I tell if a procedure/package is running?

[Steve Adams]

Hi Rahul,

0 means not pinned; 3 means pinned in exclusive mode.
I don't know what 1 means. I'm not accustomed to seeing it.
Do you have any examples?

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Tuesday, 30 October 2001 16:00
To: Multiple recipients of list ORACLE-L


out of curiosity...
what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD) 

> --
> From: Steve Adams[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2001 10:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How can I tell if a procedure/package is running?
> 
> Hi Doug,
> 
> You can look at the mode in which the stored procedure or package is
> pinned in the library cache. This information is in
> X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in
> shared mode by one or more sessions. If necessary,
> you can join to X$KGLPN to find the sessions holding the pins. See
> "executing_packages.sql" at
> http://www.ixora.com.au/scripts/misc.htm#executing_packages for an
> example.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/  -  For DBAs
> @   http://www.secularislam.org/call.htm  -  For Muslims
> @   http://www.christianity.net.au/   -  For all
> 
> -Original Message-
> 
> How can I tell if a stored procedure or package is in the middle of
> execution?

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

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

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

export database with Query option

[nshah]

Hi,

Can you help me, regarding oracle export database utility  with Query option.

Our OS is the WinNT 4.0. 
Database 8i  
Server compaq raid 5

I am trying to export the employee table which has sal > 2000.

exp scott/tiger tables=emp query= ?

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

No Subject

[Alon Ben-Zvi]

Hi List,

I have a question regarding server requirements(computer) If any of you have
any
Idea or experience It would be nice to respond, Thanks in advance
all of you.
My question is, I have a very large database that have more than 300 tables
part of them 
have more than 50,000,000 records.
Can someone of you give me a specification of a server for that?

Thanks in advance again,
Alon



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 can I tell if a procedure/package is running?

[Rahul]

out of curiosity...
what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD) 

> --
> From: Steve Adams[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2001 10:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: How can I tell if a procedure/package is running?
> 
> Hi Doug,
> 
> You can look at the mode in which the stored procedure or package is
> pinned in the library cache. This information is in
> X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in
> shared mode by one or more sessions. If necessary,
> you can join to X$KGLPN to find the sessions holding the pins. See
> "executing_packages.sql" at
> http://www.ixora.com.au/scripts/misc.htm#executing_packages for an
> example.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/  -  For DBAs
> @   http://www.secularislam.org/call.htm  -  For Muslims
> @   http://www.christianity.net.au/   -  For all
> 
> -Original Message-
> 
> How can I tell if a stored procedure or package is in the middle of
> execution?
> 
> 
> --
> ---
> You can view this message online at
> http://www.ixora.com.au/q+a/0110/30141015.htm
> To unsubscribe from Ixora Answers send a blank email to
> [EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Steve Adams
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Rahul
  INET: [EMAIL PROTECTED]

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

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

RE: Root to connect as system

[Sujatha Madan]

An application needs root to be able to log in to the database to create
tables etc. I will be taking the access off root once the initial part of
the application is run.



-Original Message-
Sent: Tuesday, 30 October 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


my question is "why are you insisting on root logging into the
database???"  create a new userid to do the connection.

i thought i remembered somewhere about root not being able to login,
maybe that was back and hardcoded for svrmgrl.

joe


Sujatha Madan wrote:
> 
> Ok, I have solved the issue of the listener, however I still cannot get
root
> to log on as system.
> 
> - My Oracle home is set correct
> - My Oracle sid is set correct
> - ld library path is correct
> - other path;s are correct
> 
> does anyone have an idea on how to fix this?
> 
> thanx
> 
> -Original Message-
> Sent: Tuesday, 30 October 2001 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> I have set the SID correct and all the environment variables correctly.
What
> I didn't do was set up the listener and tnsnames. However, when I am
trying
> to set up the listener, for some reason it is not able to find the
> executables. It is looking in a different directory. The Oracle Home is
set
> correctly.
> 
> -Original Message-
> Sent: Tuesday, 30 October 2001 12:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> Looks like your oracle sid is set incorrectly and you
> are trying to connect without using a tns service name
> 
> Deepak
> 
> PS: have you set the env variables .. type env at the
> unix prompt and check if PATH /ORACLE_HOME/
> LD_LIBRARY_PATH are set correctly
> 
> --- Sujatha Madan <[EMAIL PROTECTED]>
> wrote:
> > Hi,
> >
> > How can I allow root to connect to the database as
> > system. At the moment
> > when I try this, I keep getting a ORA-01034: Oracle
> > not available error,
> > even though the database is up and running fine.
> >
> > Regards,
> >
> > Sujatha
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Sujatha Madan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Root to connect as system

[Sujatha Madan]

Hi,

Thanks to everyone who replied!

I figured it out. I had to apply 6751 permissions to the oracle.exe ... and
it worked just fine after that!

Thanks

sujatha

-Original Message-
Sent: Tuesday, 30 October 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


First, make root a member of the "dba" unix group.  You will then be able to
"connect internal" or "/as sysdba".  This is a bad idea.
Second, at the command line, logged in as root, type:

 ~oracle/.profile

Make sure your ORACLE_SID is set properly and fire away.  This is still a
bad idea.

It would be better for root to "su" to oracle and do anything it needs to do
as the oracle user, i.e.,

su - oracle

As root, no password will be required on most *nix flavors.

Happy "su"'ing,

Scott Shafer
San Antonio, TX


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 6:40 PM


> Hi,
>
> How can I allow root to connect to the database as system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle not available error,
> even though the database is up and running fine.
>
> Regards,
>
> Sujatha



_
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Root to connect as system

[Joe Testa]

my question is "why are you insisting on root logging into the
database???"  create a new userid to do the connection.

i thought i remembered somewhere about root not being able to login,
maybe that was back and hardcoded for svrmgrl.

joe


Sujatha Madan wrote:
> 
> Ok, I have solved the issue of the listener, however I still cannot get root
> to log on as system.
> 
> - My Oracle home is set correct
> - My Oracle sid is set correct
> - ld library path is correct
> - other path;s are correct
> 
> does anyone have an idea on how to fix this?
> 
> thanx
> 
> -Original Message-
> Sent: Tuesday, 30 October 2001 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> I have set the SID correct and all the environment variables correctly. What
> I didn't do was set up the listener and tnsnames. However, when I am trying
> to set up the listener, for some reason it is not able to find the
> executables. It is looking in a different directory. The Oracle Home is set
> correctly.
> 
> -Original Message-
> Sent: Tuesday, 30 October 2001 12:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> Looks like your oracle sid is set incorrectly and you
> are trying to connect without using a tns service name
> 
> Deepak
> 
> PS: have you set the env variables .. type env at the
> unix prompt and check if PATH /ORACLE_HOME/
> LD_LIBRARY_PATH are set correctly
> 
> --- Sujatha Madan <[EMAIL PROTECTED]>
> wrote:
> > Hi,
> >
> > How can I allow root to connect to the database as
> > system. At the moment
> > when I try this, I keep getting a ORA-01034: Oracle
> > not available error,
> > even though the database is up and running fine.
> >
> > Regards,
> >
> > Sujatha
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Sujatha Madan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 

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

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

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

Re: Root to connect as system

[Scott Shafer]

First, make root a member of the "dba" unix group.  You will then be able to
"connect internal" or "/as sysdba".  This is a bad idea.
Second, at the command line, logged in as root, type:

. ~oracle/.profile

Make sure your ORACLE_SID is set properly and fire away.  This is still a
bad idea.

It would be better for root to "su" to oracle and do anything it needs to do
as the oracle user, i.e.,

su - oracle

As root, no password will be required on most *nix flavors.

Happy "su"'ing,

Scott Shafer
San Antonio, TX


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 6:40 PM


> Hi,
>
> How can I allow root to connect to the database as system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle not available error,
> even though the database is up and running fine.
>
> Regards,
>
> Sujatha



_
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: Root to connect as system

[DBarbour]

Is root part of the dba group?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
  
Sujatha Madan  
  
<[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
wo.net.au> cc: 
  
Sent by:   Subject: RE: Root to connect as 
system
[EMAIL PROTECTED]   
  
   
  
   
  
10/29/2001 09:30 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Ok, I have solved the issue of the listener, however I still cannot get
root
to log on as system.

- My Oracle home is set correct
- My Oracle sid is set correct
- ld library path is correct
- other path;s are correct

does anyone have an idea on how to fix this?

thanx

-Original Message-
Sent: Tuesday, 30 October 2001 1:40 PM
To: Multiple recipients of list ORACLE-L


I have set the SID correct and all the environment variables correctly.
What
I didn't do was set up the listener and tnsnames. However, when I am trying
to set up the listener, for some reason it is not able to find the
executables. It is looking in a different directory. The Oracle Home is set
correctly.


-Original Message-
Sent: Tuesday, 30 October 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Looks like your oracle sid is set incorrectly and you
are trying to connect without using a tns service name

Deepak

PS: have you set the env variables .. type env at the
unix prompt and check if PATH /ORACLE_HOME/
LD_LIBRARY_PATH are set correctly


--- Sujatha Madan <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> How can I allow root to connect to the database as
> system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle
> not available error,
> even though the database is up and running fine.
>
> Regards,
>
> Sujatha
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Sujatha Madan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

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

RE: How can I tell if a procedure/package is running?

[Steve Adams]

Hi Doug,

You can look at the mode in which the stored procedure or package is pinned in the 
library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by 
one or more sessions. If necessary,
you can join to X$KGLPN to find the sessions holding the pins. See 
"executing_packages.sql" at
http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all

-Original Message-

How can I tell if a stored procedure or package is in the middle of execution?


-
You can view this message online at http://www.ixora.com.au/q+a/0110/30141015.htm
To unsubscribe from Ixora Answers send a blank email to [EMAIL PROTECTED]


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Root to connect as system

[Sujatha Madan]

Ok, I have solved the issue of the listener, however I still cannot get root
to log on as system.

- My Oracle home is set correct
- My Oracle sid is set correct
- ld library path is correct
- other path;s are correct

does anyone have an idea on how to fix this?

thanx

-Original Message-
Sent: Tuesday, 30 October 2001 1:40 PM
To: Multiple recipients of list ORACLE-L


I have set the SID correct and all the environment variables correctly. What
I didn't do was set up the listener and tnsnames. However, when I am trying
to set up the listener, for some reason it is not able to find the
executables. It is looking in a different directory. The Oracle Home is set
correctly.


-Original Message-
Sent: Tuesday, 30 October 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Looks like your oracle sid is set incorrectly and you
are trying to connect without using a tns service name

Deepak

PS: have you set the env variables .. type env at the
unix prompt and check if PATH /ORACLE_HOME/
LD_LIBRARY_PATH are set correctly


--- Sujatha Madan <[EMAIL PROTECTED]>
wrote:
> Hi,
> 
> How can I allow root to connect to the database as
> system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle
> not available error,
> even though the database is up and running fine.
> 
> Regards,
> 
> Sujatha
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sujatha Madan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 can I tell if a procedure/package is running?

[Steve Adams]

Hi Doug,

You can look at the mode in which the stored procedure or package is pinned in the 
library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by 
one or more sessions. If necessary,
you can join to X$KGLPN to find the sessions holding the pins. See 
"executing_packages.sql" at
http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all

-Original Message-

How can I tell if a stored procedure or package is in the middle of execution?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: New Oracle Install and Old Data Files

[Rachel Carmichael]

Oracle Suppport is not Field Support, I would ask to speak to someone
in field support who was familiar with data unloader.

the tech who came to our offices told me that they could recover
without the system tablespace, it would be more difficult but do-able.


--- Regina Harter <[EMAIL PROTECTED]> wrote:
> Well, we already had Oracle Support tell us there was NO WAY to get
> at that 
> data.  Really, I expect how hard we work at getting it will be
> directly 
> proportional to how may users call moaning about how hard it will be
> to 
> redo the data they entered last week.  I will pass this information
> along, 
> however.
> 
> At 02:10 PM 10/29/01 -0800, you wrote:
> >data unloader WILL work without a system tablespace, although
> obviously
> >it's easier if it exists.
> >
> >in my case we lost the online redo logs and could not force the
> >database to open no matter WHAT we did (and yes, I spent two hours
> on
> >the phone with Oracle Support trying to force it open).
> >
> >we had the system tablespace. we were lucky.  ask Tech Support about
> >Data Unloader and get a number for Field Support.
> >
> >There are about 5 or 6 techs in the country who know how to use it.
> >Three on the East Coast, we forced Oracle to pull someone in from
> >vacation. Since he was getting quintuple time at that point, he
> didn't
> >really care :)
> >
> >
> >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > Yes, you are absolutely right, we have everything except the
> system
> > > tablespace.  The two disks that crashed contained all the program
> > > files,
> > > including unix and oracle,  and the system tablespace.  The disks
> > > containing all the other datafiles were untouched.  However, I
> did
> > > forward
> > > Randy's solution to our DBA, even though I have my own doubts
> about
> > > it
> > > being sufficient.
> > >
> > > At 08:45 AM 10/29/01 -0800, you wrote:
> > > >Yes, but she said that she everything EXCEPT the system
> tablespaces.
> > >  If
> > > >this is true then they're SOL, except for Data Unloader.
> > > >
> > > >
> > > >
> > > >
> > > > Randy
> > >  >
> > > > Kirkpatrick  To: Multiple
> > > recipients of
> > > > list ORACLE-L
> > > > 
> > >  >
> > > > @usa.net>cc:
> > >  >
> > > > Sent by: rootSubject: RE: New
> > > Oracle
> > > > Install and Old Data
> > > >  Files
> > >  >
> > > >
> > > >
> > > > 10/29/2001
> > >  >
> > > > 10:50
> > > > AM
> > > > Please
> > >  >
> > > > respond
> > > > to
> > > > ORACLE-L
> > >  >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >The datafiles contain the tablespaces which contain the data for
> the
> > > >tables,
> > > >indexes, etc. If she has all the datafiles, then she'll have
> access
> > > to all
> > > >the data. I haven't tried it, but this should work for the
> system
> > > >tablespace
> > > >as well.
> > > >
> > > >Randy Kirkpatrick
> > > >
> > > >-Original Message-
> > > >[EMAIL PROTECTED]
> > > >Sent: Monday, October 29, 2001 7:00 AM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >But does she just want the old tablespaces or does she want the
> > > tables and
> > > >indexes that were in those tablespaces?  I don't think that
> simply
> > > >recovering the tablespaces will recover the tablespace contents,
> > > though it
> > > >is the way to start.
> > > >
> > > >Doesn't Oracle have a recovery tool -- pay big bucks, they come
> in
> > > and
> > > >recover your database and then remove the tool -- that will do
> this?
> > > >
> > > >
> > > >
> > > >
> > > > Randy
> > > > Kirkpatrick  To: Multiple
> > > recipients of
> > > >list
> > > >ORACLE-L
> > > > 
> > > > @usa.net>cc:
> > > > Sent by: rootSubject: RE: New
> > > Oracle
> > > >Install
> > > >and Old Data
> > > >  Files
> > > >
> > > > 10/26/2001
> > > > 09:00 PM
> > > > Please
> > > > respond to
> > > > ORACLE-L
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >Regina,
> > > >
> > > >Yes there is - but you probably don't want to do it yourself if
> > > you're not
> > > >a
> > > >DBA ...
> > > >
> > > >do a backup control file to trace:
> > > >
> > > >alter database  backup controlfile to trace;
> > > >
> > > >shut down the database and modify the sql in the file you
> created so
> > > it
> > > >contains the information for the tablespaces you need.
> > > >
> > > >use the sql file to start up the database
> > > >
> > > >hopefully everything starts ok. Can't guarantee what happens to
> > > integri

RE: Root to connect as system

[Sujatha Madan]

I have set the SID correct and all the environment variables correctly. What
I didn't do was set up the listener and tnsnames. However, when I am trying
to set up the listener, for some reason it is not able to find the
executables. It is looking in a different directory. The Oracle Home is set
correctly.


-Original Message-
Sent: Tuesday, 30 October 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Looks like your oracle sid is set incorrectly and you
are trying to connect without using a tns service name

Deepak

PS: have you set the env variables .. type env at the
unix prompt and check if PATH /ORACLE_HOME/
LD_LIBRARY_PATH are set correctly


--- Sujatha Madan <[EMAIL PROTECTED]>
wrote:
> Hi,
> 
> How can I allow root to connect to the database as
> system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle
> not available error,
> even though the database is up and running fine.
> 
> Regards,
> 
> Sujatha
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sujatha Madan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sujatha Madan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Root to connect as system

[Richard Ji]

Is ORACLE_SID set for root?

>>> [EMAIL PROTECTED] 10/29/01 07:40PM >>>
Hi,

How can I allow root to connect to the database as system. At the moment
when I try this, I keep getting a ORA-01034: Oracle not available error,
even though the database is up and running fine.

Regards,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Richard Ji
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Spam - Re: Oracle Training from InterTrain

[Richard Ji]

In the future, if we get a spam like this, may I suggest we add that person
to our mailing list?  This way we SPAM them right back (at least with useful
stuff and maybe they will become a DBA).  Since they e-mailed
us first which expressed an interest in our mailing list, I think it's only fair
that we include them.

Richard

>>> [EMAIL PROTECTED] 10/29/01 05:15PM >>>
I've always found that it's much more fun and creative to respond to
things using perfectly proper English that still slashes them to
ribbons..   


--- [EMAIL PROTECTED] wrote:
> Here's the email I received this morning from Cindy Conners in
> regards
> to my inquiry Friday when she spammed many list members.
> 
> It appears that this wasn't actually her fault.  I know lot's of
> cynics
> will
> disagree, but that's tough.
> 
> I must say I'm a little dissapointed that so many folks responded to
> her with profanity.  I'm always dismayed at the number of people
> that are unable to express themselves without resorting to vulgar
> speech.  Get a dictionary and a thesaurus and learn to use them.
> 
> Jared
> 
> 
> - Forwarded by Jared Still/Radisys_Corporation/US on 10/29/01
> 09:28 AM
> -
>  
>
> "Cindy Connors"  
>
>  <[EMAIL PROTECTED]>  
> train.net>cc:
>
>   Subject: Re: Oracle
> Training from InterTrain   
> 10/29/01 10:35   
>
> AM   
>
>  
>
>  
>
> 
> 
> 
> 
> I sincerely apologize. This list was forwarded to me internally
> without any
> indication of its source. I assumed that I was to send out one of our
> standard emails. This is my fault for not checking it out before I
> sent my
> email.
> 
> I appreciate your response to explain to me my error. Obviously, many
> people
> objected. There are 137 messages in my inbox this morning that emails
> to me
> were rejected by our server that because they contained profanity.
> You have
> a tough crowd.
> 
> I was never my intention to harm anyone. As list manager, can you
> suggest
> the best way for me to apologize to everyone and assure them it will
> not
> happen again.
> 
> Cindy Connors
> 
> -Original Message-
> To: Cindy Connors <[EMAIL PROTECTED]>
> 
> >
> >
> >Cindy,
> >
> >Spamming addresses harvested from mailing lists is not considered
> good
> >netiquette.
> >
> >Personally, I don't care.  A large number of folks that subscribe to
> this
> >list do care
> >however, so I felt that as owner of the list I should say something.
> >
> >Please don't do it again.
> >
> >Thank You
> >
> >Jared Still
> >Owner of [EMAIL PROTECTED] 
> 
> 
> 
> 
> -- 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.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: Richard Ji
  INET: [EMAIL PROTE

Re: Root to connect as system

[Deepak Thapliyal]

Looks like your oracle sid is set incorrectly and you
are trying to connect without using a tns service name

Deepak

PS: have you set the env variables .. type env at the
unix prompt and check if PATH /ORACLE_HOME/
LD_LIBRARY_PATH are set correctly


--- Sujatha Madan <[EMAIL PROTECTED]>
wrote:
> Hi,
> 
> How can I allow root to connect to the database as
> system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle
> not available error,
> even though the database is up and running fine.
> 
> Regards,
> 
> Sujatha
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sujatha Madan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Root to connect as system

[Sujatha Madan]

Hi,

How can I allow root to connect to the database as system. At the moment
when I try this, I keep getting a ORA-01034: Oracle not available error,
even though the database is up and running fine.

Regards,

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

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

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

RE: RE: Network Appliance

[Aschenbrenner, Alan]

Dick,

I believe that's the way it was setup.  But, ever since they
installed the patch on the netapp, the "resource temporary unavailable"
problem hasn't reared it's ugly head again.  It must have been a bug...
I'm still a bit leery of the netapps though.

Alan

-Original Message-
Sent: Monday, October 29, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L


Alan,

One of the reasons that we have not started using NETAPP with our
Oracle
DB's is that you should have a dedicated network connection between the
server
and the appliance.  This can take the form of a network cable between
the
network card and the appliance or a dedicated VLAN.  If you don't have
that,
then your just begging for trouble.

Dick Goulet

Reply Separator
Author: "Aschenbrenner; Alan" <[EMAIL PROTECTED]>
Date:   10/29/2001 9:00 AM

Charlie,

   My company has been using Network Appliances for quite a while now.
Early on we had some problems where the net apps would just seem to go
away for a second or two, causing a "Resource Temporarily Unavailable"
error message.  This would usually crash one or more databases.  After
much complaining and convincing that this wasn't a database issue, the
network guys applied a patch to the Network Appliances and we haven't
seen the error since...

Alan Aschenbrenner
[EMAIL PROTECTED]
IHS Group
(303)-858-6394

-Original Message-
Sent: Monday, October 29, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L


I've been asked to review Power Point marketing presentation
and a "white paper" both publishd by Network Appliance. 

I'd like to hear off list from anyone who has had some hands on
experience with this technology.

TIA & HAND!

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Aschenbrenner, Alan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Aschenbrenner, Alan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: New Oracle Install and Old Data Files

[Regina Harter]

Well, we already had Oracle Support tell us there was NO WAY to get at that 
data.  Really, I expect how hard we work at getting it will be directly 
proportional to how may users call moaning about how hard it will be to 
redo the data they entered last week.  I will pass this information along, 
however.

At 02:10 PM 10/29/01 -0800, you wrote:
>data unloader WILL work without a system tablespace, although obviously
>it's easier if it exists.
>
>in my case we lost the online redo logs and could not force the
>database to open no matter WHAT we did (and yes, I spent two hours on
>the phone with Oracle Support trying to force it open).
>
>we had the system tablespace. we were lucky.  ask Tech Support about
>Data Unloader and get a number for Field Support.
>
>There are about 5 or 6 techs in the country who know how to use it.
>Three on the East Coast, we forced Oracle to pull someone in from
>vacation. Since he was getting quintuple time at that point, he didn't
>really care :)
>
>
>--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > Yes, you are absolutely right, we have everything except the system
> > tablespace.  The two disks that crashed contained all the program
> > files,
> > including unix and oracle,  and the system tablespace.  The disks
> > containing all the other datafiles were untouched.  However, I did
> > forward
> > Randy's solution to our DBA, even though I have my own doubts about
> > it
> > being sufficient.
> >
> > At 08:45 AM 10/29/01 -0800, you wrote:
> > >Yes, but she said that she everything EXCEPT the system tablespaces.
> >  If
> > >this is true then they're SOL, except for Data Unloader.
> > >
> > >
> > >
> > >
> > > Randy
> >  >
> > > Kirkpatrick  To: Multiple
> > recipients of
> > > list ORACLE-L
> > > 
> >  >
> > > @usa.net>cc:
> >  >
> > > Sent by: rootSubject: RE: New
> > Oracle
> > > Install and Old Data
> > >  Files
> >  >
> > >
> > >
> > > 10/29/2001
> >  >
> > > 10:50
> > > AM
> > > Please
> >  >
> > > respond
> > > to
> > > ORACLE-L
> >  >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >The datafiles contain the tablespaces which contain the data for the
> > >tables,
> > >indexes, etc. If she has all the datafiles, then she'll have access
> > to all
> > >the data. I haven't tried it, but this should work for the system
> > >tablespace
> > >as well.
> > >
> > >Randy Kirkpatrick
> > >
> > >-Original Message-
> > >[EMAIL PROTECTED]
> > >Sent: Monday, October 29, 2001 7:00 AM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >But does she just want the old tablespaces or does she want the
> > tables and
> > >indexes that were in those tablespaces?  I don't think that simply
> > >recovering the tablespaces will recover the tablespace contents,
> > though it
> > >is the way to start.
> > >
> > >Doesn't Oracle have a recovery tool -- pay big bucks, they come in
> > and
> > >recover your database and then remove the tool -- that will do this?
> > >
> > >
> > >
> > >
> > > Randy
> > > Kirkpatrick  To: Multiple
> > recipients of
> > >list
> > >ORACLE-L
> > > 
> > > @usa.net>cc:
> > > Sent by: rootSubject: RE: New
> > Oracle
> > >Install
> > >and Old Data
> > >  Files
> > >
> > > 10/26/2001
> > > 09:00 PM
> > > Please
> > > respond to
> > > ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > >Regina,
> > >
> > >Yes there is - but you probably don't want to do it yourself if
> > you're not
> > >a
> > >DBA ...
> > >
> > >do a backup control file to trace:
> > >
> > >alter database  backup controlfile to trace;
> > >
> > >shut down the database and modify the sql in the file you created so
> > it
> > >contains the information for the tablespaces you need.
> > >
> > >use the sql file to start up the database
> > >
> > >hopefully everything starts ok. Can't guarantee what happens to
> > integrity,
> > >etc. if you don't have all the tablespaces.
> > >
> > >
> > >Randy Kirkpatrick
> > >
> > >
> > >
> > >-Original Message-
> > >Harter
> > >Sent: Friday, October 26, 2001 5:10 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Okay People,
> > >
> > >I am not the DBA and don't have all the details but this is our
> > situation
> > >the way it was explained to me:
> > >
> > >We had a server crash to the point where Unix and Oracle had to be
> > >reinstalled, however the disks containing our data tablespaces (that
> > is,
> > >everything but the system tablespaces) are still good, and
> > apparently for
> >

RE: 11.5.5 on Tru64

[John Kanagaraj]

Bambi,
 
I think this will be better answered on the OAUGnet-DBA list at
http://www.oaug.org    Sorry - you will have to monitor
another list too! As for Tru64, I think it is on its way out. I don't know
of anyone of 11.5.5 on Tru64. Btw, 'clean' and 'latest' don't go together,
esp. in Apps 11i!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com

** The opinions and statements above are entirely my own and not
those of my employer or clients **


-Original Message-
Sent: Monday, October 29, 2001 1:43 PM
To: Multiple recipients of list ORACLE-L



Hi Everybody!

Is anyone running 11.5.5 on Tru64?  Is it clean?  What's this about a single
Apache server?  How do I even check to see how many Apache servers I have?

TIA!

Bambi. 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: # of concurrent connections

[Connor McDonald]

v$resource_limit

hth
connor

 --- Kimberly Smith <[EMAIL PROTECTED]>
wrote: > Isn't there a way to tell what the high water
mark
> is for connections to the
> database?  I have been trying to figure it out but
> have not seen anything
> yet.  I thought I used to do this way back when I
> started my career.
> 
> 
> Kimberly Smith
> GMD Fujitsu
> Database Administrator
> (503) 669-6050
> 
> -- 
> 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). 

=
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"


Nokia Game is on again. 
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media adventure before November 3rd.
-- 
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: FAST MIGRATION OF DATA

[DENNIS WILLIAMS]

Singh - You may also want to take a look at cloning your database. This
essentially the first step to creating a standby database, but doesn't
necessarily mean going as far as loading the redo logs. Whether this will
suffice for your purposes will depend on how long you will have to switch
over. If you must have the system unavailable for just a few minutes, then
the standby database may be your only alternative, and I believe that you
are receiving good advice.
However, if you have a window of a few hours, then cloning may be
good enough. As far as the different OS mount points, the cloning techniques
handle that. I'm guessing that if you are within Oracle certification, patch
levels of the OS won't matter. To get more information on cloning a
database, go to http://www.orafaq.com and search on "cloning".
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, October 29, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


Richard
The OS patchs are diffrent and OS mount points are diffrent.I have one 
questions as per stand by Database creation the following things are 
required
-copy of datafiles,standby controlfile,parameter files and archived logs 
from primary.
Then it is necessary to have either cold or hotbackup of datafiles.Ultimate 
my focus is to save time migration.Let me suggest please.
Thanks
-Seema


>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 13:12:25 -0800
>
>Yes you can create the same "prod" on your new box.  Now when you say
>configuration are different, please be more specific.  Do you mean the 
>mount
>points will be different, the OS will be different?
>
>Richard
>
> >>> [EMAIL PROTECTED] 10/29/01 03:57PM >>>
>Richard
>Let the production instance name is "prod".Can I create standby database
>with same name like "prod" on another box.
>If the configuration of both servers are diffrent then what will be best
>approach of data migration.
>Thanks
>-Seema
>
>
> >From: "Richard Ji" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: FAST MIGRATION OF DATA
> >Date: Mon, 29 Oct 2001 11:15:32 -0800
> >
> >Assuming the same Oralce and OS version on both Unix boxes.  You can 
>create
> >a standby on the new box.  Then activate it.  The down time will be the
> >time
> >you need to move the online redo over and apply it.
> >
> >Richard
> >
> > >>> [EMAIL PROTECTED] 10/29/01 11:15AM >>>
> >Hi
> >I have one production database of 60gb .i want to migrate from existing
> >unix
> >box to new unix box with minimun downtime.Please suggest what will be 
>good
> >method for migration.I have oracle 8.1.7 on solaris 2.7.
> >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).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>
>_
>Get 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 spe

RE: date format in ksh

[Brian MacLean]

Use the /usr/sadm/bin/valdate command and 
check the return status. Examples: 
 
 
--GOOD DATE--
 
12322:oracle@e6500a> valdate -f "%e-%b-%Y" 
1-jan-200112322:oracle@e6500a> echo $?0
 
--BAD DATE--
 
12322:oracle@e6500a> valdate -f "%e-%b-%Y" 
41-JaN-200112322:oracle@e6500a> echo $?1
 
The valdate command doesn't seam to like leading 0's 
(zero's) so you can just use sed to strip it off.  This example should do 
most of what ya need:
 
12322:oracle@e6500a> cat 
dateck.ksh#!/bin/ksh
vDATE="${1}"if valdate -f "%e-%b-%Y" $(echo 
"${vDATE}" | sed "s/^0//")then  echo "Good date 
${vDATE}"else  echo "Bad date ${vDATE}"fi
 
 
12322:oracle@e6500a> dateck.ksh 41-mar-2001Bad 
date 41-mar-200112322:oracle@e6500a> dateck.ksh 01-Mar-2001Good date 
01-Mar-2001

  -Original Message-From: Suhen Pather 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 
  2001 8:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: date format in ksh
  
  List,
   
  Sorry to deviate from the topic, 
  but
  I am writing a korn shell script 
  that would exit if the date format is
  incorrect.
   
  I just need something to compare 
  the date format passed  in with 
  DD-MON-.
   
  Eg. 
  I am passing an argument to my ksh 
  script being the date.
  If the date is in any other format 
  but DD-MON- the ksh must exit.
   
  Eg.  sh test.ksh 02/05/1999
   
  It must 
  exit.
   
  The only format excepted should be 
  
  sh test.ksh 
  02-MON-
   
  TIA
   
  Regards
  Suhen
   
   

Re: FAST MIGRATION OF DATA

[Seema Singh]

Richard
The OS patchs are diffrent and OS mount points are diffrent.I have one 
questions as per stand by Database creation the following things are 
required
-copy of datafiles,standby controlfile,parameter files and archived logs 
from primary.
Then it is necessary to have either cold or hotbackup of datafiles.Ultimate 
my focus is to save time migration.Let me suggest please.
Thanks
-Seema


>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 13:12:25 -0800
>
>Yes you can create the same "prod" on your new box.  Now when you say
>configuration are different, please be more specific.  Do you mean the 
>mount
>points will be different, the OS will be different?
>
>Richard
>
> >>> [EMAIL PROTECTED] 10/29/01 03:57PM >>>
>Richard
>Let the production instance name is "prod".Can I create standby database
>with same name like "prod" on another box.
>If the configuration of both servers are diffrent then what will be best
>approach of data migration.
>Thanks
>-Seema
>
>
> >From: "Richard Ji" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: FAST MIGRATION OF DATA
> >Date: Mon, 29 Oct 2001 11:15:32 -0800
> >
> >Assuming the same Oralce and OS version on both Unix boxes.  You can 
>create
> >a standby on the new box.  Then activate it.  The down time will be the
> >time
> >you need to move the online redo over and apply it.
> >
> >Richard
> >
> > >>> [EMAIL PROTECTED] 10/29/01 11:15AM >>>
> >Hi
> >I have one production database of 60gb .i want to migrate from existing
> >unix
> >box to new unix box with minimun downtime.Please suggest what will be 
>good
> >method for migration.I have oracle 8.1.7 on solaris 2.7.
> >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).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Richard Ji
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>
>_
>Get 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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Richard Ji
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Get your FREE download of MSN 

RE: New Oracle Install and Old Data Files

[Rachel Carmichael]

data unloader WILL work without a system tablespace, although obviously
it's easier if it exists.

in my case we lost the online redo logs and could not force the
database to open no matter WHAT we did (and yes, I spent two hours on
the phone with Oracle Support trying to force it open).

we had the system tablespace. we were lucky.  ask Tech Support about
Data Unloader and get a number for Field Support.

There are about 5 or 6 techs in the country who know how to use it.
Three on the East Coast, we forced Oracle to pull someone in from
vacation. Since he was getting quintuple time at that point, he didn't
really care :)


--- Regina Harter <[EMAIL PROTECTED]> wrote:
> Yes, you are absolutely right, we have everything except the system 
> tablespace.  The two disks that crashed contained all the program
> files, 
> including unix and oracle,  and the system tablespace.  The disks 
> containing all the other datafiles were untouched.  However, I did
> forward 
> Randy's solution to our DBA, even though I have my own doubts about
> it 
> being sufficient.
> 
> At 08:45 AM 10/29/01 -0800, you wrote:
> >Yes, but she said that she everything EXCEPT the system tablespaces.
>  If
> >this is true then they're SOL, except for Data Unloader.
> >
> >
> > 
> >
> > Randy 
>  >
> > Kirkpatrick  To: Multiple
> recipients of 
> > list ORACLE-L
> >  
>  >
> > @usa.net>cc: 
>  >
> > Sent by: rootSubject: RE: New
> Oracle 
> > Install and Old Data
> >  Files 
>  >
> > 
> >
> > 10/29/2001 
>  >
> > 10:50 
> > AM
> > Please 
>  >
> > respond 
> > to
> > ORACLE-L 
>  >
> > 
> >
> > 
> >
> >
> >
> >
> >
> >The datafiles contain the tablespaces which contain the data for the
> >tables,
> >indexes, etc. If she has all the datafiles, then she'll have access
> to all
> >the data. I haven't tried it, but this should work for the system
> >tablespace
> >as well.
> >
> >Randy Kirkpatrick
> >
> >-Original Message-
> >[EMAIL PROTECTED]
> >Sent: Monday, October 29, 2001 7:00 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >But does she just want the old tablespaces or does she want the
> tables and
> >indexes that were in those tablespaces?  I don't think that simply
> >recovering the tablespaces will recover the tablespace contents,
> though it
> >is the way to start.
> >
> >Doesn't Oracle have a recovery tool -- pay big bucks, they come in
> and
> >recover your database and then remove the tool -- that will do this?
> >
> >
> >
> >
> > Randy
> > Kirkpatrick  To: Multiple
> recipients of
> >list
> >ORACLE-L
> > 
> > @usa.net>cc:
> > Sent by: rootSubject: RE: New
> Oracle
> >Install
> >and Old Data
> >  Files
> >
> > 10/26/2001
> > 09:00 PM
> > Please
> > respond to
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >Regina,
> >
> >Yes there is - but you probably don't want to do it yourself if
> you're not
> >a
> >DBA ...
> >
> >do a backup control file to trace:
> >
> >alter database  backup controlfile to trace;
> >
> >shut down the database and modify the sql in the file you created so
> it
> >contains the information for the tablespaces you need.
> >
> >use the sql file to start up the database
> >
> >hopefully everything starts ok. Can't guarantee what happens to
> integrity,
> >etc. if you don't have all the tablespaces.
> >
> >
> >Randy Kirkpatrick
> >
> >
> >
> >-Original Message-
> >Harter
> >Sent: Friday, October 26, 2001 5:10 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Okay People,
> >
> >I am not the DBA and don't have all the details but this is our
> situation
> >the way it was explained to me:
> >
> >We had a server crash to the point where Unix and Oracle had to be
> >reinstalled, however the disks containing our data tablespaces (that
> is,
> >everything but the system tablespaces) are still good, and
> apparently for
> >several reasons, we have not had a good backup for at least a week. 
> Is
> >there anyway to get a new Oracle install to recognize old
> tablespaces?
> >
> >TIA, Regina
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Regina Harter
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling o

RE: OT : from Win XP to RDRAM or SDRAM ?

[Christopher Spence]

The member is considerably faster.  If speed is your most important factor
then yes it is well worth it.

But AMD has bought the rights to a new type of member that exceeds RDRAM and
will be considerably cheaper.  I don't know how public this is yet but this
should give AMD a good nitch into the market to help fight Intel.

AMD has already took a large market share due to the flop Pentium 4.
The Pentium 4 was released lacking many features just so it will be stable.
So what you really have is a watered down Pentium 4.  Not to mention the
need to buy Intel PS, Case, MB and such.

I am not an AMD fan, I always stayed away from their chips once they hit the
Pentium market, but 1.2GHz and higher they just smoke Pentiums.  Their fast,
cheap, and very relievable.  All the problems AMD used to have in the
100-900Mhz time frame have seem to gone away.  They have become a very
strong competitor.  With Intel having the Alpha technology is certainly a
hurt for AMD.

But without my ramblings, I would go AMD 1.4-1.5GHz and DDR memory, it is a
very quick system, and very reasonably priced.  And they actually have Dual
AMD boards now with 64bit PCI which is nice for the smaller servers.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L

Let's say someone is buying a new pc Pentium 4, is the
cost of the RDRAM memory chip is worth the performance
compare to SDRAM ?

TIA

-Original Message-
Behalf Of Kimberly
Smith
Sent: 29 octobre, 2001 14:05
To: Multiple recipients of list ORACLE-L


Hum, you got ripped off.  I just put in a 512MB SDRAM
for $69 bring
me to a grand total of 780MB but that is at home.  At
work I actually
do have 512MB in my machine as well.  

-Original Message-
Sent: Monday, October 29, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L


Chuck,
 Have you checked the prices for ram lately? a 256
SDRAM is $26 and a 256
RAMBUS is around $108. These prices also depent on the
machine manufacture.
A 256 RAMBUS for my Dell is $899. My server is a
generic box running Linux
and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the
prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5
McDonald's BigMac menu
:-). It is nothing compared to the time you loose
waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only
dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster
than WinNT or Win2K
if you have 256 MB. We could not test the server side
yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows
XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

11.5.5 on Tru64

[Bellows, Bambi]

Title: Cursor Variable question









Hi Everybody!

Is anyone running 11.5.5 on Tru64?  Is it clean?  What's this about a single Apache
server?  How do I even check to see
how many Apache servers I have?

TIA!

Bambi. 

RE: Last day of the month unix

[Nicoll, Iain (Calanais)]

And personally I prefer your solution as it shows a bit of thought.  :)

Iain Nicoll

-Original Message-
Sent: 29 October 2001 20:00
To: Multiple recipients of list ORACLE-L



But my version was so much more obtuse1  :)

Jared



 

"Nicoll, Iain

(Calanais)"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
 Subject: RE: Last day of the
month unix
Sent by:

[EMAIL PROTECTED]

 

 

10/29/01 09:25

AM

Please respond

to ORACLE-L

 

 





Not sure if you want this from sql or unix

but there is the last_day function

eg select last_day(sysdate) from dual

to get the last date

or

select to_char(last_day(sysdate),'dd') from dual

to get the day portion only.


-Original Message-
Sent: 29 October 2001 15:55
To: Multiple recipients of list ORACLE-L



Try this:

select trunc(add_months(sysdate,1),'MM')-1
from dual;

Jared


On Monday 29 October 2001 00:00, Sinard Xing wrote:
> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>  lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?
>
>
>
>
> Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Win XP

[George Hofilena]

>From where I came from, probably about one in every 50 (optimistic estimate)
computer users there have dial-up access to the internet.  MS has
practically cut itself off of about this percentage in terms of potential
sales.

George


-Original Message-
Sent: Monday, October 29, 2001 12:33 PM
To: Multiple recipients of list ORACLE-L


Remember
XP can only be used on ONE machine. It takes a branding and authorization
code from M$$$ to activate it. If by chance you get around the activation
code it will be checked when you go to the internet and against a master
table that M$$$ has. If it is an unauthorized "copy" then you are breaking
the law and on your own. M$$$ can then prosecute if they desire.  We have a
10 machine development license and each machine has to have a different
authorization code from M. The machine branding is dependent upon the
hardware making up the machine.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 02:20PM >>>
More realistic pricing ("street value"):

http://www.bestbuy.com/software/promo.asp?m=1023&Cat=1807&p=1807 

But for my money:

http://www.linux.org :D


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

-Original Message-
Sent: Monday, October 29, 2001 12:20
To: Multiple recipients of list ORACLE-L


IS THIS REAL?  They charge this much for XP?  
Lisa Koivu 
Oracle Database Monkey 
-- 
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).

-- 
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: George Hofilena
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Win XP

[Christopher Spence]

1.  Corporate Edition does not have the validation piece.  Only serial
number

2.  The validation has already been hacked and not even valid anymore, even
though it will still prevent 90% of the population.


I don't see why they spend so much money on validation when it will just be
cracked.  It just ups the price of the product for everyone.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 3:33 PM
To: Multiple recipients of list ORACLE-L

Remember
XP can only be used on ONE machine. It takes a branding and authorization
code from M$$$ to activate it. If by chance you get around the activation
code it will be checked when you go to the internet and against a master
table that M$$$ has. If it is an unauthorized "copy" then you are breaking
the law and on your own. M$$$ can then prosecute if they desire.  We have a
10 machine development license and each machine has to have a different
authorization code from M. The machine branding is dependent upon the
hardware making up the machine.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 02:20PM >>>
More realistic pricing ("street value"):

http://www.bestbuy.com/software/promo.asp?m=1023&Cat=1807&p=1807 

But for my money:

http://www.linux.org :D


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

-Original Message-
Sent: Monday, October 29, 2001 12:20
To: Multiple recipients of list ORACLE-L


IS THIS REAL?  They charge this much for XP?  
Lisa Koivu 
Oracle Database Monkey 
-- 
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).

-- 
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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: invalid object after imp

[mitchell]

Dear DBAs

I exp/imp whole OFA database and there are some invalid package bodies left
on newly imported db.
When I recompile it I got message  "insufficient privilege to access object
SYS.DBMS_LOCK"


I check dba_sys_priv and both exp and imp databases are the same for those
package bodies owner.
I also checked dbms_lock and found everybody has exec privilege on the
package.

What is wrong.

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

Cursor Variable question

[Koivu, Lisa]

Title: Cursor Variable question





Hello all, 


Gave myself a project to split up some of the code I wrote.  I want to change one of my utility procedures to return a ref cursor to the calling program. 

Right now it uses pl/sql tables.  Ref cursors and index-by tables do not play together, so I'm replacing the pl/sql tables with a declared record object.  

 
With an index-by table I can buzz through it as many times as I want, restart at record 1, no problem.  However, it looks like I can't do that with ref cursors.  You open the cursor 'FOR' the query and return the refcursor, limiting loops by 'EXIT WHEN refcur%NOTFOUND'.  Call me a bonehead but I can't figure out how to blow through a refcursor over and over without reopening the refcursor and causing another hit to the database (which is what I'm trying to avoid, the data I need is already in memory).  Is it possible to 'rewind' a refcursor without closing it and reopening it?

Please enlighten me if I've got this wrong. 


Thank you


Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
954-935-4117

Re: FAST MIGRATION OF DATA

[Richard Ji]

Yes you can create the same "prod" on your new box.  Now when you say
configuration are different, please be more specific.  Do you mean the mount
points will be different, the OS will be different?

Richard

>>> [EMAIL PROTECTED] 10/29/01 03:57PM >>>
Richard
Let the production instance name is "prod".Can I create standby database 
with same name like "prod" on another box.
If the configuration of both servers are diffrent then what will be best 
approach of data migration.
Thanks
-Seema


>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 11:15:32 -0800
>
>Assuming the same Oralce and OS version on both Unix boxes.  You can create
>a standby on the new box.  Then activate it.  The down time will be the 
>time
>you need to move the online redo over and apply it.
>
>Richard
>
> >>> [EMAIL PROTECTED] 10/29/01 11:15AM >>>
>Hi
>I have one production database of 60gb .i want to migrate from existing 
>unix
>box to new unix box with minimun downtime.Please suggest what will be good
>method for migration.I have oracle 8.1.7 on solaris 2.7.
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Richard Ji
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Data warehouse on Win2K

[Kimberly Smith]

Hum, a lot of headaches.  

-Original Message-
Sent: Monday, October 29, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L





Afraid  I'm not going to be much help.

I would like to know why you are moving from unix to Win2K however.

Jared




 

Johnson

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



Sent by:

[EMAIL PROTECTED]

om

 

 

10/29/01 11:00

AM

Please respond

to ORACLE-L

 

 





Hi guys,

Our company is looking into the possiblity of moving
our data warehouse (around 500GB) from unix to Win2k.

Does anybody have any thoughts on what I can expect if
we go this way?

Johnson

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

RE: Location of PLAN_TABLE

[Deepak Thapliyal]

how about --> set autot [trace] [traceonly]

Deepak

PS: as they say: works for me;
--- "Rao, Maheswara" <[EMAIL PROTECTED]>
wrote:
> We keep plan table in each of the developers schema
> and thus there is no
> problem of deletions and maintenance of this table. 
> Also, this is not such
> an important table for DBA maintenance.
>  
> Rao
> 
> -Original Message-
> Sent: Monday, October 29, 2001 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Rather a trivial question, but our DBA team is
> discussing how best 
> to implement the location of the plan table.   My
> preference is 
> is simply create is as SYS, public synonym, and
> grant privs on 
> it to our developers.   I'm being outvoted by the
> others, who 
> want to create it in each and every application
> schema, but still grant 
> access to all developers with no synonyms, the
> thinking being, that 
> it would help to minimize accidental deletions of
> execution plans 
> and so forth.  
> 
> My belief is that's simply over-thinking this issue.
>   What do you 
> do at your sites?  
> 
> Thanks. 
> 
>  
> Jeffery D Thomas 
> DBA 
> Thomson Information Services 
> Thomson multimedia Inc. 
> 
> Email: [EMAIL PROTECTED] 
> DBA Quickplace: http://gkmqp.tce.com/tis_dba
> 
> 
>  
>   
> 
> 


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: FAST MIGRATION OF DATA

[Seema Singh]

Richard
Let the production instance name is "prod".Can I create standby database 
with same name like "prod" on another box.
If the configuration of both servers are diffrent then what will be best 
approach of data migration.
Thanks
-Seema


>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 11:15:32 -0800
>
>Assuming the same Oralce and OS version on both Unix boxes.  You can create
>a standby on the new box.  Then activate it.  The down time will be the 
>time
>you need to move the online redo over and apply it.
>
>Richard
>
> >>> [EMAIL PROTECTED] 10/29/01 11:15AM >>>
>Hi
>I have one production database of 60gb .i want to migrate from existing 
>unix
>box to new unix box with minimun downtime.Please suggest what will be good
>method for migration.I have oracle 8.1.7 on solaris 2.7.
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Richard Ji
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Get 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: Win XP

[Ken Janusz]

Title: RE: Win XP









We use
Windows 2000 on our company machines. 
No problems – works just fine.

 

Kenneth C.
Janusz, CPIM 

Database
Conversion Lead 

Sufficient
System, Inc.  

Minneapolis,
MN

 

 

-Original
Message-
From: Jon Baker
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001
12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Win XP

 

yea, sun should not develop solstice or
java.  ;-) 





-Original Message- 
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 29, 2001 12:45 PM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: Win XP 

 

I have not seen win2K yet! 

It's amazing how we get a new O/S version
every year from Windows! 

I think O/S should be only a stable plain
simple O/S with nothing fancy and 
all the fancy things should be third party applications by other
companies 
not the same company! 

-Original Message- 
Sent: Monday, October 29, 2001 12:00 AM 
To: Multiple recipients of list ORACLE-L 

 

Hi! 

Has anyone tried installing v8.1.7 or v9i
on Windows XP??? 

Cheers, 

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

Fat City Network
Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California    --
Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(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: Win XP

[Ron Rogers]

Chuck,
 If the work stations run Win98, they do not work properly with more than 512Meg RAM.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 02:30PM >>>
Thanks for the advice.  Unfortunately, I don't do the purchasing here at the
office.  Otherwise, I'd have 1 gig of ram.  I am very aware of the price of
RAM, however standard workstation policies are often restrictive.

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 13:20
To: Multiple recipients of list ORACLE-L


Chuck,
 Have you checked the prices for ram lately? a 256 SDRAM is $26 and a 256
RAMBUS is around $108. These prices also depent on the machine manufacture.
A 256 RAMBUS for my Dell is $899. My server is a generic box running Linux
and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5 McDonald's BigMac menu
:-). It is nothing compared to the time you loose waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

RE: ITL, DELAYED BLOCK CLEANOUT

[K Gopalakrishnan]

I have no problems in accessing that.
Alternatively you can find that at
http://www.revealnet.com/newsletter/newsletter_1100.htm



Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
Thapliyal
Sent: Monday, October 29, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L

is this page still available or has been moved. I got
an error trying to access the link

Thx
Deepak
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The  document is a draft copy. There are few (not
> much tech)
> errors. So take that with a pinch of salt
>
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
>
> -Original Message-
> Gopalakrishnan
> Sent: Monday, October 29, 2001 9:40 AM
> To: Multiple recipients of list ORACLE-L
>
> Vladimir,
>
> Have a look at
> http://www.geocities.com/kgkrish/transactions.html
>
> This will solve most of your questions. If not Pls
> let me know.
>
> Thanks
>
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
>
> -Original Message-
> Barac - posao
> Sent: Monday, October 29, 2001 6:25 AM
> To: Multiple recipients of list ORACLE-L
>
> Just curious...
>
> Could someone shed some light on
>
> INTERESTED TRANSACTIONS LIST
>
> and
>
> DELAYED BLOCK CLEANOUT?
>
> Thanks
>


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ITL, DELAYED BLOCK CLEANOUT

[K Gopalakrishnan]

I have no problems in accessing that.
Alternatively you can find that at
http://www.revealnet.com/newsletter/newsletter_1100.htm



Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
Thapliyal
Sent: Monday, October 29, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L

is this page still available or has been moved. I got
an error trying to access the link

Thx
Deepak
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The  document is a draft copy. There are few (not
> much tech)
> errors. So take that with a pinch of salt
>
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
>
> -Original Message-
> Gopalakrishnan
> Sent: Monday, October 29, 2001 9:40 AM
> To: Multiple recipients of list ORACLE-L
>
> Vladimir,
>
> Have a look at
> http://www.geocities.com/kgkrish/transactions.html
>
> This will solve most of your questions. If not Pls
> let me know.
>
> Thanks
>
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
>
> -Original Message-
> Barac - posao
> Sent: Monday, October 29, 2001 6:25 AM
> To: Multiple recipients of list ORACLE-L
>
> Just curious...
>
> Could someone shed some light on
>
> INTERESTED TRANSACTIONS LIST
>
> and
>
> DELAYED BLOCK CLEANOUT?
>
> Thanks
>


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Win XP

[Ron Rogers]

Remember
XP can only be used on ONE machine. It takes a branding and authorization code from 
M$$$ to activate it. If by chance you get around the activation code it will be 
checked when you go to the internet and against a master table that M$$$ has. If it is 
an unauthorized "copy" then you are breaking the law and on your own. M$$$ can then 
prosecute if they desire.  We have a 10 machine development license and each machine 
has to have a different authorization code from M. The machine branding is 
dependent upon the hardware making up the machine.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 02:20PM >>>
More realistic pricing ("street value"):

http://www.bestbuy.com/software/promo.asp?m=1023&Cat=1807&p=1807 

But for my money:

http://www.linux.org :D


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

-Original Message-
Sent: Monday, October 29, 2001 12:20
To: Multiple recipients of list ORACLE-L


IS THIS REAL?  They charge this much for XP?  
Lisa Koivu 
Oracle Database Monkey 
-- 
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).

--
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: Last day of the month unix

[Jared . Still]

But my version was so much more obtuse1  :)

Jared



   
   
"Nicoll, Iain  
   
(Calanais)"To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
 Subject: RE: Last day of the month unix 
   
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
10/29/01 09:25 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Not sure if you want this from sql or unix

but there is the last_day function

eg select last_day(sysdate) from dual

to get the last date

or

select to_char(last_day(sysdate),'dd') from dual

to get the day portion only.


-Original Message-
Sent: 29 October 2001 15:55
To: Multiple recipients of list ORACLE-L



Try this:

select trunc(add_months(sysdate,1),'MM')-1
from dual;

Jared


On Monday 29 October 2001 00:00, Sinard Xing wrote:
> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>  lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?
>
>
>
>
> Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Last day of the month unix

[Jared . Still]

Works fine on Solais,

What is the output fom just 'cal 2 2001'?

Jared



   
 
"Sherman,  
 
Edward"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
  Subject: RE: Last day of the month unix   
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
10/29/01 09:50 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I was trying to form a similar solution but found it didn't work for Sept.
2001
on HP-UX. Your solution returns "29" on HP-UX Does it work on your UNIX
flavor?

-Original Message-
Sent: Monday, October 29, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


Well, you can do date functions in Unix.  The date function is date.  It's
not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following.  You'll want to test it because no to Unii
are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L



-- Sinard Xing <[EMAIL PROTECTED]>

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>  lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check
for

UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last
day';

--
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: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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


* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

Re: Data warehouse on Win2K

[Jared . Still]

Afraid  I'm not going to be much help.

I would like to know why you are moving from unix to Win2K however.

Jared




   
 
Johnson
 
Poovathummoott   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
il   cc:   
 
  
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
10/29/01 11:00 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi guys,

Our company is looking into the possiblity of moving
our data warehouse (around 500GB) from unix to Win2k.

Does anybody have any thoughts on what I can expect if
we go this way?

Johnson

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: Win XP

[Srini . Chavali]

I have seen ads for $199 for Home & $299 for Professional in the local
papers from Office Depot & Office Max.
Srini Chavali
Oracle DBA
Cummins Inc





"Koivu, Lisa" <[EMAIL PROTECTED]>@fatcity.com on 10/29/2001
01:20:29 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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





IS THIS REAL?  They charge this much for XP?

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

   -Original Message-
   From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
   Sent:   Monday, October 29, 2001 12:15 PM
   To: Multiple recipients of list ORACLE-L
   Subject:    Re:RE: Win XP

   Yesterday I was at my local OfficeMax where I found a copy of XP Home
   edition
   for $467.00US and Professional for $867.00US.  I had a good laugh on my
   way out
   too!!

   Dick Goulet

   Reply Separator
   Author: "Jesse; Rich" <[EMAIL PROTECTED]>
   Date:   10/29/2001 7:35 AM

   Not until MS comes out with at least 3 SPs.  It doesn't have Uncle
   Larry's
   blessing yet, does it?  (not that it means anything)

   I was in Radio Shack this weekend.  I went over to the big monitor that
   was
   connected to a box running the new and improved XP.  It had a large
   window
   on it that said "DEMO.exe has caused an error...and will terminate".  I
   laughed and laughed.  Then laughed some more and went home.

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

   -Original Message-
   Sent: Sunday, October 28, 2001 23:00
   To: Multiple recipients of list ORACLE-L

   Hi!

   Has anyone tried installing v8.1.7 or v9i on Windows XP???

   Cheers,

   Sujatha
   --
   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).
   --
   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).  You may
also send the HELP command for other information (like subscribing).

RE: extent deallocation question

[Steve Adams]

Hi Riyaj,

The checkpoint object call is used prior to a direct read of an object. DBW0 scans the 
cache once based on the obj#.
This was introduced in 8.0 as an optimization for parallel query. Previously each 
extent was checkpointed separately.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all

-Original Message-
Sent: Tuesday, 30 October 2001 3:10
To: Multiple recipients of list ORACLE-L



Steve
I thought the drop/truncate of the objects will do 'checkpoint object ' call 
and DBW in turn will do extent
based checkpointing. I am not even going to try argue with you :-) Could you please 
explain to us : What are the reasons
for 'checkpoint object call ' and  ' reuse block range calls ? What statement triggers 
them ?

Thanks in advance,
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com


"Steve Adams" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/29/01 05:00 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: extent deallocation question



Hi Jeremiah,

The cross instance call is a "reuse block range" call, not a "checkpoint object" call. 
Thus a separate scan of the cache
is needed for every extent. The reason why dirty blocks from dropped extents cannot be 
allowed to stay in cache is that
the blocks might immediately be allocated to another object.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Monday, 29 October 2001 13:55
To: Multiple recipients of list ORACLE-L


Thanks for the reply.  This is the first time I have heard of an
object-level checkpoint.

I still don't understand a couple things about this.  If the wait is
for checkpointing of the blocks composing the deallocated extents, why
does a 2Gb segment with 10 extents drop so much faster than a 2Gb
segment with 20,000 extents?  Does the session performing the DDL
require the object checkpoint to complete for every extent
deallocated, before the DDL proceeds?

Why should such a checkpoint be necessary?  Why can't the blocks just
go on the LRUW list like all the other dirty blocks?

If the speed of these object checkpoints is limited by the checkpoint
batch portion of the DBWR write batch, can they be sped up by
increasing the value of _db_block_checkpoint_batch to a larger
proportion of the DBWR write batch (as ascertained from x$kvii)?

It seems like if they just put the blocks from deallocated extents on
the dirty list, then the checkpointing could be automatically made
more agressive through use of the db_block_max_dirty_target feature.
That way as soon as a lot of dirty blocks got put on the LRUW list,
the checkpoint portion of the write batch could be automatically
increased.

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

On Sun, 28 Oct 2001, [EMAIL PROTECTED] wrote:

> When you truncate or drop an object, all the extents/buffers
> associated with that object need to be flushed to the disk, meaning an
> object checkpoint has to take place. DBW recieves an object checkpoint
> call, from the client process. Client process then waits for the IPC
> message from the DBW process for the object checkpoint call completion.
> The wait event you see is that the client is waiting for this IPC message
> from DBW. Once DBW completes flushing all the buffers associated with the
> objects, DBW will send back an IPC message to the client.
> Interestingly, there is are two lists( main and auxcillary lists)
> in 8i buffer cache just for this object checkpoint call, which is supposed
> to improve the performance of these object checkpoint calls. If you have
> very large buffer cache, DBW can take long time to flush these buffers.
> If you truncate a table, then all the indexes associated with
> these tables (an their buffers) need to be checkpointed. Further, only
> fraction of writes are dedicated for these checkpoints and that could be
> another reason for longer waits.
>
> Jeremiah Wilton <[EMAIL PROTECTED]>
>
> Using dictionary-managed tablespaces, it can sometimes take a very
> long time to drop or truncate a segment with many tens of thousands of
> extents, because Oracle takes a long time to update UET$ and FET$.
>
> This can be a serious problem for some people because the session
> performing the DDL holds the ST enqueue for the duration of the extent
> deallocation.
>
> During these long extent deallocations, I observe the session
> performing DDL waiting on IPC with the database writer.  Can anyone
> tell me why these long extent allocations spend the vast majority of
> their time waiting on DBW0?  Does every block in UET$ and FET$ have to
> get written 

OT : from Win XP to RDRAM or SDRAM ?

[paquette stephane]

Let's say someone is buying a new pc Pentium 4, is the
cost of the RDRAM memory chip is worth the performance
compare to SDRAM ?

TIA

-Original Message-
Behalf Of Kimberly
Smith
Sent: 29 octobre, 2001 14:05
To: Multiple recipients of list ORACLE-L


Hum, you got ripped off.  I just put in a 512MB SDRAM
for $69 bring
me to a grand total of 780MB but that is at home.  At
work I actually
do have 512MB in my machine as well.  

-Original Message-
Sent: Monday, October 29, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L


Chuck,
 Have you checked the prices for ram lately? a 256
SDRAM is $26 and a 256
RAMBUS is around $108. These prices also depent on the
machine manufacture.
A 256 RAMBUS for my Dell is $899. My server is a
generic box running Linux
and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the
prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5
McDonald's BigMac menu
:-). It is nothing compared to the time you loose
waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only
dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster
than WinNT or Win2K
if you have 256 MB. We could not test the server side
yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows
XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

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

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

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

To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the nam

RE: Location of PLAN_TABLE

[Toepke, Kevin M]

We have it in a common area (a schema for such things) and our developers
are responsible for maintaining their own rows.
 
We do, however, have a tool that allows the developers to run explain plans
from within a browser that takes care of such things for them.
 
Kevin

-Original Message-
Sent: Monday, October 29, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


individual schema is the way to go, IMO.
 
Deletions? if you want to save access paths, used stored outlines. (if an
option)
Otherwise, why not do a an export?
 
just a thought

-Original Message-
Sent: Monday, October 29, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L



Rather a trivial question, but our DBA team is discussing how best 
to implement the location of the plan table.   My preference is 
is simply create is as SYS, public synonym, and grant privs on 
it to our developers.   I'm being outvoted by the others, who 
want to create it in each and every application schema, but still grant 
access to all developers with no synonyms, the thinking being, that 
it would help to minimize accidental deletions of execution plans 
and so forth.  

My belief is that's simply over-thinking this issue.   What do you 
do at your sites?  

Thanks. 

 
Jeffery D Thomas 
DBA 
Thomson Information Services 
Thomson multimedia Inc. 

Email: [EMAIL PROTECTED] 
DBA Quickplace: http://gkmqp.tce.com/tis_dba 

 
  

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: FAST MIGRATION OF DATA

[Richard Ji]

Assuming the same Oralce and OS version on both Unix boxes.  You can create
a standby on the new box.  Then activate it.  The down time will be the time
you need to move the online redo over and apply it.

Richard

>>> [EMAIL PROTECTED] 10/29/01 11:15AM >>>
Hi
I have one production database of 60gb .i want to migrate from existing unix 
box to new unix box with minimun downtime.Please suggest what will be good 
method for migration.I have oracle 8.1.7 on solaris 2.7.
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).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Network Appliance

[DENNIS WILLIAMS]

Charlie
We have used them for supplemental storage on our test/development system
(Compaq Tru64, Oracle 8.1.6). The limitation seems to be the NFS connection
(and we have a dedicated card and connection) is slower than your
"conventional" or "real" disks. For some tasks this isn't a problem, but it
is easy to start several large tasks that saturate the NFS connection. For
example, when I have to build several large indexes, I copy the underlying
tables to the "real" disk, and build the indexes one at a time. I won't deny
that I may be overreacting to some problems. Other than that, it seems to
work fine for our test/development system where it generally receives
sporadic and light use. I am told that it cost much less than conventional
disks. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, October 29, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L


Charlie,

   My company has been using Network Appliances for quite a while now.
Early on we had some problems where the net apps would just seem to go
away for a second or two, causing a "Resource Temporarily Unavailable"
error message.  This would usually crash one or more databases.  After
much complaining and convincing that this wasn't a database issue, the
network guys applied a patch to the Network Appliances and we haven't
seen the error since...

Alan Aschenbrenner
[EMAIL PROTECTED]
IHS Group
(303)-858-6394

-Original Message-
Sent: Monday, October 29, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L


I've been asked to review Power Point marketing presentation
and a "white paper" both publishd by Network Appliance. 

I'd like to hear off list from anyone who has had some hands on
experience with this technology.

TIA & HAND!

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Aschenbrenner, Alan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 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: RE: Win XP

[Mercadante, Thomas F]

Title: RE: RE: Win XP



Lisa,
 
Windows XP for home Upgrade is $99 for W98, SE or Me 
(just checked Amazon just now).
Looks 
like it requires 233Mhz Cpu, 128M Ram and 1.5Gig disk space.
 
Looks 
like my 2yr old machine need a memory upgrade!
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 
  1:20 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: RE: Win XP
  IS THIS REAL?  They charge this much 
  for XP?  
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 
  
-Original Message- From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:   Monday, October 29, 2001 12:15 PM To: Multiple recipients of list ORACLE-L Subject:    Re:RE: Win XP 
Yesterday I was at my local OfficeMax where I 
found a copy of XP Home edition for 
$467.00US and Professional for $867.00US.  I had a good laugh on my way 
out too!! 
Dick Goulet 
Reply 
Separator Author: 
"Jesse; Rich" <[EMAIL PROTECTED]> Date:   10/29/2001 7:35 AM 

Not until MS comes out with at least 3 SPs.  
It doesn't have Uncle Larry's blessing 
yet, does it?  (not that it means anything) 
I was in Radio Shack this weekend.  I went 
over to the big monitor that was connected to a box running the new and improved XP.  It had a 
large window on it that said "DEMO.exe 
has caused an error...and will terminate".  I laughed and laughed.  Then laughed some more and went 
home. 
Rich 
Jesse  
System/Database Administrator [EMAIL PROTECTED] 
Quad/Tech International, Sussex, WI USA 
-Original Message- Sent: Sunday, October 28, 2001 23:00 To: Multiple recipients of list ORACLE-L 
Hi! 
Has anyone tried installing v8.1.7 or v9i on 
Windows XP??? 
Cheers, 
Sujatha -- 
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). -- 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: Win XP

[Speaks, Chuck W.]

Thanks for the advice.  Unfortunately, I don't do the purchasing here at the
office.  Otherwise, I'd have 1 gig of ram.  I am very aware of the price of
RAM, however standard workstation policies are often restrictive.

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-Original Message-
Sent: Monday, October 29, 2001 13:20
To: Multiple recipients of list ORACLE-L


Chuck,
 Have you checked the prices for ram lately? a 256 SDRAM is $26 and a 256
RAMBUS is around $108. These prices also depent on the machine manufacture.
A 256 RAMBUS for my Dell is $899. My server is a generic box running Linux
and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5 McDonald's BigMac menu
:-). It is nothing compared to the time you loose waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

RE: Win XP

[Christopher Spence]

I don't know about servers and with oracle, but XP for my game/workstation
made a huge improvement, it is faster, some Win2000 bugs went away, more
throughput.

Although 8.1.7 seems to be running fine when I do it development, nothing
heavy.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 10:35 AM
To: Multiple recipients of list ORACLE-L


Not until MS comes out with at least 3 SPs.  It doesn't have Uncle Larry's
blessing yet, does it?  (not that it means anything)

I was in Radio Shack this weekend.  I went over to the big monitor that was
connected to a box running the new and improved XP.  It had a large window
on it that said "DEMO.exe has caused an error...and will terminate".  I
laughed and laughed.  Then laughed some more and went home.

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

-Original Message-
Sent: Sunday, October 28, 2001 23:00
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

Sujatha
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Win XP

[Christopher Spence]

Win200 is like two years old.  2 years is nothing.
Cars come out every 1 year.   
Most software has 6-12 month releases.

Granted it is more difficult for the OS.  I think it would be better if they
fixed bugs rather than replace it.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L

I have not seen win2K yet!

It's amazing how we get a new O/S version every year from Windows!

I think O/S should be only a stable plain simple O/S with nothing fancy and
all the fancy things should be third party applications by other companies
not the same company!

-Original Message-
Sent: Monday, October 29, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Win XP

[Jesse, Rich]

More realistic pricing ("street value"):

http://www.bestbuy.com/software/promo.asp?m=1023&Cat=1807&p=1807

But for my money:

http://www.linux.org :D


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

-Original Message-
Sent: Monday, October 29, 2001 12:20
To: Multiple recipients of list ORACLE-L


IS THIS REAL?  They charge this much for XP?  
Lisa Koivu 
Oracle Database Monkey 
-- 
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).

Re:

[Deepak Thapliyal]

can you be more specific. Is your question about data
modelling or creating databases?
--- Saravana Kumar
<[EMAIL PROTECTED]> wrote:
> Hi friends,
>Can anyone help me in giving me a
> checklist to design a database.
> 
> Thank U in advance
> 
> regards
> Saravana.
> 
> 


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: RE: Win XP

[Kimberly Smith]

Title: RE: RE: Win XP



Not 
here.  

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 
  10:20 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: RE: Win XP
  IS THIS REAL?  They charge this much 
  for XP?  
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 
  
-Original Message- From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:   Monday, October 29, 2001 12:15 PM To: Multiple recipients of list ORACLE-L Subject:    Re:RE: Win XP 
Yesterday I was at my local OfficeMax where I 
found a copy of XP Home edition for 
$467.00US and Professional for $867.00US.  I had a good laugh on my way 
out too!! 
Dick Goulet 
Reply 
Separator Author: 
"Jesse; Rich" <[EMAIL PROTECTED]> Date:   10/29/2001 7:35 AM 

Not until MS comes out with at least 3 SPs.  
It doesn't have Uncle Larry's blessing 
yet, does it?  (not that it means anything) 
I was in Radio Shack this weekend.  I went 
over to the big monitor that was connected to a box running the new and improved XP.  It had a 
large window on it that said "DEMO.exe 
has caused an error...and will terminate".  I laughed and laughed.  Then laughed some more and went 
home. 
Rich 
Jesse  
System/Database Administrator [EMAIL PROTECTED] 
Quad/Tech International, Sussex, WI USA 
-Original Message- Sent: Sunday, October 28, 2001 23:00 To: Multiple recipients of list ORACLE-L 
Hi! 
Has anyone tried installing v8.1.7 or v9i on 
Windows XP??? 
Cheers, 
Sujatha -- 
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). -- 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: Location of PLAN_TABLE

[Thomas Jeff]

Title: RE: Location of  PLAN_TABLE





Not that many developers really.   I would agree with the plan table per schema if we
had a larger number of developers, but we are talking maybe 5-10 per database at most, 
and many of them will be using a 3rd-party tool such as TOAD to perform their explains.


-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Location of PLAN_TABLE



>-Original Message- 
>From: Thomas Jeff [mailto:[EMAIL PROTECTED]] 
> 
>Rather a trivial question, but our DBA team is discussing how best 
>to implement the location of the plan table.   My preference is 
>is simply create is as SYS, public synonym, and grant privs on 
>it to our developers.   I'm being outvoted by the others, who 
>want to create it in each and every application schema, but still grant 
>access to all developers with no synonyms, the thinking being, that 
>it would help to minimize accidental deletions of execution plans 
>and so forth.  
>My belief is that's simply over-thinking this issue.   What do you 
>do at your sites?  
How many developers share the same database? I've always created a common plan_table under a DBA account (but not under SYS) with a public synonym and access to public. Then I recommend to developpers that they use set autotrace or else put their name in the explain id, and I truncate the plan table about once a week. I haven't heard any complaints that execution plans were lost.

Actually, most developers don't seem to care much about execution plans anyway. :-) 

RE: ITL, DELAYED BLOCK CLEANOUT

[Deepak Thapliyal]

is this page still available or has been moved. I got
an error trying to access the link

Thx
Deepak
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> The  document is a draft copy. There are few (not
> much tech)
> errors. So take that with a pinch of salt
> 
> 
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
> 
> -Original Message-
> Gopalakrishnan
> Sent: Monday, October 29, 2001 9:40 AM
> To: Multiple recipients of list ORACLE-L
> 
> Vladimir,
> 
> Have a look at
> http://www.geocities.com/kgkrish/transactions.html
> 
> This will solve most of your questions. If not Pls
> let me know.
> 
> Thanks
> 
> 
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
> + (91) 98451 78868
> 
> -Original Message-
> Barac - posao
> Sent: Monday, October 29, 2001 6:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> Just curious...
> 
> Could someone shed some light on
> 
> INTERESTED TRANSACTIONS LIST
> 
> and
> 
> DELAYED BLOCK CLEANOUT?
> 
> Thanks
> 


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Data warehouse on Win2K

[Johnson Poovathummoottil]

Hi guys,

Our company is looking into the possiblity of moving
our data warehouse (around 500GB) from unix to Win2k.

Does anybody have any thoughts on what I can expect if
we go this way?

Johnson

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Win XP

[Kimberly Smith]

Hum, you got ripped off.  I just put in a 512MB SDRAM for $69 bring
me to a grand total of 780MB but that is at home.  At work I actually
do have 512MB in my machine as well.  

-Original Message-
Sent: Monday, October 29, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L


Chuck,
 Have you checked the prices for ram lately? a 256 SDRAM is $26 and a 256
RAMBUS is around $108. These prices also depent on the machine manufacture.
A 256 RAMBUS for my Dell is $899. My server is a generic box running Linux
and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5 McDonald's BigMac menu
:-). It is nothing compared to the time you loose waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

Fat City Network 

RE: Win XP

[Christopher Spence]

Considering you can get 512Mb chips for $30 or so, everyone should.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 29, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L

Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Corruption in SYSTEM Tablespace

[Koivu, Lisa]

Title: RE: Corruption in SYSTEM Tablespace





Hi Jeremiah, 


Wish it was always that easy.  Last corruption I experienced, we could not chase down the reason for the corruption.  Oracle wanted so many trace files, dumps, etc. lots of info before they would even look at it.  End result, I fixed the problem but I had so much to do (read: tons of code to write) we had to just hope it wouldn't happen again.  We got lucky and for the duration of my employment, it didn't happen a second time.

Have you been able to determine the exact reason for corruption before?


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117




-Original Message-
From:   Jeremiah Wilton [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, October 29, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Corruption in SYSTEM Tablespace


On Mon, 29 Oct 2001, Gogala, Mladen wrote:


> Restore the last hot backup and do the database recovery.


Well that seems a little extreme.


Why not find out which objects contain corruptions first, and if the
corrupted areas actually contain data?  Why go through a
restore/recover without having all the information?


Use dba_extents to find out which objects the corrupted blocks belong
to.  If they are indexes, just rebuild them!  If they are
heap-organized segments (tables/clusters), then find out if there are
actually rows in the affected area, by selecting a range of rowids
using dbms_rowid.


Only if you find that the corruptions have damaged actual data do you
have to recover.  Even in that case, as long as you are using
archivelog mode, you can resotre and recover just the datafile(s)
containing the corruptions, and perform complete recovery of that
file(s) with the database in mount mode.


Finally, make sure you find out how the corruption happened.  The O/S
shouldn't just corrupt your database.  The SAs should identify the
root cause and rectify it.


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


> > -Original Message-
> > From: Rajesh Dayal [mailto:[EMAIL PROTECTED]]
> >
> > Fortunately this is there only in my TEST database. But I am
> > wondering, how to resolve if this happens in Production Database.
> >     I can't export Full database with zero errors. Although I can
> > export most of the schemas individually. Dbverify shows some 3 blocks
> > to be corrupted, that's too only in SYSTEM TS.
> > Any ideas would be appreciated.


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Location of PLAN_TABLE

[Jacques Kilchoer]

Title: RE: Location of  PLAN_TABLE





>-Original Message-
>From: Thomas Jeff [mailto:[EMAIL PROTECTED]]
>
>Rather a trivial question, but our DBA team is discussing how best 
>to implement the location of the plan table.   My preference is 
>is simply create is as SYS, public synonym, and grant privs on 
>it to our developers.   I'm being outvoted by the others, who 
>want to create it in each and every application schema, but still grant 
>access to all developers with no synonyms, the thinking being, that 
>it would help to minimize accidental deletions of execution plans 
>and so forth.  
>My belief is that's simply over-thinking this issue.   What do you 
>do at your sites?  


How many developers share the same database? I've always created a common plan_table under a DBA account (but not under SYS) with a public synonym and access to public. Then I recommend to developpers that they use set autotrace or else put their name in the explain id, and I truncate the plan table about once a week. I haven't heard any complaints that execution plans were lost.

Actually, most developers don't seem to care much about execution plans anyway. :-)

Re: FAST MIGRATION OF DATA

[ARUN K C]

Not an expert but from the question what u have asked I feel is install the 
oracle 817 on the new machine and make that machine the standby prior to the 
day you want to switch keepp applying the logs and the day u want to switch 
shut down the production and ship the ONLINE REDLOG FILES AND THE CONTROL 
FILE AND BRING THE STANDBY BY IN ACTUAL MOUNT MODE AND SAY RECOVER DATABASE.
ONCE IT SAYS MEDIA RECOVERY COMPLETE YOU CAN BRING THE DATABASE WITHOUT 
ACTIVATING THE DATABASE.



>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 08:15:21 -0800
>
>Hi
>I have one production database of 60gb .i want to migrate from existing 
>unix
>box to new unix box with minimun downtime.Please suggest what will be good
>method for migration.I have oracle 8.1.7 on solaris 2.7.
>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).


_
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: Oracle Browser 2

[David Wagoner]

Dick,

Can you elaborate a little on the instability of Oracle Discoverer 3000 with
Oracle 9i database?  I was planning to investigate Discoverer as an end-user
reporting/query tool sometime soon.  We have Oracle 8i and 9i databases.  I
just heard that Discoverer is an HTML-based data query tool for end-users.


TIA,


david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender at (919) 941-4645 and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Monday, October 29, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L

Oracle Browser 2/Oracle Discoverer 2000 is a VERY old piece of software that
does not interact well with any Oracle instance beyond 7.3.4.  We've got it,
it's a pain in the neck, and I would NOT recommend anyone else try to use
it,
except if your still running 7.x databases.  Your options are not very
great,
use Oracle 9iAS enterprise edition for the browser based version of Oracle
Discoverer 3000 (not a very stable product from our experience [9iAS version
9.0.1 on HP-UX])  Or go to the third party market  We are with a product
called
Brio.

Dick Goulet

Reply Separator
Author: "Michael" <[EMAIL PROTECTED]>
Date:   10/28/2001 4:05 AM

Hi all,

Doesn't anybody out there know what Oracle Browser 2 is, and where I
might be able to download a copy ?

Thanks for your time.

Michael.





Message



Hi
all,
 
    Doesn't anybody out there know what Oracle Browser 2 is, and where I
might be able to download a copy ?
 
    Thanks for your time.
 
Michael.
 

--
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: David Wagoner
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Last day of the month unix

[Sherman, Edward]

cal 9 2001 | grep '[0-9]$' | awk '{print $NF}' | tail -1

(or whatever) ;-)

-Original Message-
Sent: Monday, October 29, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L


I was trying to form a similar solution but found it didn't work for Sept.
2001
on HP-UX. Your solution returns "29" on HP-UX Does it work on your UNIX
flavor?

-Original Message-
Sent: Monday, October 29, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


Well, you can do date functions in Unix.  The date function is date.  It's
not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following.  You'll want to test it because no to Unii
are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L



-- Sinard Xing <[EMAIL PROTECTED]>

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>   lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check
for

UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';

--
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: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary table

[Aponte, Tony]

Title: RE: Temporary table






Harvinder, I'm a little confused.  The requirements you describe (up to the last sentence) are a classic example of what Global Temporary Tables are suited for.  The last sentence puzzles me since you would only be creating one GTT before deploying the code, not each time the code runs.  Sessions just create their own private data segments upon the first Insert operation.  These segments are visible only to that session (regardless of the schema used to connect to the database) just like if each one had it's own distinctively-named table.  If you could I'd like to see a follow-up post with more information that shed light on your thought process.

Tony Aponte


-Original Message-

From: Harvinder Singh [mailto:[EMAIL PROTECTED]]

Sent: Thursday, October 25, 2001 6:35 PM

To: Multiple recipients of list ORACLE-L

Subject: Temporary table



Hi,


In our application we need to create temporary table for life of a session

and drop it after the session.

we need this table to be session specific ...2 sessions connected as same

schema user should be able to create

table with the same name..

for example user1. connected as scott  create table with name tab1..then

user2 connected as scott should also be

able to create table with name tab1...and we want table tab1 to be dropped

as soon as user1 and user2 will discconnect

We need to populate this temporary table in particular session and use it to

join with other tables and then drop after the session.

How can we implement this...

global temporary table does not allow to be created twice in 1 schema..they

r schema specific...


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

RE: New Oracle Install and Old Data Files

[Regina Harter]

Yes, you are absolutely right, we have everything except the system 
tablespace.  The two disks that crashed contained all the program files, 
including unix and oracle,  and the system tablespace.  The disks 
containing all the other datafiles were untouched.  However, I did forward 
Randy's solution to our DBA, even though I have my own doubts about it 
being sufficient.

At 08:45 AM 10/29/01 -0800, you wrote:
>Yes, but she said that she everything EXCEPT the system tablespaces.  If
>this is true then they're SOL, except for Data Unloader.
>
>
> 
>
> Randy 
 >
> Kirkpatrick  To: Multiple recipients of 
> list ORACLE-L
>  
 >
> @usa.net>cc: 
 >
> Sent by: rootSubject: RE: New Oracle 
> Install and Old Data
>  Files 
 >
> 
>
> 10/29/2001 
 >
> 10:50 
> AM
> Please 
 >
> respond 
> to
> ORACLE-L 
 >
> 
>
> 
>
>
>
>
>
>The datafiles contain the tablespaces which contain the data for the
>tables,
>indexes, etc. If she has all the datafiles, then she'll have access to all
>the data. I haven't tried it, but this should work for the system
>tablespace
>as well.
>
>Randy Kirkpatrick
>
>-Original Message-
>[EMAIL PROTECTED]
>Sent: Monday, October 29, 2001 7:00 AM
>To: Multiple recipients of list ORACLE-L
>
>
>But does she just want the old tablespaces or does she want the tables and
>indexes that were in those tablespaces?  I don't think that simply
>recovering the tablespaces will recover the tablespace contents, though it
>is the way to start.
>
>Doesn't Oracle have a recovery tool -- pay big bucks, they come in and
>recover your database and then remove the tool -- that will do this?
>
>
>
>
> Randy
> Kirkpatrick  To: Multiple recipients of
>list
>ORACLE-L
> 
> @usa.net>cc:
> Sent by: rootSubject: RE: New Oracle
>Install
>and Old Data
>  Files
>
> 10/26/2001
> 09:00 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Regina,
>
>Yes there is - but you probably don't want to do it yourself if you're not
>a
>DBA ...
>
>do a backup control file to trace:
>
>alter database  backup controlfile to trace;
>
>shut down the database and modify the sql in the file you created so it
>contains the information for the tablespaces you need.
>
>use the sql file to start up the database
>
>hopefully everything starts ok. Can't guarantee what happens to integrity,
>etc. if you don't have all the tablespaces.
>
>
>Randy Kirkpatrick
>
>
>
>-Original Message-
>Harter
>Sent: Friday, October 26, 2001 5:10 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Okay People,
>
>I am not the DBA and don't have all the details but this is our situation
>the way it was explained to me:
>
>We had a server crash to the point where Unix and Oracle had to be
>reinstalled, however the disks containing our data tablespaces (that is,
>everything but the system tablespaces) are still good, and apparently for
>several reasons, we have not had a good backup for at least a week.  Is
>there anyway to get a new Oracle install to recognize old tablespaces?
>
>TIA, Regina
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Regina Harter
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Randy Kirkpatrick
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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 Cit

RE: Win XP

[Jon Baker]

Title: RE: Win XP





yea, sun should not develop solstice or java.  ;-)





-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Win XP



I have not seen win2K yet!


It's amazing how we get a new O/S version every year from Windows!


I think O/S should be only a stable plain simple O/S with nothing fancy and
all the fancy things should be third party applications by other companies
not the same company!


-Original Message-
Sent: Monday, October 29, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L



Hi!


Has anyone tried installing v8.1.7 or v9i on Windows XP???


Cheers,


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Location of PLAN_TABLE

[Rao, Maheswara]

Title: Location of PLAN_TABLE



We 
keep plan table in each of the developers schema and thus there is no problem of 
deletions and maintenance of this table.  Also, this is not such an 
important table for DBA maintenance.
 
Rao

  -Original Message-From: Thomas Jeff 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 12:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Location of PLAN_TABLE
  Rather a trivial question, but our DBA team 
  is discussing how best to implement 
  the location of the plan table.   My preference is is simply create is as SYS, public synonym, and 
  grant privs on it to our 
  developers.   I'm being outvoted by the others, who want to create it in each and every application 
  schema, but still grant access to 
  all developers with no synonyms, the thinking being, that it would help to minimize accidental deletions of 
  execution plans and so forth.  
  
  My belief is that's simply over-thinking 
  this issue.   What do you do at your sites?  
  Thanks. 
   Jeffery D Thomas DBA Thomson Information 
  Services Thomson multimedia 
  Inc. 
  Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba  
    

RE: Win XP

[Ron Rogers]

Chuck,
 Have you checked the prices for ram lately? a 256 SDRAM is $26 and a 256 RAMBUS is 
around $108. These prices also depent on the machine manufacture. A 256 RAMBUS for my 
Dell is $899. My server is a generic box running Linux and the 256 RAMBUS chip is $108.
Contact me offline if you need site info for the prices.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 10/29/01 11:10AM >>>
In Hungary you get it for $25. It's the price of 4-5 McDonald's BigMac menu
:-). It is nothing compared to the time you loose waiting and watching the
hour glass for a simple process to finish it's job.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Who has 256mb on their clients???  Man...One can only dream

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com 


-Original Message-
Sent: Monday, October 29, 2001 04:55
To: Multiple recipients of list ORACLE-L


The client side seems to work for us. And XP is faster than WinNT or Win2K
if you have 256 MB. We could not test the server side yet.

Tamas Szecsy

-Original Message-
Sent: Monday, October 29, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
  INET: [EMAIL PROTECTED] 

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

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

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

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

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

RE: RE: Win XP

[Koivu, Lisa]

Title: RE: RE: Win XP





IS THIS REAL?  They charge this much for XP?  


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, October 29, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re:RE: Win XP


Yesterday I was at my local OfficeMax where I found a copy of XP Home edition
for $467.00US and Professional for $867.00US.  I had a good laugh on my way out
too!!


Dick Goulet


Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   10/29/2001 7:35 AM



Not until MS comes out with at least 3 SPs.  It doesn't have Uncle Larry's
blessing yet, does it?  (not that it means anything)


I was in Radio Shack this weekend.  I went over to the big monitor that was
connected to a box running the new and improved XP.  It had a large window
on it that said "DEMO.exe has caused an error...and will terminate".  I
laughed and laughed.  Then laughed some more and went home.


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


-Original Message-
Sent: Sunday, October 28, 2001 23:00
To: Multiple recipients of list ORACLE-L



Hi!


Has anyone tried installing v8.1.7 or v9i on Windows XP???


Cheers,


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

Spam - Re: Oracle Training from InterTrain

[Jared . Still]

Here's the email I received this morning from Cindy Conners in regards
to my inquiry Friday when she spammed many list members.

It appears that this wasn't actually her fault.  I know lot's of cynics
will
disagree, but that's tough.

I must say I'm a little dissapointed that so many folks responded to
her with profanity.  I'm always dismayed at the number of people
that are unable to express themselves without resorting to vulgar
speech.  Get a dictionary and a thesaurus and learn to use them.

Jared


- Forwarded by Jared Still/Radisys_Corporation/US on 10/29/01 09:28 AM
-
   
  
"Cindy Connors"
  

  
train.net>cc:  
  
  Subject: Re: Oracle Training from 
InterTrain   
10/29/01 10:35 
  
AM 
  
   
  
   
  




I sincerely apologize. This list was forwarded to me internally without any
indication of its source. I assumed that I was to send out one of our
standard emails. This is my fault for not checking it out before I sent my
email.

I appreciate your response to explain to me my error. Obviously, many
people
objected. There are 137 messages in my inbox this morning that emails to me
were rejected by our server that because they contained profanity. You have
a tough crowd.

I was never my intention to harm anyone. As list manager, can you suggest
the best way for me to apologize to everyone and assure them it will not
happen again.

Cindy Connors

-Original Message-
To: Cindy Connors <[EMAIL PROTECTED]>

>
>
>Cindy,
>
>Spamming addresses harvested from mailing lists is not considered good
>netiquette.
>
>Personally, I don't care.  A large number of folks that subscribe to this
>list do care
>however, so I felt that as owner of the list I should say something.
>
>Please don't do it again.
>
>Thank You
>
>Jared Still
>Owner of [EMAIL PROTECTED]




-- 
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: Win XP

[DENNIS WILLIAMS]

Waleed - You're missing the point here. Let's start with the fact that Bill
Gates is the richest man on the planet, with a strong desire to retain that
position. Then we work backward from there to see how we can keep those
licensing fees rolling in.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, October 29, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


I have not seen win2K yet!

It's amazing how we get a new O/S version every year from Windows!

I think O/S should be only a stable plain simple O/S with nothing fancy and
all the fancy things should be third party applications by other companies
not the same company!

-Original Message-
Sent: Monday, October 29, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
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: Corrupted sys.order_object_by_dependency

[Koivu, Lisa]

Title: RE: Corrupted sys.order_object_by_dependency





Hi Walter, 


I believe this is a bug.  Check Metalink.  I've seen this on 8.1.6 on HP/UX 11.0 before. It also ensured that DBMS_UTILITY.COMPILE_SCHEMA didn't work.  It wouldn't suprise me if the bug was not fixed in 8.1.7.  Our solution was to run a brute-force compilation script that didn't use the dependencies table.  You have to run it 3-4 times, but in the end it took less time than waiting for DBMS_UTILITY when it did work.

What's it like working for Ed's Army?


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Kirsch, Walter J (Northrop Grumman) [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, October 29, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Subject:    Corrupted sys.order_object_by_dependency


> HP-UX 11.0 (32bit); Oracle 8.1.7.0.0
> 
> I'm swapping between a pair of tables by renaming them.  After a few
> swaps, the order_objects_by_dependency view goes sour as evident by my
> "recompile_invalid_objects" script, whose guts is as follows:
> 
> 
> 
> select "alter..."
> from   
>    sys.order_object_by_dependency dep
> ,  sys.user_objects   obj
> where  obj.object_id = dep.object_id
> AND    status = 'INVALID'
> order by dep.dlevel desc
> ;
> 
> 
>    sys.order_object_by_dependency dep
>  *
> ERROR at line 4:
> ORA-01436: CONNECT BY loop in user data
> 
> Can anyone suggest a way of fixing the underlying data without recreating
> the database?  Thanks.
> 
> 
> To keep your marriage brimming, 
> with love in the loving cup, 
> whenever you're wrong, admit it; 
> whenever you're right, shut up. 
> -- Ogden Nash
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsch, Walter J (Northrop Grumman)
  INET: [EMAIL PROTECTED]


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

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

Re:RE: Network Appliance

[dgoulet]

Alan,

One of the reasons that we have not started using NETAPP with our Oracle
DB's is that you should have a dedicated network connection between the server
and the appliance.  This can take the form of a network cable between the
network card and the appliance or a dedicated VLAN.  If you don't have that,
then your just begging for trouble.

Dick Goulet

Reply Separator
Author: "Aschenbrenner; Alan" <[EMAIL PROTECTED]>
Date:   10/29/2001 9:00 AM

Charlie,

   My company has been using Network Appliances for quite a while now.
Early on we had some problems where the net apps would just seem to go
away for a second or two, causing a "Resource Temporarily Unavailable"
error message.  This would usually crash one or more databases.  After
much complaining and convincing that this wasn't a database issue, the
network guys applied a patch to the Network Appliances and we haven't
seen the error since...

Alan Aschenbrenner
[EMAIL PROTECTED]
IHS Group
(303)-858-6394

-Original Message-
Sent: Monday, October 29, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L


I've been asked to review Power Point marketing presentation
and a "white paper" both publishd by Network Appliance. 

I'd like to hear off list from anyone who has had some hands on
experience with this technology.

TIA & HAND!

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Aschenbrenner, Alan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ITL, DELAYED BLOCK CLEANOUT

[K Gopalakrishnan]

Hi,

 

The  document is a draft
copy. There are few (not much tech) 

errors. So take that with a pinch of salt

 

 

Best Regards,

K Gopalakrishnan

Bangalore, INDIA

+ (91) 98451 78868

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of K
Gopalakrishnan
Sent: Monday, October 29, 2001
9:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: ITL, DELAYED BLOCK
CLEANOUT

 

Vladimir,

 

Have a look at 

http://www.geocities.com/kgkrish/transactions.html

 

This will solve most of your questions. If not Pls
let me know.

 

Thanks

 

 

Best Regards,

K
Gopalakrishnan

Bangalore,
INDIA

+ (91) 98451
78868

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir
Barac - posao
Sent: Monday, October 29, 2001
6:25 AM
To: Multiple recipients of list
ORACLE-L
Subject: ITL, DELAYED BLOCK
CLEANOUT

 

Just
curious... 

Could someone shed some light on 

INTERESTED TRANSACTIONS LIST 

and 

DELAYED BLOCK CLEANOUT?

Thanks

RE: Location of PLAN_TABLE

[Mohan, Ross]

Title: Location of PLAN_TABLE



individual schema is the way to go, IMO.
 
Deletions? if you want to save access paths, used stored outlines. (if an 
option)
Otherwise, why not do a an export?
 
just a 
thought

  -Original Message-From: Thomas Jeff 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 12:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Location of PLAN_TABLE
  Rather a trivial question, but our DBA team 
  is discussing how best to implement 
  the location of the plan table.   My preference is is simply create is as SYS, public synonym, and 
  grant privs on it to our 
  developers.   I'm being outvoted by the others, who want to create it in each and every application 
  schema, but still grant access to 
  all developers with no synonyms, the thinking being, that it would help to minimize accidental deletions of 
  execution plans and so forth.  
  
  My belief is that's simply over-thinking 
  this issue.   What do you do at your sites?  
  Thanks. 
   Jeffery D Thomas DBA Thomson Information 
  Services Thomson multimedia 
  Inc. 
  Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba 
     

RE: Base table of materialized views

[Aponte, Tony]

Title: RE: Base table of materialized views






I have a few questions that you can answer with by post of the snapshot creation command.  Also, the refresh type and any other relevant info. (i.e. snapshot log, etc.) 

Tony Aponte


-Original Message-

From: [EMAIL PROTECTED]

[mailto:[EMAIL PROTECTED]]

Sent: Friday, October 26, 2001 9:00 AM

To: Multiple recipients of list ORACLE-L

Subject: Base table of materialized views




I have posed this question to Oracle support and have yet to receive an

understandable answer, so I thought it best to ask the experts.


I used to run under 8.1.5 with compatibility set to 8.0.  Whenever I

created a snapshot I had an underlying table snap$_ that was the physical

table residing in Oracle.  This was great because it allowed me to alter

the data with DML when I needed to (believe me, I have my reasons!).


After upgrading to 8.1.6 I set compatibility to 8.1 so that I could take

advantage of the HTML generation from SQL and probably some other features

that I can't remember immediately.   There is no longer a SNAP$_ table, but

the materialized view is actually a table with the same name.  Even though

the object is listed as a table in the data dictionary, when I try to

perform DML I get an error stating that I can't update this view.


Oracle has taken away a feature that I have come to depend on.  Does anyone

know of a workaround for this problem?


Any insights would be appreciated.


---

Sherrie Kubis

Southwest Florida Water Management District

2379 Broad Street

Brooksville FL 34604-6899


Phone:  (352) 796-7211, Ext. 4033

Fax: (352) 754-6776

Email:  Mailto:[EMAIL PROTECTED]


-- 

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: Corruption in SYSTEM Tablespace

[Jeremiah Wilton]

On Mon, 29 Oct 2001, Gogala, Mladen wrote:

> Restore the last hot backup and do the database recovery.

Well that seems a little extreme.

Why not find out which objects contain corruptions first, and if the
corrupted areas actually contain data?  Why go through a
restore/recover without having all the information?

Use dba_extents to find out which objects the corrupted blocks belong
to.  If they are indexes, just rebuild them!  If they are
heap-organized segments (tables/clusters), then find out if there are
actually rows in the affected area, by selecting a range of rowids
using dbms_rowid.

Only if you find that the corruptions have damaged actual data do you
have to recover.  Even in that case, as long as you are using
archivelog mode, you can resotre and recover just the datafile(s)
containing the corruptions, and perform complete recovery of that
file(s) with the database in mount mode.

Finally, make sure you find out how the corruption happened.  The O/S
shouldn't just corrupt your database.  The SAs should identify the
root cause and rectify it.

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

> > -Original Message-
> > From: Rajesh Dayal [mailto:[EMAIL PROTECTED]]
> >
> > Fortunately this is there only in my TEST database. But I am
> > wondering, how to resolve if this happens in Production Database.
> > I can't export Full database with zero errors. Although I can
> > export most of the schemas individually. Dbverify shows some 3 blocks
> > to be corrupted, that's too only in SYSTEM TS.
> > Any ideas would be appreciated.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Win XP

[Khedr, Waleed]

I have not seen win2K yet!

It's amazing how we get a new O/S version every year from Windows!

I think O/S should be only a stable plain simple O/S with nothing fancy and
all the fancy things should be third party applications by other companies
not the same company!

-Original Message-
Sent: Monday, October 29, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L


Hi!

Has anyone tried installing v8.1.7 or v9i on Windows XP???

Cheers,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Replacing a Disk on WinNT

[George Hofilena]

Thta's just what I did, skip #3.  I realized it wasn't necessary as I had to
do a full backup on a Disk C (backup disk) anyway.
Everything worked out fine.

Thanks,

George

-Original Message-
Sent: Monday, October 29, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L


I don't see any reason why George's approach shouldn't work.  In fact, he
can skip step 3 and just copy the files to A from their mirrors.  If it
doesn't work, you've always got the original disk A to put back in.


 

Steven

Lembark  To: Multiple recipients of list
ORACLE-L  


@wrkhors.com>cc:

Sent by: rootSubject: Re: Replacing a Disk
on WinNT
 

 

10/27/2001

04:20 PM

Please

respond to

ORACLE-L

 

 







-- George Hofilena <[EMAIL PROTECTED]>

> Hi,
>
> We are replacing once of the disks where a mirrored control file and redo
> logs reside, nothing else, with a higher disk capacity.
> I can either use the recommended Oracle approach to moving/relocating
> control
> and redo log files but for my purpose it would seem laborious compared to
> what I am thinking is the quickest.  But I need to know whether you agree
> to this.
>
> This is what I intend to do:
>
> 1. Shutdown the database
> 2. Make a full backup.
> 3. Copy the control and redo log files on Disk A to Disk B
> 4. Replace Disk A (Disk A wiil have the same drive letter/designation)
> 5. Copy control and redo log files back from Disk B
> 6. Startup the database.
>
> Is this safe?

No. Only for the reason that you don't have a full backup
of everything on stable, offline media. On the other hand,
you do have a working backup of the media on the disk that
is being removed. Why just just up the scsi address, write
lock it and use the drive as its own backup? Basically you'd
add the new drive in where the old one was in the chain,
up the address of the old one -- total time 15 sec if you
don't drop the jumpers too many times -- and copy the contents
of the old drive to the new one.

--
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: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: George Hofilena
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Java in the database

[Grabowy, Chris]

Duoh!!  (sitting back in my lazyboy, sipping on some soda, nibbling 
on popcorn, turning to Jared and Chris, waiting pensively for there return 
volley)

  -Original Message-From: Marin Dimitrov 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Java in the database
   
  
- Original Message - 
From: 
Christopher 
Spence 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, October 29, 2001 
16:05
Subject: RE: Java in the database

OrionServer runs on almost any 
platform as it is pure java.  So 
not sure I buy the 'supports more os's' 
comment.
 
Orion has been 
tested on the following platforms: 


  
Windows 95/98/NT/2000 

Sparc Solaris 

Linux 

FreeBSD 4.x 

AS/400 

HP-UX (with classic vm) 
 
 
If you take a look at the 
BEA platform certification page (http://edocs.bea.com/wls/platforms/index.html) 
u'll see something more than the "Note that we can not 
guarantee that all configurations or jvm's will work on the above OSes, it's 
merely an indication on what platforms Orion has been succesfully used. 
" that is found in the Orion docs
 
 
Keep in mind Orion 
server was the first J2EE commercial product, 
 
It's J2EE based, but not J2EE certified. 

 
I couldn't find any indication that Orion is certified in 
the FAQ/features page, and both BEA and Flashline.com claim Orion is 
not certified
 
As for the 5x better performance  - there is a 
similar compariosn from BEA that claims WebLogic to be 54% fatser than 
OAS 9i (http://www.bea.com/products/weblogic/server/performance_oracle.shtml)
 
 
 Marin
 
"...what you brought 
from your past, is of no use in your present. When you must choose a new 
path, do not bring old experiences with you. Those who strike out 
afresh, but who attempt to retain a little of the old life, end up torn 
apart by their own memories. "





   
  
   
   

RE: Last day of the month unix

[Sherman, Edward]

I was trying to form a similar solution but found it didn't work for Sept.
2001
on HP-UX. Your solution returns "29" on HP-UX Does it work on your UNIX
flavor?

-Original Message-
Sent: Monday, October 29, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


Well, you can do date functions in Unix.  The date function is date.  It's
not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following.  You'll want to test it because no to Unii
are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L



-- Sinard Xing <[EMAIL PROTECTED]>

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>   lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check
for

UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';

--
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: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

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

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

BLOB question ???

[Leslie Lu]

Hi all,

I have a table that has BLOB data type, and there is a
SP to select from it.  The length out parameter
returns the length of the contents in the BLOB.  Now
the SP returns the length for all the content even if
the trailing character is a space, the developer wants
to return length-1 if the ending character is a space.
 Can anyone let me know how to do that? (815 on Sun56)
Thank you so much!  

Here is the SP:

CREATE OR REPLACE PROCEDURE test1
(in_serv_agree_id   in number,
amount   in number,
offset   in number,
length   outnumber,
text outvarchar2,
RC1 IN OUT GLOBALPkg.RCT1
) as
   v_blob blob;
   buffer raw(32000);
   amount_read binary_integer;
   StoO_error  integer;
   StoO_errmsg varchar2(255);

BEGIN
amount_read := amount;
select service_agree_text
  into v_blob
  from ref_service_agreement
 where service_agree_id = in_serv_agree_id;

length := dbms_lob.getlength(v_blob);
dbms_lob.read(v_blob,amount_read,offset,buffer);

text:=utl_raw.cast_to_varchar2(buffer);
OPEN RC1 FOR
 SELECT text 
 FROM dual; 
exception
when others then
   StoO_error := SQLCODE;
   StoO_errmsg := SQLERRM;

raise_application_error(-20599,substr(StoO_errmsg,1,100));

 end test1;

Table create syntax:

CREATE TABLE Ref_Service_Agreement (
service_agree_id NUMBER(10) NOT NULL,
service_agree_version VARCHAR2(20) NOT NULL,
service_agree_start_date DATE NOT NULL,
service_agree_end_date DATE NULL,
service_agree_desc   VARCHAR2(255) NOT NULL,
service_agree_text   BLOB NOT NULL
)
TABLESPACE LD_DATA
lob(service_agree_text) store as
service_agree_text_data_seg
( tablespace LD_DATA
  storage(initial 1M next 1M pctincrease 0 )
  chunk 8192
  pctversion 0
  enable storage in row
  index service_agree_text_idx_seg
) 

Global package syntax:
CREATE or REPLACE PACKAGE GLOBALpkg AS
TYPE RCT1 IS REF CURSOR;
END;
/


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

Corrupted sys.order_object_by_dependency

[Kirsch, Walter J (Northrop Grumman)]

> HP-UX 11.0 (32bit); Oracle 8.1.7.0.0
> 
> I'm swapping between a pair of tables by renaming them.  After a few
> swaps, the order_objects_by_dependency view goes sour as evident by my
> "recompile_invalid_objects" script, whose guts is as follows:
> 
> 
> 
> select "alter..."
> from   
>sys.order_object_by_dependency dep
> ,  sys.user_objects   obj
> where  obj.object_id = dep.object_id
> ANDstatus = 'INVALID'
> order by dep.dlevel desc
> ;
> 
> 
>sys.order_object_by_dependency dep
>  *
> ERROR at line 4:
> ORA-01436: CONNECT BY loop in user data
> 
> Can anyone suggest a way of fixing the underlying data without recreating
> the database?  Thanks.
> 
> 
> To keep your marriage brimming, 
> with love in the loving cup, 
> whenever you're wrong, admit it; 
> whenever you're right, shut up. 
> -- Ogden Nash
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsch, Walter J (Northrop Grumman)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Network Appliance

[Kathy Duret]

So far I like it.  We are trying it our on our Datamart Database.  Their snapshots for 
backups are quite fast as is recover from it.  Adding storage on the fly is really 
easy.  The performance is as promised as well and it costs much less.  But we have 
just started using this product.  

I asked this question about a month ago and if you check the archives you will get 
some other opinions.

Kathy

-Original Message-
Sent: Monday, October 29, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L


I've been asked to review Power Point marketing presentation
and a "white paper" both publishd by Network Appliance. 

I'd like to hear off list from anyone who has had some hands on
experience with this technology.

TIA & HAND!

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

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

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ITL, DELAYED BLOCK CLEANOUT

[K Gopalakrishnan]

Vladimir,

 

Have a
look at 

http://www.geocities.com/kgkrish/transactions.html

 

This will
solve most of your questions. If not Pls let me know.

 

Thanks

 

 

Best Regards,

K Gopalakrishnan

Bangalore, INDIA

+ (91) 98451 78868

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir
Barac - posao
Sent: Monday, October 29, 2001
6:25 AM
To: Multiple recipients of list
ORACLE-L
Subject: ITL, DELAYED BLOCK
CLEANOUT

 

Just
curious... 

Could someone shed some light on 

INTERESTED TRANSACTIONS LIST 

and 

DELAYED BLOCK CLEANOUT?

Thanks

Location of PLAN_TABLE

[Thomas Jeff]

Title: Location of  PLAN_TABLE





Rather a trivial question, but our DBA team is discussing how best
to implement the location of the plan table.   My preference is
is simply create is as SYS, public synonym, and grant privs on
it to our developers.   I'm being outvoted by the others, who 
want to create it in each and every application schema, but still grant
access to all developers with no synonyms, the thinking being, that
it would help to minimize accidental deletions of execution plans 
and so forth.  


My belief is that's simply over-thinking this issue.   What do you
do at your sites?  


Thanks.



Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.


Email: [EMAIL PROTECTED]
DBA Quickplace: http://gkmqp.tce.com/tis_dba

 

FAST MIGRATION OF DATA

[Seema Singh]

Hi
I have one production database of 60gb .i want to migrate from existing unix 
box to new unix box with minimun downtime.Please suggest what will be good 
method for migration.I have oracle 8.1.7 on solaris 2.7.
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: Last day of the month unix

[Nicoll, Iain (Calanais)]

Not sure if you want this from sql or unix

but there is the last_day function

eg select last_day(sysdate) from dual 

to get the last date

or 

select to_char(last_day(sysdate),'dd') from dual

to get the day portion only.


-Original Message-
Sent: 29 October 2001 15:55
To: Multiple recipients of list ORACLE-L



Try this:

select trunc(add_months(sysdate,1),'MM')-1 
from dual;

Jared


On Monday 29 October 2001 00:00, Sinard Xing wrote:
> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>   lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?
>
>
>
>
> Sinardy
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: extent deallocation question

[Riyaj_Shamsudeen]

Steve
        I thought the drop/truncate of the objects will do 'checkpoint object ' call and DBW in turn will do extent based checkpointing. I am not even going to try argue with you :-) Could you please explain to us : What are the reasons for 'checkpoint object call ' and  ' reuse block range calls ? What statement triggers them ?

Thanks in advance,
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






"Steve Adams" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/29/01 05:00 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: extent deallocation question


Hi Jeremiah,

The cross instance call is a "reuse block range" call, not a "checkpoint object" call. Thus a separate scan of the cache
is needed for every extent. The reason why dirty blocks from dropped extents cannot be allowed to stay in cache is that
the blocks might immediately be allocated to another object.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/              -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/       -  For all


-Original Message-
Sent: Monday, 29 October 2001 13:55
To: Multiple recipients of list ORACLE-L


Thanks for the reply.  This is the first time I have heard of an
object-level checkpoint.

I still don't understand a couple things about this.  If the wait is
for checkpointing of the blocks composing the deallocated extents, why
does a 2Gb segment with 10 extents drop so much faster than a 2Gb
segment with 20,000 extents?  Does the session performing the DDL
require the object checkpoint to complete for every extent
deallocated, before the DDL proceeds?

Why should such a checkpoint be necessary?  Why can't the blocks just
go on the LRUW list like all the other dirty blocks?

If the speed of these object checkpoints is limited by the checkpoint
batch portion of the DBWR write batch, can they be sped up by
increasing the value of _db_block_checkpoint_batch to a larger
proportion of the DBWR write batch (as ascertained from x$kvii)?

It seems like if they just put the blocks from deallocated extents on
the dirty list, then the checkpointing could be automatically made
more agressive through use of the db_block_max_dirty_target feature.
That way as soon as a lot of dirty blocks got put on the LRUW list,
the checkpoint portion of the write batch could be automatically
increased.

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

On Sun, 28 Oct 2001, [EMAIL PROTECTED] wrote:

>         When you truncate or drop an object, all the extents/buffers
> associated with that object need to be flushed to the disk, meaning an
> object checkpoint has to take place. DBW recieves an object checkpoint
> call, from the client process. Client process then waits for the IPC
> message from the DBW process for the object checkpoint call completion.
> The wait event you see is that the client is waiting for this IPC message
> from DBW. Once DBW completes flushing all the buffers associated with the
> objects, DBW will send back an IPC message to the client.
>         Interestingly, there is are two lists( main and auxcillary lists)
> in 8i buffer cache just for this object checkpoint call, which is supposed
> to improve the performance of these object checkpoint calls. If you have
> very large buffer cache, DBW can take long time to flush these buffers.
>         If you truncate a table, then all the indexes associated with
> these tables (an their buffers) need to be checkpointed. Further, only
> fraction of writes are dedicated for these checkpoints and that could be
> another reason for longer waits.
>
> Jeremiah Wilton <[EMAIL PROTECTED]>
>
> Using dictionary-managed tablespaces, it can sometimes take a very
> long time to drop or truncate a segment with many tens of thousands of
> extents, because Oracle takes a long time to update UET$ and FET$.
>
> This can be a serious problem for some people because the session
> performing the DDL holds the ST enqueue for the duration of the extent
> deallocation.
>
> During these long extent deallocations, I observe the session
> performing DDL waiting on IPC with the database writer.  Can anyone
> tell me why these long extent allocations spend the vast majority of
> their time waiting on DBW0?  Does every block in UET$ and FET$ have to
> get written out before the deallocate can proceed?  If so, why?
>
> Using a normal application, I can delete and insert tens of thousands
> of rows in just a few seconds.  What takes Oracle so long with UET$
> and FET$?
>
> BTW, this is not a problem that I personally have - it is a purely
> academic question.

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

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

RE: NOT IN with NULL-values

[Larry Elkins]

Frank,

"A NOT IN evaluates to FALSE if *any* member of the set is NULL".

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a85397/operator.htm#1003933

Also scroll up just a tad on that link and look at the comments for NOT IN
in table 3.4. This is a subtlety that many folks overlook until it bites
them on the tail.

With regards to your NOT EXISTS, you didn't include correlation between the
two tables (which Amar pointed out with the example). Try this:

SQL> select * from fk_ldm1 a
  2  where not exists (select * from fk_ldm2 b where a.id = b.id);

ID
--
 3

For each row in fk_ldm1 the sub-query is evaluated. And since you did not
include correlation, the sub-query will always return a row(s) (there's no
criteria on it), thus making the NOT EXISTS condition FALSE for each row in
fk_ldm1.


Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kuijten, F.
> (Frank)
> Sent: Monday, October 29, 2001 8:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: NOT IN with NULL-values
>
>
> Amar,
>
> Thanks.
>
> One question : Do you have a NULL value in the 'am91' table ?
>
> Because that's where my problem is.
> Without the NULL value, all queries are giving the expected results.
>
>
> Greetings,
> Frank
>

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

RE: Corruption in SYSTEM Tablespace

[Gogala, Mladen]

Restore the last hot backup and do the database recovery.

> -Original Message-
> From: Rajesh Dayal [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 29, 2001 12:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Corruption in SYSTEM Tablespace
> 
> 
> Hi All,
> Fortunately this is there only in my TEST database. But I am 
> wondering, how to resolve if this happens in Production Database. 
>   I can't export Full database with zero errors. Although I can 
> export most of the schemas individually. Dbverify shows some 3 blocks
> to be corrupted, that's too only in SYSTEM TS.
> Any ideas would be appreciated.
> 
> TIA,
> Rajesh
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rajesh Dayal
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Last day of the month unix

[Bellows, Bambi]

Well, you can do date functions in Unix.  The date function is date.  It's
not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following.  You'll want to test it because no to Unii
are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L



-- Sinard Xing <[EMAIL PROTECTED]>

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>   lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check
for

UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';

--
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: Steven Lembark
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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