Ang: SQL Loader Commit Point?

[Roland . Skoldblom]

Well,

you can runt the sqllodader again and then include this line after the name ofthe 
control file.

 log = C:\temp\error.log

and that creates a logfile where you can see what has happened. The problem you are 
having can be caused
 by invalid length of the datafield in the database, or you have tried to insert a 
nullvalue inthe database where there is a constraint.

Hope this helps

Roland









Ken Janusz <[EMAIL PROTECTED]>@fatcity.com den 2001-12-03 13:33 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


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

I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.

-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

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

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

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









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

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

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

RE: how to pass argument to a dos batch program from sqlplus

[Nirmal Kumar Muthu Kumaran]

Title: RE: how to pass argument to a dos batch program from sqlplus





Have you been tried for it?


It'll work fine.



-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, December 04, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L
Subject:    how to pass argument to a dos batch program from sqlplus


Hello List,
I need to pass several arguments to a dos batch program which is being
called from sqlpus through HOST command.  
Example: host mybatch.bat myargument myargument
Would such idea work?
Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


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

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

Listener

[Roland . Skoldblom]

Hallo,

Can anybody tell me simply how the listener works?

Thanks in advance

Roland S



-- 
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: Anybody heard Oracle will remove the JVM from Oracle in

[Steven Lembark]

-- Jared Still <[EMAIL PROTECTED]>

>
>> DBI is your friend :-) Now that they've combined svrmgrl
>> into the sqlplus engine there isn't anything you can't
>> do through DBD::Oracle (or the shell if really necessary).
>
> Yeah, this has some very cool implications.  It would be possible
> to start and stop your databases remotely via DBI/DBD::Oracle.
>
> Centralized remote management ala Perl!
>
> Throw in some Apache and some mod_perl, write a fairly
> decent app...
>
> Hmmm...   Like OEM but manageable.  :{)

The current Oracle distro. comes with Apache and mod_perl.
Throw in CPAN and the database can almost run itself.


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

Re: Anybody heard Oracle will remove the JVM from Oracle in future

[Steven Lembark]

-- Jared Still <[EMAIL PROTECTED]>

>> Unlikely they'll actually dump java. If Oracle would simply
>> SUPPORT DBI it'd be worth something...

> I think they do.  Isn't it included now in the 9i version of iAS ?

It is there. What I don't know is how well supporte it is.
Say you call up with a question on why DBI isn't handling
the placeholders properly or can't execute a database
startup. Are they going to work through a solution or just
tell you to email the dbi list?

Or has anyone tried this and gotten some sort of result yet?

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

RE: _delete_me=true

[Deepak Thapliyal]

gee what is ping? oh yeah maybe thomas needs to know
that;)

its been a long day .. dont mind !!!


--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> Gee, how do I unsubscribe?  Oh-yeah!  Its at the
> bottom of every piece of
> mail!!!  
> Holy Cow BatMan!
> 
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
> -Original Message-
> Sent: Monday, December 03, 2001 1:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Does he think - UNSUBSCRIBE?
> 
> :-))
> On Mon  3. December 2001 18:55, you wrote:
> > _delete_me=true
> >
> > __
> > Do You Yahoo!?
> > Buy the perfect holiday gifts at Yahoo! Shopping.
> > http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.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: simple sql problem

[Nirmal Kumar Muthu Kumaran]

Title: RE: simple sql problem





Hi...


You cann't run sql statement in command line directly However you can in case of script file.


Make the query as a script file.  Then run it on SQLPLUS.


-- c:\test.sql
-
select * from emp
/
exit
/
--


c:\> sqlplus -s scott/tiger@oranir @c:\test


This will work.


HTH.



Rgds,
Nirmal,

-Original Message-
From:   Viraj Luthra [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, December 04, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
Subject:    simple sql problem


Hello all,


Why cannot I do :-


sqlplus -s scott/tiger select * from emp;


or sqlplus -s scott/tiger "select * from emp;"


Both the cases I get :-


Usage: SQLPLUS [] [[/] [@]]    
   [@ [] [] ...]    
where  ::= { -s | -? }   
-s for silent mode and -? to obtain version number   



What is wrong above? I need to run the query from command line. How do I modify this :-


sqlplus -s scott/tiger select * from emp;



Rgds,




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


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

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

[Tatireddy, Shrinivas (MED, Keane)]

try this


$ echo "select * from emp;" | sqlplus scott/tiger

srinivas

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 2:31 AM
To: Multiple recipients of list ORACLE-L


You can't have the SQL statements on the command line.  You must put
them
in
a script file (eg myscript.sql) and execute it with the @ sign.
Thus,
sqlplus -s scott/tiger @myscript[note the SPACE between the "tiger"
and
the "@"].
Hemant



"Viraj Luthra" <[EMAIL PROTECTED]>  04/12/2001 01:10 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
 

 To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>   
 cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)

 Subject: simple sql problem

 

 

 






Hello all,

Why cannot I do :-

sqlplus -s scott/tiger select * from emp;

or sqlplus -s scott/tiger "select * from emp;"

Both the cases I get :-

Usage: SQLPLUS [] [[/] [@]]
   [@ [] [] ...]
where  ::= { -s | -? }
-s for silent mode and -? to obtain version number


What is wrong above? I need to run the query from command line. How do I
modify this :-

sqlplus -s scott/tiger select * from emp;


Rgds,



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

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

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




[This e-mail is confidential and may also be privileged. If you are not
the
intended recipient, please delete it and notify us immediately; you
should
not copy or use it for any purpose, nor disclose its contents to any
other
person. Thank you.]

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

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

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

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

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

[Viraj Luthra]

 Jared,

Using the 2nd option:-

sqlplus system/manager@orcl815 <   234567  Disconnected from Oracle8i Release 8.1.5.0.0 - 
Production
With the Java option   
 
PL/SQL Release 8.1.5.0.0 - Production  
 



But if I use the 1st option :-

eg

echo "SELECT a.username,  substr(sql_text,1,100), 
substr(sql_text,101,250),substr(sql_text,601,250),substr(sql_text,851,250),
substr(sql_text,1101,250)
FROM dba_users a, v$session, v$sqlarea where parsing_user_id=user_id AND 
address=sql_address(+)
and sid=15;"|sqlplus system/manager

I get this error:-

SQL>   234  FROM dba_users a, v, v where parsing_user_id=user_id AND 
address=sql_address(+)  
 * 
  
ERROR at line 3:   
  
ORA-00942: table or view does not exist
  
   
  

But if I execute the query on its own, I get proper results.

So in both cases I am not able to get results.

What am I doing wrong?

Rgds,
--

On Mon, 3 Dec 2001 21:38:36   
 Jared Still wrote:
>
>The way you're doing it sqlplus is trying to parse the SQL 
>as a command line argument, which will not work.
>
>Try these:
>
>1.
>
>echo "select * from dual;" | sqlplus scott/tiger
>
>2.
>
>sqlplus scott/tiger EOF
>
>Jared
>
>
>On Monday 03 December 2001 21:10, Viraj Luthra wrote:
>> Hello all,
>>
>> Why cannot I do :-
>>
>> sqlplus -s scott/tiger select * from emp;
>>
>> or sqlplus -s scott/tiger "select * from emp;"
>>
>> Both the cases I get :-
>>
>> Usage: SQLPLUS [] [[/] [@]]
>>[@ [] [] ...]
>> where  ::= { -s | -? }
>> -s for silent mode and -? to obtain version number
>>
>>
>> What is wrong above? I need to run the query from command line. How do I
>> modify this :-
>>
>> sqlplus -s scott/tiger select * from emp;
>>
>>
>> Rgds,
>


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

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

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






Oracle Portal Questions


2001-12-03

Thread
hemantchitale



 A couple of questions for two alternative scenarios we are looking at :

1.  One iAS f or Two Portal DBs with the same initial URL
OR
2.  Two iAS installs for two Portal DBs with the same initial URL
   
  
 We are looking at 
seperate  
 Portal databases for 
the
 Employees Portal  
  
 and the Customers 
Portal.  To   
 make them visible 
from the  
 Internet, 
  
 we would like to have 
the same  
 initial URL.  
  
   
  
 Has anyone attempted 
anything   
 like this ?  Is it 
doable ? 
   
  
 Hemant
  
   
  





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

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

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






Re: simple sql problem


2001-12-03

Thread
Jared Still



The way you're doing it sqlplus is trying to parse the SQL 
as a command line argument, which will not work.

Try these:

1.

echo "select * from dual;" | sqlplus scott/tiger

2.

sqlplus scott/tiger < Hello all,
>
> Why cannot I do :-
>
> sqlplus -s scott/tiger select * from emp;
>
> or sqlplus -s scott/tiger "select * from emp;"
>
> Both the cases I get :-
>
> Usage: SQLPLUS [] [[/] [@]]
>[@ [] [] ...]
> where  ::= { -s | -? }
> -s for silent mode and -? to obtain version number
>
>
> What is wrong above? I need to run the query from command line. How do I
> modify this :-
>
> sqlplus -s scott/tiger select * from emp;
>
>
> Rgds,
-- 
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).






Re: Anybody heard Oracle will remove the JVM from Oracle in future


2001-12-03

Thread
Jared Still



I think they do.  Isn't it included now in the 9i version of iAS ?

Jared

On Monday 03 December 2001 20:25, Steven Lembark wrote:
> -- Scott Shafer <[EMAIL PROTECTED]>
>
> > Haven't heard myself, but I hope this is true.  Please, please, please
> > let it be true!
>
> Unlikely they'll actually dump java. If Oracle would simply
> SUPPORT DBI it'd be worth something...
>
> --
> 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: 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).






Deferred appliction of arch logs in Standby DB


2001-12-03

Thread
Ross Collado


Is there a way to defer the application of archive logs in the Standby db?
Or maybe defer the actual sending of the logs from the Primary db.  Kind of
like the INTERVAL option in SCHEDULE_PUSH of Adv. Replication.

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

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

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






Re: Anybody heard Oracle will remove the JVM from Oracle in


2001-12-03

Thread
Jared Still



> DBI is your friend :-) Now that they've combined svrmgrl
> into the sqlplus engine there isn't anything you can't
> do through DBD::Oracle (or the shell if really necessary).

Yeah, this has some very cool implications.  It would be possible
to start and stop your databases remotely via DBI/DBD::Oracle.

Centralized remote management ala Perl!

Throw in some Apache and some mod_perl, write a fairly 
decent app...

Hmmm...   Like OEM but manageable.  :{)

Jared


On Monday 03 December 2001 21:05, Steven Lembark wrote:
> -- David McVeigh <[EMAIL PROTECTED]>
>
> > I have to concur. I run a small backup utility for an Oracle / Sun box
> > via my browser every morning, and it takes ages to load. This is on a
> > brand new network. And yes, it's a buggy, fussy piece of software. I hate
> > to say this, but even something written in VB would be faster and far
> > more user-friendly.
>
>
> --
> 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: 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).






RE: simple sql problem


2001-12-03

Thread
Ross Collado


I don't believe SQLPlus will let you run a SQL statement in the command line
itself.  As you can see in Usage:, it doesn't have an option for this.
However, if you insist on running SQL statements in the command line itself,
you can probably do something like (only in Unix):

sqlplus -s scott/tiger << !
select * from emp;
!

or 

save your select * from emp; to a sql file and do :
sqlplus -s scott/tiger @myfile.sql

hth
Ross

> -Original Message-
> From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 4 December 2001 16:11
> To: Multiple recipients of list ORACLE-L
> Subject: simple sql problem
> 
> 
> Hello all,
> 
> Why cannot I do :-
> 
> sqlplus -s scott/tiger select * from emp;
> 
> or sqlplus -s scott/tiger "select * from emp;"
> 
> Both the cases I get :-
> 
> Usage: SQLPLUS [] [[/] [@]]
>[@ [] [] ...]
> where  ::= { -s | -? }   
> -s for silent mode and -? to obtain version number   
> 
> 
> What is wrong above? I need to run the query from command 
> line. How do I modify this :-
> 
> sqlplus -s scott/tiger select * from emp;
> 
> 
> Rgds,
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Viraj Luthra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ross Collado
  INET: [EMAIL PROTECTED]

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

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






Re: What is OAS ?


2001-12-03

Thread
Jared Still



You forgot to say it is obsolete.  :)

Jared

On Monday 03 December 2001 19:35, satish p wrote:
> Hi ,
> OAS - Oracle application server .
>
> satish
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Riswandi
>   Sent: Tuesday, December 04, 2001 6:30 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: What is OAS ?
>
>
>   Hi all,
>
>
>   What is OAS ?
>
>
>   Thx...


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 



Content-Type: text/plain; charset="iso-8859-1"; name="Wipro_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Description: 

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






Re: simple sql problem


2001-12-03

Thread
hemantchitale


You can't have the SQL statements on the command line.  You must put them
in
a script file (eg myscript.sql) and execute it with the @ sign.
Thus,
sqlplus -s scott/tiger @myscript[note the SPACE between the "tiger" and
the "@"].
Hemant



"Viraj Luthra" <[EMAIL PROTECTED]>  04/12/2001 01:10 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

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

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

 Subject: simple sql problem   

   

   

   






Hello all,

Why cannot I do :-

sqlplus -s scott/tiger select * from emp;

or sqlplus -s scott/tiger "select * from emp;"

Both the cases I get :-

Usage: SQLPLUS [] [[/] [@]]
   [@ [] [] ...]
where  ::= { -s | -? }
-s for silent mode and -? to obtain version number


What is wrong above? I need to run the query from command line. How do I
modify this :-

sqlplus -s scott/tiger select * from emp;


Rgds,



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

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

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




[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]

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

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

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






simple sql problem


2001-12-03

Thread
Viraj Luthra


Hello all,

Why cannot I do :-

sqlplus -s scott/tiger select * from emp;

or sqlplus -s scott/tiger "select * from emp;"

Both the cases I get :-

Usage: SQLPLUS [] [[/] [@]]
   [@ [] [] ...]
where  ::= { -s | -? }   
-s for silent mode and -? to obtain version number   


What is wrong above? I need to run the query from command line. How do I modify this :-

sqlplus -s scott/tiger select * from emp;


Rgds,



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

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

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






Re: Anybody heard Oracle will remove the JVM from Oracle in


2001-12-03

Thread
Steven Lembark




-- David McVeigh <[EMAIL PROTECTED]>

> I have to concur. I run a small backup utility for an Oracle / Sun box
> via my browser every morning, and it takes ages to load. This is on a
> brand new network. And yes, it's a buggy, fussy piece of software. I hate
> to say this, but even something written in VB would be faster and far
> more user-friendly.

DBI is your friend :-) Now that they've combined svrmgrl
into the sqlplus engine there isn't anything you can't
do through DBD::Oracle (or the shell if really necessary).

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






Re: Anybody heard Oracle will remove the JVM from Oracle in


2001-12-03

Thread
David McVeigh


I have to concur. I run a small backup utility for an Oracle / Sun box via my browser 
every morning, and it takes ages to load. This is on a brand new network. And yes, 
it's a buggy, fussy piece of software. I hate to say this, but even something written 
in VB would be faster and far more user-friendly.

>>> "Scott Shafer" <[EMAIL PROTECTED]> 12/04/01 01:50pm >>>
Hopefully there will be an end to the java hype, the buggy, slow, java-fied
installers, etc...

--Scott


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


> Why???
>
> -Original Message-
> Sent: Monday, December 03, 2001 5:33 PM
> To: Multiple recipients of list ORACLE-L
> future re
>
>
> Haven't heard myself, but I hope this is true.  Please, please, please
> let it be true!
>
> --Scott
>
>
> "Khedr, Waleed" wrote:
> >
> > Thanks,
> >
> > Waleed
>
> _
> 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: 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).


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



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**

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

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

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






Re: Anybody heard Oracle will remove the JVM from Oracle in future


2001-12-03

Thread
Steven Lembark




-- Scott Shafer <[EMAIL PROTECTED]>

> Haven't heard myself, but I hope this is true.  Please, please, please
> let it be true!

Unlikely they'll actually dump java. If Oracle would simply
SUPPORT DBI it'd be worth something...

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






Changes to db after renaming mount points


2001-12-03

Thread
Sujatha Madan


Hi,

I now have extra disks so I am re-arranging our databases. We will also be
renaming the mount points (obviously the db's are on UNIX - HP-UX).

I just want to confirm the steps I would have to do for this:

1. Make a cold backup
2. Move Controlfiles:
(i) copy existing cf's to new location
(ii) edit the control_files parameter in init.ora to change the existing
cf name.
3. Rename/move redo logs:
(i) Copy existing redo logs to new location
(ii) Do a ALTER DATABASE RENAME FILE for each redo log moved

4. Rename/move datafiles:
(i) Copy existing df's to new location
(ii) Do a ALTER DATABASE RENAME FILE for each datafile moved.

Does this sound fine? ... Have I missed anything? ... or should I look out
for something special?

Thanks for your help

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: Anybody heard Oracle will remove the JVM from Oracle in futur


2001-12-03

Thread
Scott Shafer


Hopefully there will be an end to the java hype, the buggy, slow, java-fied
installers, etc...

--Scott


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


> Why???
>
> -Original Message-
> Sent: Monday, December 03, 2001 5:33 PM
> To: Multiple recipients of list ORACLE-L
> future re
>
>
> Haven't heard myself, but I hope this is true.  Please, please, please
> let it be true!
>
> --Scott
>
>
> "Khedr, Waleed" wrote:
> >
> > Thanks,
> >
> > Waleed
>
> _
> 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: 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).


_
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: What is OAS ?


2001-12-03

Thread
satish p




Hi 
,
OAS - 
Oracle application server .
 
satish

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of RiswandiSent: Tuesday, 
  December 04, 2001 6:30 AMTo: Multiple recipients of list 
  ORACLE-LSubject: What is OAS ?
  Hi all,
   
   
  What is OAS ?
   
   
  Thx...

The Information contained and transmitted by this E-MAIL is proprietary to Wipro 
and/or its Customer and is intended 
for use only by the individual or entity to which it is addressed, and may contain 
information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a forwarded 
message, the content of this
E-MAIL may not have been sent with the authority of the Company. If you are not the 
intended recipient, an agent
of the intended recipient or a  person responsible for delivering the information to 
the named recipient,  you are
notified that any use, distribution, transmission, printing, copying or dissemination 
of this information in any way
or in any manner is strictly prohibited. If you have received this communication in 
error, please delete this mail &
notify us immediately at [EMAIL PROTECTED]






how to pass argument to a dos batch program from sqlplus


2001-12-03

Thread
lhoska


Hello List,
I need to pass several arguments to a dos batch program which is being
called from sqlpus through HOST command.  
Example: host mybatch.bat myargument myargument
Would such idea work?
Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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






RE: rman oddities


2001-12-03

Thread
Ron Yount

Title: rman oddities



Hi, 

 
I have 
seen some responses and discussions about 'orphaned' backups regarding RMAN 
after a recovery has been done.  I would like to attempt to clarify why 
"old" backups being registered in the catalog are important, and very useful in 
a given situation for purposes of clarity.
 
Let say 
that:
 
1) 
January 1st, you start using RMAN to backup your database.
2) On 
February 1st, your favorite application team asks you to restore the database to 
12:00 on January 28th due to some logical corruption of data that was caused by 
the application code (or careless user :-) .
3) You 
succeed in restoring to noon on 1/28.  (Happy with the ease of using 
performing this with RMAN, but of course you inform the application owners that 
they owe you one.
4) They 
thank you, offer their first-born (if you feel so inclined) and return to their 
daily routine. only to discover that the corruption did not start after 
12:00 am on the 28th, it actually occurred during a batch load at 3:00 am on the 
28th.
 
a) In 
RMAN terms, your backups up until Feb 1st comprise a set known as "incarnation" 
# 1.
b) When 
you performed the restore, and obligatory "reset database" in rman after opening 
with "reset logs" you started a brand new incarnation... # 
2.
c) Now 
you have a dilemma because the database (and RMAN believe that the current 
database was "born" at 12:00 noon on 1/28 and therefore will not know what to do 
with the inevitable request to restore it to 2:20 am on 1/28 unless! you 
understand incarnations.
d) 
Since you understand incarnations, you have the option of telling rman to switch 
back to incarnation # 1.  This allows you tell rman to restore to a new 
point in time anywhere between the 1st of January and the 1st of February. 

 
So... 
all backups have a valid place in the never-ending reality that users expect a 
request to "just put it back to something else... that it once was..." to be 
simple and logical...
 
As an 
RMAN user, you will not let them down, nor find yourself talking to the overhead 
lights in a tongue that nobody can understand. :-)
 
HTH,
-Ron-
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Monday, December 03, 2001 1:27 PMTo: Multiple recipients of list 
  ORACLE-LSubject: rman oddities
  Hi Ruth, thanks so much for 
  responding.  
  Yes, I wrote the scripts to do an arclog 
  backup delete.  I'm concerned about the arclogs hanging around after a 
  restore and taking up disk space, along with unnecessarily inflating the size 
  of my backup files.  (I'm testing backup to disk right now)
  It's more of a nice to know, not 
  necessary.  I'm seeing some weird stuff that I didn't expect and the 
  monkey in me wants to know why...  No, not the baby :)  Here's some 
  other odd behavior I've seen:
  1.  Instance failure during a backup 
  leaves the rman files intact but the backup itself is not reflected in the 
  catalog.  The database recovers nicely from this since no tablespaces are 
  in hotbackup mode (yes)  The end result is "orphan" rman files 
  that the catalog knows nothing about. 
  2.  Initially these files are created 
  the size of all datafiles combined.  As the backup progresses, the size 
  of the files shrink down considerably.   For example, I allocate 3 
  channels to disk and setsize to 2GB, but the files start out at 1.5GB and 
  shrink down to ~500 MB.   I wonder if that behavior happens on 
  tape?  Anyone?  I'll be able to test this later this week.  
  
  3.  Can restore and recovery 
  really be this easy?  Sheesh 
  Thanks again for your response.  And 
  list, please correct me if I am wrong on any of this. 
  yours in Monkeying Around, 
  Lisa 
  
-Original Message- From:   Ruth 
Gramolini [SMTP:[EMAIL PROTECTED]] Sent:   Monday, December 
03, 2001 1:17 PM To: Multiple recipients of list ORACLE-L Subject:    Re: rman restore & arclogs 
Lisa, 
We backup all archivlogs with the backup set and 
delete them. Delete is an rman option 
when you backup archivelogs.  We don't have room to keep them. 
It is a bit of a pain to restore them but you 
learn to live with it. 
Have a look at rman's tables and views. You 
should be able to query them and get what 
you want. 
Yours in rman, Ruth - Original Message 
- To: "Multiple recipients of list 
ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 10:30 AM 
> Good morning all - > > I've been 
practicing rman restores.  It's a lot easier than I originally 
> thought.  I've noticed that when you 
restore and the arclogs are needed, it > restores them.  Which 
is expected.  However, when I take another backup, > these arclogs are included in the backup set.  
This is unnecessary in my > opinion 
and makes my backup files larger than they need to be. > > Is it 
standard practice to j



What is OAS ?


2001-12-03

Thread
Riswandi




Hi all,
 
 
What is OAS ?
 
 
Thx...





Re: Question on dba_ts_quotas


2001-12-03

Thread
Quamrul Polash


Hi,

If you alter the quota for a user to zero bytes on any tablespace, it will 
not show up in the dba_ts_quotas for that user. In your third query, in 
which schema the table was created?

HTH,

Quamrul


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Question on dba_ts_quotas
>Date: Mon, 03 Dec 2001 14:56:33 -0800
>
>
>Hi All,
>
>I have a question on dba_ts_quotas.
>
>User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
>tablespaces. And, I expect that the relation/quota
>would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
>for this schema. I checked for other
>schemas and they showed up.
>Just for testing, I created a dummy table to test it and it got created
>without any problems.
>
>Why is it not showing up in dba_ts_quotas. Am I missing something here?
>BTW, I am using SYSTEM to query these views.
>
>Thanks in advance for your help.
>
>SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';
>
>TABLESPACE_NAME
>--
>TS_QUOTE_DATA
>TS_QUOTE_INDEX
>
>SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';
>
>no rows selected
>
>CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;
>
>Table created.
>
>
>Best regards,
>Prasad
>
>
>--
>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).


_
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: Quamrul Polash
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
Jared . Still



>  being a dba is kinda fun.  Once I actually got to start doing it, that
is.

Look Lisa, you keep that to yourself.

Under no circumstances should you *ever* let
a manager hear you say that.

JARed




   

"Koivu, Lisa"  


field.com>  cc:

Sent by:Subject: RE: rman restore & arclogs

[EMAIL PROTECTED]   

   

   

12/03/01 11:31 AM  

Please respond to  

ORACLE-L   

   

   





Thanks Tom.  I did try removing the arclogs and then running a backup - no
complaints.  The arclogs in question were still present in the catalog via
past backups.   I'm guessing this is because the last scn of the last
backup was larger than the scn's included in the arclogs in question.


However, a crosscheck report caused failure for all those logs.  Not a big
deal, but once this all goes into production I want to see all my reports &
lists sent to me every day with no "FAILURE" or anything of that nature in
it.  Erring conservative is probably better anyway, unless i'm really tight
on disk.


Restoring is kinda fun :)  I take that back, being a dba is kinda fun.
Once I actually got to start doing it, that is.






 -Original Message-
 From:   Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
 Sent:   Monday, December 03, 2001 1:56 PM
 To: Multiple recipients of list ORACLE-L
 Subject:RE: rman restore & arclogs


 Lisa,

 I guess I'm lazy (or cautious) in that I would allow the first backup
 to take this archive log files back to tape where they belong, rather
 than determine (by running reports) which log files I may delete (by
 hand).



 The cautious part of me says that if Rman decided to back these
 monkeys up within the first save set after the recovery, it may have
 decided that it needs them for a future recovery.  If you did remove
 them by hand, Rman may complain that it was expecting them and did not
 find them.  Did you try this - remove one that was restored by the
 recovery process and then tried a backup?



 Depending on the kind of restore you do  - a full, or a point in time
 - the archivelog may be of no use anyway (a point in time makes them
 invalid because you had to perform an "open db reset logs", while a
 full restore could still use these again).



 Glad you are at least experimenting with the tool before you put it in
 production - it actually is fun to do a restore as it happens so
 infrequently!



 Good Luck!


 Tom Mercadante
 Oracle Certified Professional


  -Original Message-
  From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
  Sent: Monday, December 03, 2001 10:30 AM
  To: Multiple recipients of list ORACLE-L
  Subject: rman restore & arclogs



  Good morning all -


  I've been practicing rman restores.  It's a lot easier than I
  originally thought.  I've noticed that when you restore and the
  arclogs are needed, it restores them.  Which is expected.
  However, when I take another backup, these arclogs are included
  in the backup set.  This is unnecessary in my opinion and makes
  my backup files larger than they need to be.


  Is it standard practice to just delete the arclogs that were
  already in a backup set prior to taking the immediate backup
  after a recovery?  I can verify what arclogs are where in the
  backup sets with a report.


  Any comments are appreciated.  Thanks


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







--
Please see the official ORACLE-L FAQ: http://



Re: Question on dba_ts_quotas


2001-12-03

Thread
Jared . Still



If you check DBA_SYS_PRIVS you will likely
find that the user has 'UNLIMITED TABLESPACE'.

Probably due to granting RESOURCE to the user.

Jared



   

Prasada.Gunda1@hartfo  

rdlife.com  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Sent by:cc:

[EMAIL PROTECTED]Subject: Question on dba_ts_quotas 

   

   

12/03/01 02:56 PM  

Please respond to  

ORACLE-L   

   

   






Hi All,

I have a question on dba_ts_quotas.

User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
tablespaces. And, I expect that the relation/quota
would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
for this schema. I checked for other
schemas and they showed up.
Just for testing, I created a dummy table to test it and it got created
without any problems.

Why is it not showing up in dba_ts_quotas. Am I missing something here?
BTW, I am using SYSTEM to query these views.

Thanks in advance for your help.

SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';

TABLESPACE_NAME
--
TS_QUOTE_DATA
TS_QUOTE_INDEX

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';

no rows selected

CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;

Table created.


Best regards,
Prasad


--
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: Anybody heard Oracle will remove the JVM from Oracle in futur


2001-12-03

Thread
Gogala, Mladen


Rumor is that there will be a perl engine in the database instead of Java
one.


-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


"Khedr, Waleed" wrote:
> 
> Thanks,
> 
> Waleed

_
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: 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: killing system user


2001-12-03

Thread
Jared . Still



Found it:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1011386.6

Jared



   

Deepak Thapliyal   


YAHOO.COM>  cc:

Sent by:Subject: Re: killing system user   

[EMAIL PROTECTED]   

   

   

12/03/01 02:09 PM  

Please respond to  

ORACLE-L   

   

   





yeah Jared, i will look at it. C i am wondering that
if the SID is sufficient to gaurentee uniqueness ..
why does oracle need the serial# as well??

or maybe there is a scheduled maintainance window at
this time inside of my head ;)

Thx anyhu ;)

Deepak


--- [EMAIL PROTECTED] wrote:
>
> Deepak,
>
> To be quite honest, I can't remember.  I'm like that
> with details
> sometimes.
> I tend to forget them, though I remember the reason
> I learned them in
> the first place.  :)
>
> This is on MetaLink somewhere if you care to look
> for it.  I really
> can't do that now.  It's back to the grindstone for
> me.
>
> The grindstone in this case being iFS 1.1.9.  Ah the
> joy of
> troubleshooting.  :)
>
> Jared
>
>
>
>
>
>
>





-- 
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: Anybody heard Oracle will remove the JVM from Oracle in futur


2001-12-03

Thread
Khedr, Waleed


Why???

-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


"Khedr, Waleed" wrote:
> 
> Thanks,
> 
> Waleed

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






UTL_SMTP to send email


2001-12-03

Thread
Suhen Pather









List,

 

I am sending email from the database.

I have UTL_SMTP setup which works fine.

 

However in the message field I would like to query a table (using
a select)

rather than a hardcoded
message.

 

Not sure how to do this though. 

Anyone got any pointers will be greatly appreciated.

 

PROCEDURE send_mail (

sender IN VARCHAR2,

recipient IN VARCHAR2,

subject IN VARCHAR2,

message IN VARCHAR2

)

IS

mailhost VARCHAR2 (30) := 'www';

mail_conn utl_smtp.connection;

crlf VARCHAR2 (2) := CHR (13)

|| CHR (10);

mesg VARCHAR2 (1000);

BEGIN

mail_conn := utl_smtp.open_connection
(mailhost, 25);

mesg := 'Date: '

|| TO_CHAR (SYSDATE, 'dd Mon yy hh24:mi:ss')

|| crlf

|| 'From: <'

|| sender

|| '>'

|| crlf

|| 'Subject: '

|| subject

|| crlf

|| 'To: '

|| recipient

|| crlf

|| ''

|| crlf

|| message;

utl_smtp.helo (mail_conn,
mailhost);

utl_smtp.mail (mail_conn,
sender);

utl_smtp.rcpt (mail_conn,
recipient);

utl_smtp.data (mail_conn,
mesg);

utl_smtp.quit (mail_conn);

END;

 

 

Thanks & Regards 

Suhen











RE: rman restore & arclogs


2001-12-03

Thread
Deepak Thapliyal


We have a slightly differnt apprach for this ..

1. 
cp arch files to arch history location (stage 2 days
worth achives on disk. there is a cron that fires
everday and deletes all files from hostory arch
location which are two or more days older)

2.there is a script that invokes rman to backup arch
using delete input clause

steps 1 and 2 are done every 4 hours for archives so
that archives are backed up to tape and to ensure as
per sla that we store atleast 2 days worth of archives
on disk. 

at the end of the day take a db backup(full or inc as
per sla. vaires from db to db)

Deepak


--- "HAWKINS, JAMES W [IT/1000]"
<[EMAIL PROTECTED]> wrote:
> I just wanted to throw something else out there - it
> may have already come
> up though.  We backup the archivelogs first without
> deleting them, and then
> immediately backup another set with the "delete"
> specified.  Obviously, this
> is because anything can happen to that first set
> (corruptions, etc.), and if
> that's your only set, then you're screwed.  The
> chances of the same
> archivelog being corrupt in both sets is very low
> (unless the source
> archivelog is corrupted), but at least you are
> protected against all the
> copy errors.  Also, it's very probable (for us,
> anyway) that each copy of
> the archivelog will be on different physical tapes,
> which in itself is
> important to us since operations is outsourced ; )
>  
> Jim
>  
> 
> __ 
> Jim Hawkins 
> Oracle Database Administrator 
> Data Management Center of Expertise 
> 
> Pharmacia Corporation 
> 800 North Lindbergh Blvd. 
> St. Louis, Missouri  63167 
> Work  (314) 694-4417 
> Cellular (314) 724-9664 
> Pager (314) 294-9797 
> 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Monday, December 03, 2001 12:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Lisa,
>  
> I guess I'm lazy (or cautious) in that I would allow
> the first backup to
> take this archive log files back to tape where they
> belong, rather than
> determine (by running reports) which log files I may
> delete (by hand).
>  
> The cautious part of me says that if Rman decided to
> back these monkeys up
> within the first save set after the recovery, it may
> have decided that it
> needs them for a future recovery.  If you did remove
> them by hand, Rman may
> complain that it was expecting them and did not find
> them.  Did you try this
> - remove one that was restored by the recovery
> process and then tried a
> backup?
>  
> Depending on the kind of restore you do  - a full,
> or a point in time - the
> archivelog may be of no use anyway (a point in time
> makes them invalid
> because you had to perform an "open db reset logs",
> while a full restore
> could still use these again).
>  
> Glad you are at least experimenting with the tool
> before you put it in
> production - it actually is fun to do a restore as
> it happens so
> infrequently!
>  
> Good Luck!
> 
> Tom Mercadante 
> Oracle Certified Professional 
> 
> -Original Message-
> Sent: Monday, December 03, 2001 10:30 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Good morning all - 
> 
> I've been practicing rman restores.  It's a lot
> easier than I originally
> thought.  I've noticed that when you restore and the
> arclogs are needed, it
> restores them.  Which is expected.  However, when I
> take another backup,
> these arclogs are included in the backup set.  This
> is unnecessary in my
> opinion and makes my backup files larger than they
> need to be. 
> 
> Is it standard practice to just delete the arclogs
> that were already in a
> backup set prior to taking the immediate backup
> after a recovery?  I can
> verify what arclogs are where in the backup sets
> with a report.  
> 
> Any comments are appreciated.  Thanks 
> 
> Lisa Koivu 
> Oracle Database Monkey 
> Fairfield Resorts, Inc. 
> 954-935-4117 
> 
> 


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.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).






Question on dba_ts_quotas


2001-12-03

Thread
Prasada . Gunda1



Hi All,

I have a question on dba_ts_quotas.

User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
tablespaces. And, I expect that the relation/quota
would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
for this schema. I checked for other
schemas and they showed up.
Just for testing, I created a dummy table to test it and it got created
without any problems.

Why is it not showing up in dba_ts_quotas. Am I missing something here?
BTW, I am using SYSTEM to query these views.

Thanks in advance for your help.

SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';

TABLESPACE_NAME
--
TS_QUOTE_DATA
TS_QUOTE_INDEX

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';

no rows selected

CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;

Table created.


Best regards,
Prasad


-- 
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: function help ???


2001-12-03

Thread
Scott Crabtree


Andrea,
Here is a version of the function you asked for, IT IS NOT WELL
TESTED, should give you something to go on.

Scott Crabtree

FUNCTION calc_avg (student_id IN NUMBER)
   RETURN NUMBER
AS
   CURSOR student_c
   IS
  SELECT  snum
   || call# class, credit, RTRIM (grade) grade,
 credit
   * DECODE (RTRIM (grade), 'A', 4, 'B', 3, 'C', 2, 'D', 1, 'F',
0) weight
  FROM enrollment
 WHERE student# = student_id
  ORDER BY grade DESC;

   last_classNUMBER  := 0;
   last_weight   NUMBER  := 0;
   last_credit   NUMBER  := 0;
   last_gradeVARCHAR2 (1):= 'Z';
   cum_weightNUMBER  := 0;
   cum_credits   NUMBER  := 0;
   gpa   NUMBER (5, 2)   := 0.00;
   student_rec   student_c%ROWTYPE;
BEGIN
   OPEN student_c;
   FETCH student_c INTO student_rec;

   WHILE student_c%FOUND
   LOOP
  --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) || ' ' ||
nvl(to_char(student_rec.credit),'NULL'));
  IF  last_class = student_rec.class  --Repeat_delete 
  AND last_grade IN ('F', 'D')
  AND student_rec.grade IN ('A', 'B', 'C')
  THEN
 cum_weight :=   cum_weight
   - last_weight
   + student_rec.weight;
 cum_credits :=   cum_credits
- last_credit
+ student_rec.credit;
  --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) ||
to_char(student_rec.credit));
  ELSE
 cum_weight :=   cum_weight
   + student_rec.weight;
 cum_credits :=   cum_credits
+ student_rec.credit;
  END IF;

  last_class := student_rec.class;
  last_weight := student_rec.weight;
  last_credit := student_rec.credit;
  last_grade := student_rec.grade;
  FETCH student_c INTO student_rec;
   END LOOP;

   CLOSE student_c;
   gpa := cum_weight / cum_credits;
   -- DBMS_OUTPUT.PUT_LINE('Cum Weight:' || to_char(cum_weight) || ' Cum
Credits:' || to_char(cum_credits));
   RETURN gpa;
END; -- Function CALC_AVG

Call it for every distinct student# using:

select calc_avg(student),a.student from 
(select distinct STUDENT# student from enrollment) a


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


Hi, Could any one show me how to write the following
function?  Thank you very, very much!  

The GPA Function

1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.

2.Repeat_delete Policy: A student may repeat a course
as many times as he
wants. However, if the first grade he receives on this
course is a D or F,
then the second grade will automatically replaces the
first grade, and the
first enrollment will not go into his GPA calculation.
Under any other
circumstances, his grades will be considered as a
regular grade and be
taken into consideration for GPA.

create table Enrollment(
Student# NUMBER (7),
SNUM NUMBER (5),
Call# NUMBER (7),
Semester char (8),
GRADE char (3),
Credit number,
Withdraw_Date Date);

SNUM + Call# represents one class.

 Insert into Enrollment
values('58001','111','70070','Sp2000','F',3, null);
Insert into Enrollment
values('58001','111','70070','Fa2000','B',3, null);
Insert into Enrollment
values('58003','222','70070','Sp2000','A',2, null);
Insert into Enrollment
values('58004','333','80025','Fa2000','A',2, null);
Insert into Enrollment
values('58005','222','80025','Fa2000','C',3, null);




__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-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: Anybody heard Oracle will remove the JVM from Oracle in future re


2001-12-03

Thread
Scott Shafer


Haven't heard myself, but I hope this is true.  Please, please, please
let it be true!

--Scott


"Khedr, Waleed" wrote:
> 
> Thanks,
> 
> Waleed

_
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: HP-UX 11/8.1.7/Recovery


2001-12-03

Thread
Deepak Thapliyal


Michael

i remember (long time back) they had released a new
command called as "alter database .. end backup"" or
somethin in 7.3.. maybe this is the default behaviour
in later releases including 817

Deepak
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
wrote:
> Hi All!
> 
> We had an interesting sequence of events last night,
> and I was 
> hoping somebody could tell me if what we saw was
> what should've 
> happened.  Clear?  As mud?  Ok...
> 
> System is up and running.
> The backup process starts, and puts the datafiles in
> backup mode.
> The system crashes.  Hard.  Memory fault.
> When the database comes back up, it successfully
> performs media
> recovery and pronounces itself OK.
> We check, and the datafiles are NOT in backup mode.
> 
> So we're wondering...does media recovery take the
> datafiles out
> of backup mode automatically?  Can you point me to a
> doco on this?
> 
> Thanks,
> Mike
> 
> ---
>
===
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
> (909) 914-2304
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Vergara, Michael (TEM)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.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: killing system user


2001-12-03

Thread
Deepak Thapliyal


yeah Jared, i will look at it. C i am wondering that
if the SID is sufficient to gaurentee uniqueness ..
why does oracle need the serial# as well?? 

or maybe there is a scheduled maintainance window at
this time inside of my head ;)

Thx anyhu ;)

Deepak


--- [EMAIL PROTECTED] wrote:
> 
> Deepak,
> 
> To be quite honest, I can't remember.  I'm like that
> with details
> sometimes.
> I tend to forget them, though I remember the reason
> I learned them in
> the first place.  :)
> 
> This is on MetaLink somewhere if you care to look
> for it.  I really
> can't do that now.  It's back to the grindstone for
> me.
> 
> The grindstone in this case being iFS 1.1.9.  Ah the
> joy of
> troubleshooting.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
>  
> Deepak Thapliyal
> 
>  
>  Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> YAHOO.COM>  cc: 
> 
>  
> Sent by:Subject:
> Re: killing system user 
>  
> [EMAIL PROTECTED]
> 
>  
> 
> 
>  
> 
> 
>  
> 12/03/01 09:55 AM   
> 
>  
> Please respond to   
> 
>  
> ORACLE-L
> 
>  
> 
> 
>  
> 
> 
>  
> 
> 
> 
> 
> Hi Jared
> 
> why does the serial# have to change due to rollback?
> lots of us would be curious for a brief expln ...
> 
> Thx
> Deepak
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> >
> > The session is rolling back, you can't kill it.
> >
> > This is why the serial# is changing.
> >
> > The following query can be used to track its
> > progress.
> >
> > select s.osuser
> >   ,s.username
> >   ,s.sid
> >   ,r.segment_name
> >   ,t.space
> >   ,t.recursive
> >   ,t.noundo
> >   ,t.used_ublk
> >   ,t.used_urec
> >   ,t.log_io
> >   ,t.phy_io
> >   ,substr(sa.sql_text,1,200) txt
> > from v$session s,
> >  v$transaction t,
> >  dba_rollback_segs r,
> >  v$sqlarea sa
> > where s.taddr=t.addr
> > and   t.xidusn=r.segment_id(+)
> > and   s.sql_address=sa.address(+);
> >
> > Jared
> >
> >
> > On Sunday 02 December 2001 22:55, Tatireddy,
> > Shrinivas (MED, Keane) wrote:
> > > Hi lists,
> > >
> > > Solaris 2.7
> > > oracle 8i
> > >
> > > I have a session "SYSTEM" doing import into a
> > table. (logged into server
> > > thru telnet from win 98 PC)
> > >
> > > Suddenly the power outage occurred to my PC.
> > >
> > > When I logged into the server thru telnet, I
> found
> > that the session is
> > > active.
> > > By mistake, I killed the process at o/s level.
> > >
> > > For somereasons,I tried to drop the table. But I
> > failed to do it, as it
> > > is locked by import process.
> > >
> > > I tried to kill the user "SYSTEM". But the
> oracle
> > is giving  error that
> > > there is not user with such sid and serial
> number.
> > >
> > > The serial# number is often getting changed when
> I
> > query from v$session.
> > >
> > > Is there a way to kill this user, without
> shutting
> > down the database.
> > >
> > > And why different serial# number each time, I
> > query v$SESSION.?
> > >
> > > Any clues?
> > >
> > > Thnx and Regards,
> > >
> > > Srinivas
> > --
> > 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
> 
> 
> 
> 
> 
> -- 
> 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
>




Anybody heard Oracle will remove the JVM from Oracle in future re


2001-12-03

Thread
Khedr, Waleed


Thanks,

Waleed
-- 
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: deleting duplicate records


2001-12-03

Thread
Jack C. Applewhite




Sunil,
 
If there are multiple 
duplicates for even a few SKU_Num values, you're doing multiple scans (full 
table or full index) to get all the dups out.  You might reconstruct the 
SQL to not use a looping construct if there are lots of duplicate rows for each 
SKU_Num
 
Delete From 
FMS_Test
Where ( SKU_Num, RowID ) 
In
(
 Select SKU_Num, 
RowID
 From   
FMS_Test
 Minus
 Select SKU_Num, Max ( 
RowID )
 From   
FMS_Test
 Group By 
SKU_Num
) ;
 
Or keep the loop and add a 
Commit right after the Delete statement - that will cut down on Rollback segment 
usage.
 
Is there an index on the column 
sku_num?  It would probably help as well.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, December 03, 2001 3:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  deleting duplicate records
  Hello all,
   
  could someone please tell me why the procedure 
  below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 
  21 mins on a table with 235,000 rows??
   
  i have created a bigger rollback segment to take care of 
  this, but no improvement.where should i be looking for 
  bottlenecks??
   
  CREATE PROCUDURE DUPES_DEL ASBEGIN
   
   LOOP DELETE from fms_test where 
  row_id in(select min(rowid)   from 
  fms_test   group by sku_num   having 
  count (*) >1);  EXIT WHEN SQL%NOTFOUND END 
  LOOP;COMMIT;END;
   
  appreciate it.Sunil NookalaDellCorp.Austin, 
  TX





RE: SQL Loader Commit Point?


2001-12-03

Thread
Jack C. Applewhite


Ken,

Check the Loader log file.  The records are being rejected for some reason
and Loader only tells you in the log.

Jack


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


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


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.

-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

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

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

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






Re: Corrupted data blocks in tablespace SYSTEM


2001-12-03

Thread
Stephane Faroult


Kevin Bass wrote:
> 
> I have attempted a full export and received the following message:
> 
> [/u03] $ exp system/ full=y rows=y file=full.dmp
> 
> Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001
> 
> (c) Copyright 1998 Oracle Corporation.  All rights reserved.
> 
> Connected to: Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> Export done in US7ASCII character set and US7ASCII NCHAR character set
> 
> About to export the entire database ...
> . exporting tablespace definitions
> . exporting profiles
> . exporting user definitions
> . exporting roles
> . exporting resource costs
> . exporting rollback segment definitions
> . exporting database links
> . exporting sequence numbers
> . exporting directory aliases
> . exporting foreign function library names
> EXP-8: ORACLE error 1578 encountered
> ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
> ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
> 
> Since the corruption resides in the SYSTEM tablespace, it seems that the
> course of action that should be taken is to re-create the database.
> 
> Kevin L. Bass
> Database Administrator
> Americal Corporation
> (252) 762-2199 x2144

Unfortunately, it looks like it. But perhaps you can recover your data
by exporting on a per something basis, 'something' being either owner or
tables or whatever, just trying to circle around the problem. Which is
why you should check dba_extents (somebody posted the query). It will
tell you which table is screwed up, and you may be able to use an export
function which does NOT export what is held in this table. You have good
blocks around the bad one, the problem is to tread carefully around.
Kind of minefield with a single mine in it. Of course no need to do this
kind of thing if you have a reasonably recent backup and do not care too
much about the transactions you might lose.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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






SQL Loader Commit Point?


2001-12-03

Thread
Ken Janusz


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
 
-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

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

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

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






RE: Message at the start of svrmgrl


2001-12-03

Thread
Koivu, Lisa

Title: RE: Message at the start of svrmgrl





Did you trace the statement?  Send a trace to the list.  


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Message at the start of svrmgrl


Hello all,
 
could someone please tell me why the procedure below (Author:Nick Butcher) takes less than a minute on
a table with 50,000 rows and about 21 mins on a table with 235,000 rows??
 
I have created a bigger rollback segment to take care of this, but no improvement.
where should i be looking for bottlenecks??
 


CREATE PROCUDURE DUPES_DEL  AS
BEGIN
 
 LOOP
 DELETE from fms_test
 where row_id in(select min(rowid)
   from fms_test
   group by sku_num
   having count (*) >1);
  EXIT WHEN SQL%NOTFOUND
 END LOOP;
  
  COMMIT;
END;
 


appreciate it.
Sunil Nookala
DellCorp.
Austin, TX








RE: FIRST_ROWS vs. ALL_ROWS


2001-12-03

Thread
Carle, William T (Bill), NLCIO


Hello again,

I want to thank everyone for responding to my query. I have a much
better understanding of how this works now. I changed my query to remove the
"rownum < 5" and the query returned 344066 rows. The output of the tkprof is
below:

FIRST_ROWS

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.01   0.01  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch22939 29.99 145.98  424882708970  0
344066


ALL_ROWS

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.01   0.01  0  0  0
0
Execute  2  0.01   0.00  0  0  2
0
Fetch22939 49.33 474.71 221733 803265   3086
344066

It still seems like it takes much longer in the ALL_ROWS case, but the
value in the query column is much less; however, the values in the disk and
current columns are much bigger. When I actually ran it and put the output
into a file, the FIRST_ROWS case took 1:17 minutes and the ALL_ROWS case
took 8:53 minutes. 


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
Rao, Maheswara


Sangeetha,

1. During creation of tablespace, if you make it online, then, tablespace is
available for use immediately after its creation.  Otherwise (offline), you
need to issue a separate statement making the tablespace online after
tablespace is created.

2. Yes. You could store two different users objects in the same tablespace
and datafile.  Basically, a tablespace contains some datafiles.  Users are
assigned to the tablespace ( I mean users are granted space quota privileges
on the tablespace).

3. No.  Two tablespaces cannot contain the same datafile.

a bit of advice:  Please read Oracle concepts Vol.1.  It would clarify most
of your doubts on these tablespaces and datafiles.

Rao



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


hi,

 what is the exact use of making the 'status' online
or offline at the time of creation of tablespace.

can objects of two diff users be stored in the same
tablespace and datafile.

can two tablespaces contain the same  datafile .

thanx in advance
sangeetha

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

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

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






deleting duplicate records


2001-12-03

Thread
Sunil_Nookala




Hello all,
 
could someone please tell me why the procedure 
below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21 
mins on a table with 235,000 rows??
 
i have created a bigger rollback segment to take care of this, 
but no improvement.where should i be looking for bottlenecks??
 
CREATE PROCUDURE DUPES_DEL ASBEGIN
 
 LOOP DELETE from fms_test where row_id 
in(select min(rowid)   from 
fms_test   group by sku_num   having count 
(*) >1);  EXIT WHEN SQL%NOTFOUND END 
LOOP;COMMIT;END;
 
appreciate it.Sunil NookalaDellCorp.Austin, 
TX





Recall: Message at the start of svrmgrl


2001-12-03

Thread
Sunil_Nookala


Nookala, Sunil would like to recall the message, "Message at the start of
svrmgrl".
-- 
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: Message at the start of svrmgrl


2001-12-03

Thread
Sunil_Nookala




Hello all,
 
could someone please tell me why the procedure below (Author:Nick Butcher) takes less than a 
minute ona table with 50,000 rows 
and about 21 mins on a table with 235,000 rows?? 
I have created a 
bigger rollback segment to take care of this, but no improvement.where 
should i be looking for bottlenecks??
 
CREATE PROCUDURE DUPES_DEL  ASBEGIN
 
 LOOP DELETE from fms_test where row_id 
in(select min(rowid)   from 
fms_test   group by sku_num   having count 
(*) >1);  EXIT WHEN SQL%NOTFOUND END 
LOOP;COMMIT;END;
 
appreciate it.Sunil NookalaDellCorp.Austin, 
TX





RE: Corrupted data blocks in tablespace SYSTEM


2001-12-03

Thread
Koivu, Lisa

Title: RE: Corrupted data blocks in tablespace SYSTEM





Kevin, 


Try exporting your schema owners (code, tables, etc.) as a CYA.  When you recreate the db, you can import each schema separately.  A pain, but it will save you.

Lisa


-Original Message-
From:   Kevin Bass [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Corrupted data blocks in tablespace SYSTEM


I have attempted a full export and received the following message:


[/u03] $ exp system/ full=y rows=y file=full.dmp


Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001


(c) Copyright 1998 Oracle Corporation.  All rights reserved.



Connected to: Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set


About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
EXP-8: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'  



Since the corruption resides in the SYSTEM tablespace, it seems that the
course of action that should be taken is to re-create the database.



Kevin L. Bass
Database Administrator
Americal Corporation
(252) 762-2199 x2144



-Original Message-
Sent: Monday, December 03, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L



> Kevin Bass wrote:
> 
> I have just started a project and have encountered a database problem.
> The previous DBA did not create any backup scripts or backup and
> recovery plans. Is there a way to get around this problem without
> re-creating the database?
> 
> 
> When executing my script to get corrupted data block information , I
> get the following:
> ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
> ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
> 


Kevin,


   Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,


Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]


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

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


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

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


2001-12-03

Thread
Rao, Maheswara


William,

Thanks for the update.

Rao

-Original Message-
Sent: Monday, December 03, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L


Rao, Maheswara wrote:

>Tom,
>
>Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
>best way, I found is, copy both the cd's onto two different locations on
the
>disk.  Then start the installation.  Once, the first file is over, it asks
>you for the second CD.  Then, you give the file path where you copied the
>second cd.
>
>Rao
>
as long as you start the runInstaller from a directory other than 
/cdrom, you can change the CD when it asks you to.  i've done it for 
8.1.7 and 9iAS with no problems.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

This message transmitted on 100% recycled electrons.




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

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

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

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

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


2001-12-03

Thread
Mohan, Ross


WOW ( or should I say "OOW") it's like a
List of Oracle HeavyHitters and Cognoscenti. 



-Original Message-
Sent: Monday, December 03, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):

Location: Chevy's at Howard and 3rd. 
Time: 7pm onwards at the bar, sit down at 8pm
Contact: Gerardo Molina/John Kanagaraj (table booked in Gerardo's name)

1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo Molina
4. Jeremiah Wilton
5. John Kanagaraj
6. Greg Loughmiller (?)
7. Gaja Vaidyanatha (?)
8. Ari Kaplan
9. Steve Orr (Welcome back to the Bay Area, Steve!)
10. K Gopalakrishnan (?)
11. Vivek Sharma (?)

Please call me at 408-315-0842 - the on-call cell that is always with the me
this entire week :( in case you want to get in touch with the group at the
last minute.

Thanks,
John Kanagaraj
DBSoft at Hitachi Data Systems
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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






RE: rman restore & arclogs


2001-12-03

Thread
Koivu, Lisa

Title: RE: rman restore & arclogs





Interesting.  Does rman ever get confused during a restore or does it just grab the most convenient backup set with the required archive logs on it? I don't suppose you can parallel restore your arclogs from different files/tapes?  (There goes that monkey again)

Thanks for your response Jim.
Lisa 


-Original Message-
From:   HAWKINS, JAMES W [IT/1000] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: rman restore & arclogs


I just wanted to throw something else out there - it may have already come up though.  We backup the archivelogs first without deleting them, and then immediately backup another set with the "delete" specified.  Obviously, this is because anything can happen to that first set (corruptions, etc.), and if that's your only set, then you're screwed.  The chances of the same archivelog being corrupt in both sets is very low (unless the source archivelog is corrupted), but at least you are protected against all the copy errors.  Also, it's very probable (for us, anyway) that each copy of the archivelog will be on different physical tapes, which in itself is important to us since operations is outsourced ; )

 
Jim
 


__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise 


Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797 


[EMAIL PROTECTED] 


-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman restore & arclogs


Lisa,
 
I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand).

 
The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery.  If you did remove them by hand, Rman may complain that it was expecting them and did not find them.  Did you try this - remove one that was restored by the recovery process and then tried a backup?

 
Depending on the kind of restore you do  - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an "open db reset logs", while a full restore could still use these again).

 
Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently!

 
Good Luck!


Tom Mercadante
Oracle Certified Professional 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject: rman restore & arclogs




Good morning all - 


I've been practicing rman restores.  It's a lot easier than I originally thought.  I've noticed that when you restore and the arclogs are needed, it restores them.  Which is expected.  However, when I take another backup, these arclogs are included in the backup set.  This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery?  I can verify what arclogs are where in the backup sets with a report.  

Any comments are appreciated.  Thanks 


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








RE: Message at the start of svrmgrl


2001-12-03

Thread
Anand Prakash




Mike
 
I found a note on metalink (124568.1) which explains the 
reason. Oracle 8.1.7.x products are not supported on chip prior to 
EV56.
 
Thanks.
Anand Prakash
 
>>> [EMAIL PROTECTED] 12/03/01 12:40PM 
>>>
Anand,
 
I installed the same(? 
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this 
result.  However, I do remember this kind of result with a earlier upgrade 
to 8.0.x in the distant past.  I believe it is a verbose linking option 
with no negative impact.  Is svrmgrl the only executable responding like 
this.  If so, try relinking.
 
Mike Hand
Polaroid 
Corp.

  -Original Message- 
   
  I have just done installation of 8.1.7.0 
  on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no 
  installation errors. When I start svrmgrl I see a line "inst emulated 
  pid=175364...".
   
  -->$ svrmgrlinst emulated pid=175364 
   va=0x11fffa358 pc=0x1205c0148 
  inst=0x327e0028
   
  Oracle Server Manager Release 3.1.7.0.0 - 
  Production
   
  Copyright (c) 1997, 1999, Oracle Corporation.  All 
  Rights Reserved.





RE: Message to Session Users - How's it done in your org ?


2001-12-03

Thread
Guidry, Chris


On NT LAN use the "NET SEND" command.
You can send to individual user names or domain wide
or to those that have connections to the server.
HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


> -Original Message-
> From: Robert Chin [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, December 02, 2001 07:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Message to Session Users - How's it done in your org ?
> 
> In our current environment, we have the need to be able to
> send LAN pop-up message to users of ACTIVE Oracle sessions.
> ("Pls log out NOW !...", "Pls don't do any x transactions..." etc you get
> the idea)
> 
> If your organization have similar need.
> Do you know how it's done in your organization ?
> Pls specify the infrastructure (whether it's via Internet or LAN and the
> OS)
> 
> Thanks
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robert Chin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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






Reminder: Listers meeting at OOW


2001-12-03

Thread
John Kanagaraj


Hi all,

Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):

Location: Chevy's at Howard and 3rd. 
Time: 7pm onwards at the bar, sit down at 8pm
Contact: Gerardo Molina/John Kanagaraj (table booked in Gerardo's name)

1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo Molina
4. Jeremiah Wilton
5. John Kanagaraj
6. Greg Loughmiller (?)
7. Gaja Vaidyanatha (?)
8. Ari Kaplan
9. Steve Orr (Welcome back to the Bay Area, Steve!)
10. K Gopalakrishnan (?)
11. Vivek Sharma (?)

Please call me at 408-315-0842 - the on-call cell that is always with the me
this entire week :( in case you want to get in touch with the group at the
last minute.

Thanks,
John Kanagaraj
DBSoft at Hitachi Data Systems
-- 
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: Quick Question on hotbackup


2001-12-03

Thread
Rao, Maheswara


Seema,

You do not need to switch current log file at the beginning of your job.
You switch the log file before taking the copy of archive log files.

Generally, listener and tnsnames files copy is not required. 

Overall the steps you outlined are ok.  But remember at every step to check
for the success or failure of your step  before proceeding with the next
step.

If you are trying to write the script in Unix, I suggest the following
additional things.

1. Before starting the hot backup job, check whether the db is up or not. If
the db is not up, then abort the job and send a mail to the Daring Boys All
(DBAs).

2. Before putting a tablespace in the hot backup mode, check whether the
tablespace is already in hot backup mode.  This could happen if another DBA
is doing hot backup on the same tablespace.

3. After copying the datafile, do unix compare. If it fails, then abort the
job and send a mail to DBA.

4. Also after copying the archive log files, you need to delete the archive
logs. Else, your archive log space would keep increasing.

5. Once all the tablespaces and archive logs are copied, it is a good
practice to compress these files.

Rao 

-Original Message-
Sent: Monday, December 03, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L


Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to 
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and passwd file
-All archive log files
Is any things missing in this list?
Thanks
-Seema

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

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

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


2001-12-03

Thread
Kevin Bass


I have attempted a full export and received the following message:

[/u03] $ exp system/ full=y rows=y file=full.dmp

Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001

(c) Copyright 1998 Oracle Corporation.  All rights reserved.


Connected to: Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
EXP-8: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'  


Since the corruption resides in the SYSTEM tablespace, it seems that the
course of action that should be taken is to re-create the database.


Kevin L. Bass
Database Administrator
Americal Corporation
(252) 762-2199 x2144


-Original Message-
Sent: Monday, December 03, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L


> Kevin Bass wrote:
> 
> I have just started a project and have encountered a database problem.
> The previous DBA did not create any backup scripts or backup and
> recovery plans. Is there a way to get around this problem without
> re-creating the database?
> 
> 
> When executing my script to get corrupted data block information , I
> get the following:
> ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
> ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
> 

Kevin,

   Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

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

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


2001-12-03

Thread
Rao, Maheswara


Tom,

Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
best way, I found is, copy both the cd's onto two different locations on the
disk.  Then start the installation.  Once, the first file is over, it asks
you for the second CD.  Then, you give the file path where you copied the
second cd.

Rao

-Original Message-
Sent: Monday, December 03, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


All,

I have the install disks for 8.1.7 for Sun SPARC Solaris.  

Are these disks (2 of them) the same for Sun 64bit?

I looked on TechNet, and I do not see any other 817 release for Sun.

I do see, however, 64 bit for Oracle for 9i.

Thanks!

Tom Mercadante
Oracle Certified Professional

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

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

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


2001-12-03

Thread
Ruth Gramolini


When you have finished the restore and open the database with resetlogs, all
of the old archivelogs are toast anyway.  Just delete them!

You can manually delete any orphaned backupsets.  If a backup fails then you
need to redo it until in completes so that it will be recorded in the
catalog and be usable for restore/recovery.

It really is that easy.  Just a little getting used to, like being pregnant,
not bad but different.( I hope your pregnancy is going well.)  Any
discomfort will be forgotten when you see the results.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 2:26 PM


> Hi Ruth, thanks so much for responding.
>
> Yes, I wrote the scripts to do an arclog backup delete.  I'm concerned
about
> the arclogs hanging around after a restore and taking up disk space, along
> with unnecessarily inflating the size of my backup files.  (I'm testing
> backup to disk right now)
>
> It's more of a nice to know, not necessary.  I'm seeing some weird stuff
> that I didn't expect and the monkey in me wants to know why...  No, not
the
> baby :)  Here's some other odd behavior I've seen:
>
> 1.  Instance failure during a backup leaves the rman files intact but the
> backup itself is not reflected in the catalog.  The database recovers
nicely
> from this since no tablespaces are in hotbackup mode (yes)  The
end
> result is "orphan" rman files that the catalog knows nothing about.
>
> 2.  Initially these files are created the size of all datafiles combined.
> As the backup progresses, the size of the files shrink down considerably.
> For example, I allocate 3 channels to disk and setsize to 2GB, but the
files
> start out at 1.5GB and shrink down to ~500 MB.   I wonder if that behavior
> happens on tape?  Anyone?  I'll be able to test this later this week.
>
> 3.  Can restore and recovery really be this easy?  Sheesh
>
> Thanks again for your response.  And list, please correct me if I am wrong
> on any of this.
>
> yours in Monkeying Around,
> Lisa
>
> > -Original Message-
> > From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, December 03, 2001 1:17 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: rman restore & arclogs
> >
> > Lisa,
> >
> > We backup all archivlogs with the backup set and delete them. Delete is
an
> > rman option when you backup archivelogs.  We don't have room to keep
them.
> > It is a bit of a pain to restore them but you learn to live with it.
> >
> > Have a look at rman's tables and views. You should be able to query them
> > and
> > get what you want.
> >
> > Yours in rman,
> > Ruth
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Monday, December 03, 2001 10:30 AM
> >
> >
> > > Good morning all -
> > >
> > > I've been practicing rman restores.  It's a lot easier than I
originally
> > > thought.  I've noticed that when you restore and the arclogs are
needed,
> > it
> > > restores them.  Which is expected.  However, when I take another
backup,
> > > these arclogs are included in the backup set.  This is unnecessary in
my
> > > opinion and makes my backup files larger than they need to be.
> > >
> > > Is it standard practice to just delete the arclogs that were already
in
> > a
> > > backup set prior to taking the immediate backup after a recovery?  I
can
> > > verify what arclogs are where in the backup sets with a report.
> > >
> > > Any comments are appreciated.  Thanks
> > >
> > > Lisa Koivu
> > > Oracle Database Monkey
> > > Fairfield Resorts, Inc.
> > > 954-935-4117
> > >
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>

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

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

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



Re: killing system user


2001-12-03

Thread
Jared . Still



Deepak,

To be quite honest, I can't remember.  I'm like that with details
sometimes.
I tend to forget them, though I remember the reason I learned them in
the first place.  :)

This is on MetaLink somewhere if you care to look for it.  I really
can't do that now.  It's back to the grindstone for me.

The grindstone in this case being iFS 1.1.9.  Ah the joy of
troubleshooting.  :)

Jared




   

Deepak Thapliyal   


YAHOO.COM>  cc:

Sent by:Subject: Re: killing system user   

[EMAIL PROTECTED]   

   

   

12/03/01 09:55 AM  

Please respond to  

ORACLE-L   

   

   





Hi Jared

why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...

Thx
Deepak
--- Jared Still <[EMAIL PROTECTED]> wrote:
>
> The session is rolling back, you can't kill it.
>
> This is why the serial# is changing.
>
> The following query can be used to track its
> progress.
>
> select s.osuser
>   ,s.username
>   ,s.sid
>   ,r.segment_name
>   ,t.space
>   ,t.recursive
>   ,t.noundo
>   ,t.used_ublk
>   ,t.used_urec
>   ,t.log_io
>   ,t.phy_io
>   ,substr(sa.sql_text,1,200) txt
> from v$session s,
>  v$transaction t,
>  dba_rollback_segs r,
>  v$sqlarea sa
> where s.taddr=t.addr
> and   t.xidusn=r.segment_id(+)
> and   s.sql_address=sa.address(+);
>
> Jared
>
>
> On Sunday 02 December 2001 22:55, Tatireddy,
> Shrinivas (MED, Keane) wrote:
> > Hi lists,
> >
> > Solaris 2.7
> > oracle 8i
> >
> > I have a session "SYSTEM" doing import into a
> table. (logged into server
> > thru telnet from win 98 PC)
> >
> > Suddenly the power outage occurred to my PC.
> >
> > When I logged into the server thru telnet, I found
> that the session is
> > active.
> > By mistake, I killed the process at o/s level.
> >
> > For somereasons,I tried to drop the table. But I
> failed to do it, as it
> > is locked by import process.
> >
> > I tried to kill the user "SYSTEM". But the oracle
> is giving  error that
> > there is not user with such sid and serial number.
> >
> > The serial# number is often getting changed when I
> query from v$session.
> >
> > Is there a way to kill this user, without shutting
> down the database.
> >
> > And why different serial# number each time, I
> query v$SESSION.?
> >
> > Any clues?
> >
> > Thnx and Regards,
> >
> > Srinivas
> --
> 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





-- 
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: Oracle for Sun/64 Bit Question


2001-12-03

Thread
Thater, William


Rao, Maheswara wrote:

>Tom,
>
>Yes.  Oracle 817 comes in two disks.  Installation is little tricky.  The
>best way, I found is, copy both the cd's onto two different locations on the
>disk.  Then start the installation.  Once, the first file is over, it asks
>you for the second CD.  Then, you give the file path where you copied the
>second cd.
>
>Rao
>
as long as you start the runInstaller from a directory other than 
/cdrom, you can change the CD when it asks you to.  i've done it for 
8.1.7 and 9iAS with no problems.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

This message transmitted on 100% recycled electrons.




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

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

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


2001-12-03

Thread
Koivu, Lisa

Title: RE: FIRST_ROWS vs. ALL_ROWS





Hi Bill, 


It's been a while since I messed with the optimizer but I'll take a stab.  


FIRST_ROWS is for something like forms, where returning something quickly, even if it is just a few rows, is important.  

ALL_ROWS is meant for throughput.  The execution plan for ALL_ROWS looks like something you may see in a data mart/warehouse.  (I have rarely seen the STAR join actually work.)  Remember in dm/dw split-second reports are not realistic.  

What type of app is this?  How fresh are your stats?  When was the last time you deleted stats and re-analyzed?  Any histograms?  There are a ton of things to take into account here.  

Anyway I hope I helped somehow. 


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



-Original Message-
From:   Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject:    FIRST_ROWS vs. ALL_ROWS


        Howdy,


            I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
determined the query was not using the indexes I thought it should. When I
changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
to minimize total execution time. I'm trying to figure out the difference.
Using FIRST_ROWS, this is the output from tkprof:


        select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
        r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
        rs.terminatingclli from routingassignmentpersistent ra,
        route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
        C' and networksubtype
        = 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
        r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID =
rs.objid
        and rownum < 5 and ra.startdate is not null


        call count   cpu    elapsed   disk  query
current    rows
        --- --   -- -- --
--  --
        Parse    1  0.00   0.01  0  0
0   0
        Execute  1  0.00   0.00  0  0
0   0
        Fetch    2  0.00   0.00  0 35
0   4
        --- --   -- -- --
--  --
        total    4  0.00   0.01  0 35
0   4


        Misses in library cache during parse: 1
        Optimizer goal: FIRST_ROWS
        Parsing user id: 29  (NTOPBIG)


        Rows Row Source Operation
        ---  ---
          4  COUNT STOPKEY
          4   NESTED LOOPS
          4    NESTED LOOPS
          2 NESTED LOOPS
          1  TABLE ACCESS BY INDEX ROWID
ROUTINGASSIGNMENTPERSISTENT
          1   INDEX RANGE SCAN (object id 16976)
          2  TABLE ACCESS BY INDEX ROWID ROUTE
          2   INDEX RANGE SCAN (object id 16962)
          5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
          5  INDEX RANGE SCAN (object id 16971)
4   TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
                7 INDEX UNIQUE SCAN (object id 16965)



                Rows Execution Plan
                ---
---
                  0  SELECT STATEMENT   GOAL: FIRST_ROWS
                  4   COUNT (STOPKEY)
                  4    NESTED LOOPS
                  4 NESTED LOOPS
                  2  NESTED LOOPS
                  1   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
    
'ROUTINGASSIGNMENTPERSISTENT'
                  1    INDEX   GOAL: ANALYZED (RANGE
SCAN) OF
    
'IX_ROUTINGASSIGNMENTPERSIST5' (NON-UNIQUE)
                  2   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
                  'ROUTE'
                  2    INDEX   GOAL: ANALYZED (RANGE
SCAN) OF 'IX_ROUTE4'
                   (NON-UNIQUE)
                  5  TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
                



RE: Doubts reg :Export and import


2001-12-03

Thread
Jared . Still




Mark,

With an LMT using UES of 100M, you will get 5 extents.

Jared



   
 
"Mark Leith"   
 

ls.co.uk>cc:   
 
Sent by: Subject: RE: Doubts reg :Export and 
import 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/03/01 02:50 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..

When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to
5
extents of 100Mb - or one of 500Mb?

My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)

Cheers

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L


If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:
>
> Another one that apparently has access to e-mail but not to the
internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
> read e-mails but cannot read FM etc.
>
> Alex Hillman
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exportingwill this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Alex Hillman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-505



RE: rman restore & arclogs


2001-12-03

Thread
HAWKINS, JAMES W [IT/1000]

Title: rman restore & arclogs



I just 
wanted to throw something else out there - it may have already come up 
though.  We backup the archivelogs first without deleting them, and then 
immediately backup another set with the "delete" specified.  Obviously, 
this is because anything can happen to that first set (corruptions, etc.), and 
if that's your only set, then you're screwed.  The chances of the same 
archivelog being corrupt in both sets is very low (unless the source archivelog 
is corrupted), but at least you are protected against all the copy errors.  
Also, it's very probable (for us, anyway) that each copy of the archivelog will 
be on different physical tapes, which in itself is important to us since 
operations is outsourced ; )
 
Jim
 
__ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise 
Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri  63167 Work  (314) 
694-4417 Cellular (314) 724-9664 Pager (314) 
294-9797 
[EMAIL PROTECTED] 

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
  12:56 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: rman restore & arclogs
  Lisa,
   
  I 
  guess I'm lazy (or cautious) in that I would allow the first backup to take 
  this archive log files back to tape where they belong, rather than determine 
  (by running reports) which log files I may delete (by 
  hand).
   
  The 
  cautious part of me says that if Rman decided to back these monkeys up within 
  the first save set after the recovery, it may have decided that it needs them 
  for a future recovery.  If you did remove them by hand, Rman may complain 
  that it was expecting them and did not find them.  Did you try this - 
  remove one that was restored by the recovery process and then tried a 
  backup?
   
  Depending on the kind of restore you do  - a 
  full, or a point in time - the archivelog may be of no use anyway (a point in 
  time makes them invalid because you had to perform an "open db reset logs", 
  while a full restore could still use these again).
   
  Glad 
  you are at least experimenting with the tool before you put it in production - 
  it actually is fun to do a restore as it happens so 
  infrequently!
   
  Good 
  Luck!
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
10:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: rman restore & arclogs
Good morning all - 
I've been practicing rman restores.  It's a lot 
easier than I originally thought.  I've noticed that when you restore 
and the arclogs are needed, it restores them.  Which is expected.  
However, when I take another backup, these arclogs are included in the 
backup set.  This is unnecessary in my opinion and makes my backup 
files larger than they need to be. 
Is it standard practice to just delete the arclogs 
that were already in a backup set prior to taking the immediate backup after 
a recovery?  I can verify what arclogs are where in the backup sets 
with a report.  
Any comments are appreciated.  Thanks 
Lisa Koivu Oracle 
Database Monkey Fairfield Resorts, Inc. 
954-935-4117 






Re: DISPLAY under AIX 4.3.3, was Fwd: urgent!!


2001-12-03

Thread
Jared . Still




1. ping fbsrv to make sure the host can be found

2. it should be 'export DISPLAY', not 'export $DISPLAY'

3. make sure that an X server is running on fbsrv

how to test this varies from system to system.  If you
log on to the box in a graphical environment, then
X is running.

HTH

Jared





   
 
Jonathan   
 
Gennick  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
 Subject: DISPLAY under AIX 4.3.3, was 
Fwd: urgent!!
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
12/01/01 08:20 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Normally I don't forward reader emails that I receive, but
in this case the problem seems to be urgent. Is there anyone
using AIX on this list that might have a solution for Alex

--
Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

Saturday, December 01, 2001, 12:16:24 AM, [EMAIL PROTECTED] wrote:
Sir,

We are installing Oracle 8i under AIX 4.3.3 but we encounter DISPLAY
variable error.
It read something like 'Can't connect to fbsrv server as the value of
DISPLAY variable. We followed the Oracle manual
by defining DISPLAY=fbsrv:0.0 and enter the command export $DISPLAY. We
also tried xhost +fbsrv command, but still we encountered the same error.

What shall we do? We need your help.

Thanks,

Alex Almendras

Energy Development Corp. - Philippines.

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

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

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






Quick Question on hotbackup


2001-12-03

Thread
Seema Singh


Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to 
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and passwd file
-All archive log files
Is any things missing in this list?
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: rman restore & arclogs


2001-12-03

Thread
Koivu, Lisa

Title: RE: rman restore & arclogs





Thanks Tom.  I did try removing the arclogs and then running a backup - no complaints.  The arclogs in question were still present in the catalog via past backups.   I'm guessing this is because the last scn of the last backup was larger than the scn's included in the arclogs in question.  

However, a crosscheck report caused failure for all those logs.  Not a big deal, but once this all goes into production I want to see all my reports & lists sent to me every day with no "FAILURE" or anything of that nature in it.  Erring conservative is probably better anyway, unless i'm really tight on disk.  

Restoring is kinda fun :)  I take that back, being a dba is kinda fun.  Once I actually got to start doing it, that is.  



-Original Message-
From:   Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: rman restore & arclogs


Lisa,
 
I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand).

 
The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery.  If you did remove them by hand, Rman may complain that it was expecting them and did not find them.  Did you try this - remove one that was restored by the recovery process and then tried a backup?

 
Depending on the kind of restore you do  - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an "open db reset logs", while a full restore could still use these again).

 
Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently!

 
Good Luck!


Tom Mercadante
Oracle Certified Professional 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject: rman restore & arclogs




Good morning all - 


I've been practicing rman restores.  It's a lot easier than I originally thought.  I've noticed that when you restore and the arclogs are needed, it restores them.  Which is expected.  However, when I take another backup, these arclogs are included in the backup set.  This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery?  I can verify what arclogs are where in the backup sets with a report.  

Any comments are appreciated.  Thanks 


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








RE: _delete_me=true


2001-12-03

Thread
April Wells


NO, no no... it is Holy Unsubscribe Batman!



-Original Message-
Sent: Monday, December 03, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L


Gee, how do I unsubscribe?  Oh-yeah!  Its at the bottom of every piece of
mail!!!  
Holy Cow BatMan!

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


-Original Message-
Sent: Monday, December 03, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Does he think - UNSUBSCRIBE?

:-))
On Mon  3. December 2001 18:55, you wrote:
> _delete_me=true
>
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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


2001-12-03

Thread
Larry Elkins


Bill,

Besides statistics and how they are gathered, and other information, there
are numerous parameters that influence the CBO and it's decisions. And just
to clarify, you said the query ran in under a second when using FIRST_ROWS
(and thus a nested loops indexed lookup approach if possible). And you had a
"rownum < 5" in there so I don't doubt it. Would you normally have that
"stopkey" in there?

The reason I ask is that when a nested loops approach is used (and you
aren't ordering on non-indexed columns, aggregating, etc) you can start
returning rows immediately before the query "completes". Hence the
FIRST_ROWS hint favoring the execution plan you see -- you get the first
rows quickly. When join choices such as merge or hash are used, all the data
must be accessed before rows start returning. Depending upon the selectivity
of your data, and if you aren't normally using the rownum < 5, total
throughput might be better with the ALL_ROWS method. It's hard to say
without knowing your data. But, I just wanted to make sure that you aren't
falling into a trap by immediately seeing results when using the FIRST_ROWS
approach.

For an exaggerated example, assume I am joining two 100,000 row tables with
no constraining criteria other than the join between them. If I use
first_rows, thus a very good chance of an indexed nested loops approach, I
will start seeing results immediately. But in reality since I want every row
in each table, I would be better off (in a report for example) with full
table scans and hash joins. The mistake that one can make is to think the
first rows approach is faster since they immediately see results. When in
reality, for this example, it would take the query much longer to complete
than if the FTS and HJ approach was used.

Or, maybe this is just one of those cases where the CBO is making a bad
choice, and even without the rownum<5, a nested loops approach is still the
preferred method. It wouldn't be the first time the CBO made a "bad" choice.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle,
> William T (Bill), NLCIO
> Sent: Monday, December 03, 2001 12:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: FIRST_ROWS vs. ALL_ROWS
>
>
>   Howdy,
>
>   I have a query which was taking an extremely long time
> to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
> meaning it will use the ALL_ROWS method to determine its access paths. I
> determined the query was not using the indexes I thought it should. When I
> changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
> second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
> to minimize total execution time. I'm trying to figure out the difference.
> Using FIRST_ROWS, this is the output from tkprof:
>
>   select ra.originatingclli, ra.terminatingclli,
> r.originatingclli,
>   r.terminatingclli, r.deletedigits, r.prefixdigits,
> rs.originatingclli,
>   rs.terminatingclli from routingassignmentpersistent ra,
>   route r, routesegmentroute rs1, routesegmentpersistent rs
> where networktype = 'A
>   C' and networksubtype
>   = 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
>   r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID =
> rs.objid
>   and rownum < 5 and ra.startdate is not null
>
>   call count   cpuelapsed   disk  query
> currentrows
>   --- --   -- -- --
> --  --
>   Parse1  0.00   0.01  0  0
> 0   0
>   Execute  1  0.00   0.00  0  0
> 0   0
>   Fetch2  0.00   0.00  0 35
> 0   4
>   --- --   -- -- --
> --  --
>   total4  0.00   0.01  0 35
> 0   4
>
>   Misses in library cache during parse: 1
>   Optimizer goal: FIRST_ROWS
>   Parsing user id: 29  (NTOPBIG)
>
>   Rows Row Source Operation
>   ---  ---
> 4  COUNT STOPKEY
> 4   NESTED LOOPS
> 4NESTED LOOPS
> 2 NESTED LOOPS
> 1  TABLE ACCESS BY INDEX ROWID
> ROUTINGASSIGNMENTPERSISTENT
> 1   INDEX RANGE SCAN (object id 16976)
> 2  TABLE ACCESS BY INDEX ROWID ROUTE
> 2   INDEX RANGE SCAN (object id 16962)
> 5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
> 5  INDEX R



RE: Message at the start of svrmgrl


2001-12-03

Thread
Hand, Michael T




Anand,
 
I installed the same(? 
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this 
result.  However, I do remember this kind of result with a earlier upgrade 
to 8.0.x in the distant past.  I believe it is a verbose linking option 
with no negative impact.  Is svrmgrl the only executable responding like 
this.  If so, try relinking.
 
Mike Hand
Polaroid 
Corp.

  -Original Message- 
   
  I have just done installation of 8.1.7.0 
  on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no 
  installation errors. When I start svrmgrl I see a line "inst emulated 
  pid=175364...".
   
  -->$ svrmgrlinst emulated pid=175364 
   va=0x11fffa358 pc=0x1205c0148 
  inst=0x327e0028
   
  Oracle Server Manager Release 3.1.7.0.0 - 
  Production
   
  Copyright (c) 1997, 1999, Oracle Corporation.  All 
  Rights Reserved.





Re: Buffer Busy Waits -- Sanity check please


2001-12-03

Thread
Jared . Still




Thanks for the explanation.  I usually try to avoid delving
that deep into the internals, but I guess it's necessary on
occasion just to understand what's going on.

Jared



   
 
Riyaj_Shamsude 
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Re: Buffer Busy Waits -- Sanity 
check please  
om 
 
   
 
   
 
12/03/01 07:00 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Jared
Say, process A is interested in reading a block, then it hashes the
data block address of the block to find the hash bucket in the buffer
cache. If that specific block is in the buffer cache, then it must be
attached with that hash bucket. Holding the hash bucket latch, the process
A will look for the buffer in that hash chain with that data block address
. If the buffer is found in the buffer cache, then that process has to
examine the state of the buffer before proceeding further.
If another process B is operating on the buffer, i.e. reading a
database block from the disk in to the buffer (for FTS or otherwise), then
the process B will pin the buffer and the buffer is not available until the
read is completed. So, the process A will wait for the buffer to be
unpinned, posting 'buffer busy event'. Since this event can happen in
various points in the buffer lifecycles, p3 indicates details about the
wait itself.
Point being that, two processes can not  operate on the same buffer
simultaneously. Even though readers do not block readers in terms of locks,
they could be blocked due to buffer unavailability, but this event is
usually very brief.
As malcolm suggested, probably, the processes are chasing one
another.

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

   
   Jared Still 
   <[EMAIL PROTECTED]> To:Multiple recipients of list 
   Sent by: ORACLE-L <[EMAIL PROTECTED]>
   [EMAIL PROTECTED] cc:
Subject:Re: Buffer Busy Waits  
-- Sanity check please 
   12/02/01 10:15 PM   
   Please respond to   
   ORACLE-L
   






Interesting.  Any idea of what the point is in preventing other processes
from reading a block in the buffer?

Jared

On Saturday 01 December 2001 20:10, MacGregor, Ian A. wrote:
> The P3 value of 130 on the buffer busy waits does indicate that the block
> is being read by another process as Malcolm stated that's the process
doing
> the scattered read (Full table scan).  Oracle needs to protect the block
> while it is being read.   The others sessions are waiting until the read
of
> that block is complete.
>
> For a definition of the P3 values see Steve Adam's website
> http://www.ixora.com.au/
>
> His full explanation of P3 id 130 is
>
>
>1013Block is being read by another session and no other
>  or 130suitable block image was found, so we wait until the read
>is completed. This may also occur after a buffer cache
>assumed deadlock. The kernel can't get a buffer in a
>certain amount of time and assume



Re: Corrupted data blocks in tablespace SYSTEM


2001-12-03

Thread
Stephane Faroult


> Kevin Bass wrote:
> 
> I have just started a project and have encountered a database problem.
> The previous DBA did not create any backup scripts or backup and
> recovery plans. Is there a way to get around this problem without
> re-creating the database?
> 
> 
> When executing my script to get corrupted data block information , I
> get the following:
> ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
> ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf'
> 

Kevin,

   Check DBA_EXTENTS to see what kind of segment is corrupted. If it's a
table or a cluster, you have lost. Otherwise there is a chance to
recover the database. In any case try a full export.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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






FIRST_ROWS vs. ALL_ROWS


2001-12-03

Thread
Carle, William T (Bill), NLCIO


Howdy,

I have a query which was taking an extremely long time to complete. The
OPTIMIZER_MODE in the init.ora file is set to CHOOSE, meaning it will use
the ALL_ROWS method to determine its access paths. I determined the query
was not using the indexes I thought it should. When I changed to use the
FIRST_ROWS optimizer_mode, the query ran in under a second. Now FIRST_ROWS
is used to minimize response time; ALL_ROWS is used to minimize total
execution time. I'm trying to figure out the difference. Using FIRST_ROWS,
this is the output from tkprof:

select ra.originatingclli, ra.terminatingclli, r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits, rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs where networktype
= 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID = rs.objid
and rownum < 5 and ra.startdate is not null

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.00   0.01  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch2  0.00   0.00  0 35  0
4
--- --   -- -- -- --
--
total4  0.00   0.01  0 35  0
4

Misses in library cache during parse: 1
Optimizer goal: FIRST_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  4   NESTED LOOPS
  4NESTED LOOPS
  2 NESTED LOOPS
  1  TABLE ACCESS BY INDEX ROWID ROUTINGASSIGNMENTPERSISTENT
  1   INDEX RANGE SCAN (object id 16976)
  2  TABLE ACCESS BY INDEX ROWID ROUTE
  2   INDEX RANGE SCAN (object id 16962)
  5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
  5  INDEX RANGE SCAN (object id 16971)
4   TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
7 INDEX UNIQUE SCAN (object id 16965)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: FIRST_ROWS
  4   COUNT (STOPKEY)
  4NESTED LOOPS
  4 NESTED LOOPS
  2  NESTED LOOPS
  1   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
  'ROUTINGASSIGNMENTPERSISTENT'
  1INDEX   GOAL: ANALYZED (RANGE SCAN) OF
   'IX_ROUTINGASSIGNMENTPERSIST5'
(NON-UNIQUE)
  2   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
  'ROUTE'
  2INDEX   GOAL: ANALYZED (RANGE SCAN) OF
'IX_ROUTE4'
   (NON-UNIQUE)
  5  TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
 'ROUTESEGMENTROUTE'
  5   INDEX   GOAL: ANALYZED (RANGE SCAN) OF
  'IX_ROUTESEGMENTROUTE3' (NON-UNIQUE)   
  4 TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
OF
'ROUTESEGMENTPERSISTENT'
  7  INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
 'IX_ROUTESEGMENTPERSISTENT' (UNIQUE)

Using the ALL_ROWS mode, this is the tkprof output from the
same query:

select ra.originatingclli, ra.terminatingclli, r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits, rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs where networktype
= 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID = rs.objid
and rownum < 5 and ra.startdate is not null

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.02   0.01  0  0  0
0
Execute  2  0.05   0.06  0  0  5
0
Fetch2 40.91 471.49 197287 803265   3128
4
--- --   -- -- -- --
--
total5 40.98 471.56 197287 803265   3133
4

Misses in library cache during parse: 1
Optimizer goal: ALL_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  



rman oddities


2001-12-03

Thread
Koivu, Lisa

Title: rman oddities





Hi Ruth, thanks so much for responding.  


Yes, I wrote the scripts to do an arclog backup delete.  I'm concerned about the arclogs hanging around after a restore and taking up disk space, along with unnecessarily inflating the size of my backup files.  (I'm testing backup to disk right now)

It's more of a nice to know, not necessary.  I'm seeing some weird stuff that I didn't expect and the monkey in me wants to know why...  No, not the baby :)  Here's some other odd behavior I've seen:

1.  Instance failure during a backup leaves the rman files intact but the backup itself is not reflected in the catalog.  The database recovers nicely from this since no tablespaces are in hotbackup mode (yes)  The end result is "orphan" rman files that the catalog knows nothing about. 

2.  Initially these files are created the size of all datafiles combined.  As the backup progresses, the size of the files shrink down considerably.   For example, I allocate 3 channels to disk and setsize to 2GB, but the files start out at 1.5GB and shrink down to ~500 MB.   I wonder if that behavior happens on tape?  Anyone?  I'll be able to test this later this week.  

3.  Can restore and recovery really be this easy?  Sheesh


Thanks again for your response.  And list, please correct me if I am wrong on any of this.


yours in Monkeying Around,
Lisa


-Original Message-
From:   Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: rman restore & arclogs


Lisa,


We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs.  We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.


Have a look at rman's tables and views. You should be able to query them and
get what you want.


Yours in rman,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 10:30 AM



> Good morning all -
>
> I've been practicing rman restores.  It's a lot easier than I originally
> thought.  I've noticed that when you restore and the arclogs are needed,
it
> restores them.  Which is expected.  However, when I take another backup,
> these arclogs are included in the backup set.  This is unnecessary in my
> opinion and makes my backup files larger than they need to be.
>
> Is it standard practice to just delete the arclogs that were already in a
> backup set prior to taking the immediate backup after a recovery?  I can
> verify what arclogs are where in the backup sets with a report.
>
> Any comments are appreciated.  Thanks
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
>
>


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


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

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








Re: FIRST_ROWS vs. ALL_ROWS


2001-12-03

Thread
Stephane Faroult


"Carle, William T (Bill), NLCIO" wrote:
> 
> Howdy,
> 
> I have a query which was taking an extremely long time
> to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
> meaning it will use the ALL_ROWS method to determine its access paths. I
> determined the query was not using the indexes I thought it should. When I
> changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
> second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
> to minimize total execution time. I'm trying to figure out the difference.
> Using FIRST_ROWS, this is the output from tkprof:
> 

Bill,

   very roughly, FIRST_ROWS favours nested loop over hash join and
ALL_ROWS does the reverse. Hash join is by far the most efficient when
you do a 'full join' on big tables. By 'full join', I mean that there is
no screening condition but the joind condition (or something which is
not very discriminant). However, a hash join means a first pass on the
smallest table to build a hash table, then a full scan on the second
table, hashing the key each time and checking the hash table. It can
take sometime before the first line pops up (actually, all the
preliminary work of building the hash table). A nested loop answers
faster. The factor which makes the difference in your case is 'rownum <
5' - if you say that hash join as a high fixed cost and a low marginal
one compared to nested loops, the rownum condition do not let you return
enough rows to make the gain on marginal cost counterbalance the loss on
fixed one.
-- 
HTH,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
Mercadante, Thomas F

Title: rman restore & arclogs



Lisa,
 
I 
guess I'm lazy (or cautious) in that I would allow the first backup to take this 
archive log files back to tape where they belong, rather than determine (by 
running reports) which log files I may delete (by hand).
 
The 
cautious part of me says that if Rman decided to back these monkeys up within 
the first save set after the recovery, it may have decided that it needs them 
for a future recovery.  If you did remove them by hand, Rman may complain 
that it was expecting them and did not find them.  Did you try this - 
remove one that was restored by the recovery process and then tried a 
backup?
 
Depending on the kind of restore you do  - a full, 
or a point in time - the archivelog may be of no use anyway (a point in time 
makes them invalid because you had to perform an "open db reset logs", while a 
full restore could still use these again).
 
Glad 
you are at least experimenting with the tool before you put it in production - 
it actually is fun to do a restore as it happens so 
infrequently!
 
Good 
Luck!
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  rman restore & arclogs
  Good morning all - 
  I've been practicing rman restores.  It's a lot 
  easier than I originally thought.  I've noticed that when you restore and 
  the arclogs are needed, it restores them.  Which is expected.  
  However, when I take another backup, these arclogs are included in the backup 
  set.  This is unnecessary in my opinion and makes my backup files larger 
  than they need to be. 
  Is it standard practice to just delete the arclogs that 
  were already in a backup set prior to taking the immediate backup after a 
  recovery?  I can verify what arclogs are where in the backup sets with a 
  report.  
  Any comments are appreciated.  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 





RE: _delete_me=true


2001-12-03

Thread
Mercadante, Thomas F


Gee, how do I unsubscribe?  Oh-yeah!  Its at the bottom of every piece of
mail!!!  
Holy Cow BatMan!

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


-Original Message-
Sent: Monday, December 03, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Does he think - UNSUBSCRIBE?

:-))
On Mon  3. December 2001 18:55, you wrote:
> _delete_me=true
>
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

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

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






Re: Corrupted data blocks in tablespace SYSTEM


2001-12-03

Thread
Riyaj_Shamsudeen


Your error message indicates file #1 associated with the system tablespace and the trace file indicates the file #6. I would do the following
        1. Check the OS error message for any hardware errors.
        2. Find what objects are corrupted. To get this information use dba_extents and the given file and block#.Here is the script for the same:
---
accept  h_file_id  prompt  ' Enter file_id ==>'
accept  h_block_id  prompt ' Enter block_id==>'
set verify off
column owner format A10
column segment_name  format A20
column segment_type  format A10
column hdrfile    format 
column curfile    format 
column curblk     format 
column hdrblock   format 
select  owner, segment_name, segment_type, file_id,block_id from dba_extents
where file_id = &&h_file_id and
      block_id <= &&h_block_id and
      block_id + blocks > &&h_block_id;
set verify on

        3. Since the errors are in two different files, check whether these files are in the same disk or controller..
        4. Decide the course of action depending upon the above outcome.. It is possible for the disk /controller to give back the bad data. If it is an hardware problem, correct the hardware problem and then try again.

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






Kevin Bass <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/03/01 11:50 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Corrupted data blocks in tablespace SYSTEM


I have just started a project and have encountered a database problem. The previous DBA did not create any backup scripts or backup and recovery plans. Is there a way to get around this problem without re-creating the database?
 
 
When executing my script to get corrupted data block information , I get the following:
ORA-01578: ORACLE data block corrupted (file # 1, block # 2660)
ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf' 
 
 
Trace file information.
 
Dump file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trc
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name:    SunOS
Node name:      edi-01
Release:        5.7
Version:        Generic_106541-17
Machine:        sun4u
Instance name: TIE
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 11859, image: oracleTIE
 
*** SESSION ID:(13.50289) 2001.11.30.15.00.00.000
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
***  
Corrupt block relative dba: 0x0180af98 file=6. blocknum=44952.
Bad header found during buffer read
Data in bad block - type:0. format:0. rdba:0x00090255
last change scn:0x.3c07e0da seq:0x0 flg:0xb1
consistancy value in tail 0x
check value in block header: 0x10, check value not calculated
spare1:0x0, spare2:0x0, spare2:0xd40
Reread of rdba=180af98 file=6. blocknum=44952. found same corupted data
 
 
Kevin






Message at the start of svrmgrl


2001-12-03

Thread
Anand Prakash




I have just done installation of 8.1.7.0 on a Compaq 
Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. 
When I start svrmgrl I see a line "inst emulated pid=175364...".
 
-->$ svrmgrlinst emulated pid=175364  
va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028
 
Oracle Server Manager Release 3.1.7.0.0 - Production
 
Copyright (c) 1997, 1999, Oracle Corporation.  All Rights 
Reserved.
 
Oracle8i Enterprise Edition Release 8.1.7.2.0 - ProductionWith the 
Partitioning optionJServer Release 8.1.7.2.0 - Production
 
SVRMGR> ^DServer Manager complete.
 
 
Any ideas?
 
Anand Prakash





FIRST_ROWS vs. ALL_ROWS


2001-12-03

Thread
Carle, William T (Bill), NLCIO


Howdy,

I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
determined the query was not using the indexes I thought it should. When I
changed to use the FIRST_ROWS optimizer_mode, the query ran in under a
second. Now FIRST_ROWS is used to minimize response time; ALL_ROWS is used
to minimize total execution time. I'm trying to figure out the difference.
Using FIRST_ROWS, this is the output from tkprof:

select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
C' and networksubtype
= 'POTS' and ra.objid = r.ROUTINGASSIGNPERSFINAL_OBJID and
r.objid = ROUTE_OBJID and  ROUTESEGMENTPERSISTENT_OBJID =
rs.objid
and rownum < 5 and ra.startdate is not null

call count   cpuelapsed   disk  query
currentrows
--- --   -- -- --
--  --
Parse1  0.00   0.01  0  0
0   0
Execute  1  0.00   0.00  0  0
0   0
Fetch2  0.00   0.00  0 35
0   4
--- --   -- -- --
--  --
total4  0.00   0.01  0 35
0   4

Misses in library cache during parse: 1
Optimizer goal: FIRST_ROWS
Parsing user id: 29  (NTOPBIG)

Rows Row Source Operation
---  ---
  4  COUNT STOPKEY
  4   NESTED LOOPS
  4NESTED LOOPS
  2 NESTED LOOPS
  1  TABLE ACCESS BY INDEX ROWID
ROUTINGASSIGNMENTPERSISTENT
  1   INDEX RANGE SCAN (object id 16976)
  2  TABLE ACCESS BY INDEX ROWID ROUTE
  2   INDEX RANGE SCAN (object id 16962)
  5 TABLE ACCESS BY INDEX ROWID ROUTESEGMENTROUTE
  5  INDEX RANGE SCAN (object id 16971)
4   TABLE ACCESS BY INDEX ROWID ROUTESEGMENTPERSISTENT
7 INDEX UNIQUE SCAN (object id 16965)


Rows Execution Plan
---
---
  0  SELECT STATEMENT   GOAL: FIRST_ROWS
  4   COUNT (STOPKEY)
  4NESTED LOOPS
  4 NESTED LOOPS
  2  NESTED LOOPS
  1   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF

'ROUTINGASSIGNMENTPERSISTENT'
  1INDEX   GOAL: ANALYZED (RANGE
SCAN) OF

'IX_ROUTINGASSIGNMENTPERSIST5' (NON-UNIQUE)
  2   TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
  'ROUTE'
  2INDEX   GOAL: ANALYZED (RANGE
SCAN) OF 'IX_ROUTE4'
   (NON-UNIQUE)
  5  TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
 'ROUTESEGMENTROUTE'
  5   INDEX   GOAL: ANALYZED (RANGE
SCAN) OF
  'IX_ROUTESEGMENTROUTE3'
(NON-UNIQUE)   
  4 TABLE ACCESS   GOAL: ANALYZED
(BY INDEX ROWID) OF
'ROUTESEGMENTPERSISTENT'
  7  INDEX   GOAL: ANALYZED (UNIQUE
SCAN) OF
 'IX_ROUTESEGMENTPERSISTENT'
(UNIQUE)

Using the ALL_ROWS mode, this is the tkprof
output from the same query:

select ra.originatingclli, ra.terminatingclli,
r.originatingclli,
r.terminatingclli, r.deletedigits, r.prefixdigits,
rs.originatingclli,
rs.terminatingclli from routingassignmentpersistent ra,
route r, routesegmentroute rs1, routesegmentpersistent rs
where networktype = 'A
C' and netw



RE: Deleting Oracle8 on NT(cleaning Oracle8)


2001-12-03

Thread
Mercadante, Thomas F


Raghu,

If you just want to delete one oracle database from an NT machine, do as you
suggest - delete all of the files (control, log, data), init.ora, and any
directories that held these files.  Then, be sure and run ORADIM -delete
{sid} to remove the instance from the registry.  That should do it.

If you wish to remove a version of Oracle software completely from an NT
machine, I sent a document over this list last week that outlines how to do
this.  Pretty simple and straoghtforward - it has always worked for me.  If
you want this doc, let me know and I will send it to you.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 03, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L



Hi Friends,

I need to clean Oracle8 database size 3Gb on one of my NT server, Is it 
possible that shutdown the database and delete all datafiles and all 
directories??? Or Is there any other way to clean all files and 
directories?? I appreciate all suggestions and responses.

Thanks in advance
Raghu.



_
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: Raghu Kota
  INET: [EMAIL PROTECTED]

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

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

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

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






Re: Deleting Oracle8 on NT(cleaning Oracle8)


2001-12-03

Thread
Rodd Holman


Removing Oracle on NT (or any Windoze for that matter)
1. shutdown all oracle services (db, listener, etc.)
2. use the oracle installer and deinstall everything - this gets rid
   of a large portion of oracle
3. use regedit and remove the key HKEY_LOCAL_MACHINE\software\oracle
4. search the registry for oracle (delete every key related to
   the oracle install)
   do not delete keys related to Microsoft's Oracle ODBC (if
   installed it comes with VB) this is NOT an oracle product.
5. search the registry for ORANT (delete these keys)
6. SOUNDLY CURSE the "?genius?" at M$ who came up with the idea
   for the registry.
7. search the registry for ORADAC - this is the oracle objects for ole
   data access controller (delete these keys)
8. delete the directories of oracle datafiles, software, installer
   (usually in Program Files), and in the Start Menu.
9. remove any references to oracle in the autoexec.bat
10. Since this is Windoze reboot the machine.

Now oracle is gone. ;)

Rodd Holman

On Mon, 2001-12-03 at 12:10, Dwayne Cox wrote:
Raghu,

By shutting down the database and stopping the listener, you can delete all 
the data files and directories without a problem.  This will remove your 
database.

If you want to remove Oracle8 software, that will require purging the 
registry.  I don't think I have ever successfully removed ALL Oracle software 
from NT.

HTH

On Monday 03 December 2001 10:55 am, you wrote:
> Hi Friends,
>
> I need to clean Oracle8 database size 3Gb on one of my NT server, Is it
> possible that shutdown the database and delete all datafiles and all
> directories??? Or Is there any other way to clean all files and
> directories?? I appreciate all suggestions and responses.
>
> Thanks in advance
> Raghu.
>

-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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

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

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

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


2001-12-03

Thread
Jan Pruner


Does he think - UNSUBSCRIBE?

:-))
On Mon  3. December 2001 18:55, you wrote:
> _delete_me=true
>
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
Ruth Gramolini


Lisa,

We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs.  We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.

Have a look at rman's tables and views. You should be able to query them and
get what you want.

Yours in rman,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 10:30 AM


> Good morning all -
>
> I've been practicing rman restores.  It's a lot easier than I originally
> thought.  I've noticed that when you restore and the arclogs are needed,
it
> restores them.  Which is expected.  However, when I take another backup,
> these arclogs are included in the backup set.  This is unnecessary in my
> opinion and makes my backup files larger than they need to be.
>
> Is it standard practice to just delete the arclogs that were already in a
> backup set prior to taking the immediate backup after a recovery?  I can
> verify what arclogs are where in the backup sets with a report.
>
> Any comments are appreciated.  Thanks
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
>
>

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

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

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






HP-UX 11/8.1.7/Recovery


2001-12-03

Thread
Vergara, Michael (TEM)


Hi All!

We had an interesting sequence of events last night, and I was 
hoping somebody could tell me if what we saw was what should've 
happened.  Clear?  As mud?  Ok...

System is up and running.
The backup process starts, and puts the datafiles in backup mode.
The system crashes.  Hard.  Memory fault.
When the database comes back up, it successfully performs media
recovery and pronounces itself OK.
We check, and the datafiles are NOT in backup mode.

So we're wondering...does media recovery take the datafiles out
of backup mode automatically?  Can you point me to a doco on this?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
Dwayne Cox


Raghu,

By shutting down the database and stopping the listener, you can delete all 
the data files and directories without a problem.  This will remove your 
database.

If you want to remove Oracle8 software, that will require purging the 
registry.  I don't think I have ever successfully removed ALL Oracle software 
from NT.

HTH

On Monday 03 December 2001 10:55 am, you wrote:
> Hi Friends,
>
> I need to clean Oracle8 database size 3Gb on one of my NT server, Is it
> possible that shutdown the database and delete all datafiles and all
> directories??? Or Is there any other way to clean all files and
> directories?? I appreciate all suggestions and responses.
>
> Thanks in advance
> Raghu.
>

-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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






Oracle for Sun/64 Bit Question


2001-12-03

Thread
Mercadante, Thomas F


All,

I have the install disks for 8.1.7 for Sun SPARC Solaris.  

Are these disks (2 of them) the same for Sun 64bit?

I looked on TechNet, and I do not see any other 817 release for Sun.

I do see, however, 64 bit for Oracle for 9i.

Thanks!

Tom Mercadante
Oracle Certified Professional

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

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

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






_delete_me=true


2001-12-03

Thread
Deepak Thapliyal


_delete_me=true

__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.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: killing system user


2001-12-03

Thread
Deepak Thapliyal


Hi Jared

why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...

Thx
Deepak
--- Jared Still <[EMAIL PROTECTED]> wrote:
> 
> The session is rolling back, you can't kill it.
> 
> This is why the serial# is changing.
> 
> The following query can be used to track its
> progress.
> 
> select s.osuser
>   ,s.username
>   ,s.sid
>   ,r.segment_name
>   ,t.space
>   ,t.recursive
>   ,t.noundo
>   ,t.used_ublk
>   ,t.used_urec
>   ,t.log_io
>   ,t.phy_io
>   ,substr(sa.sql_text,1,200) txt
> from v$session s,
>  v$transaction t,
>  dba_rollback_segs r,
>  v$sqlarea sa
> where s.taddr=t.addr
> and   t.xidusn=r.segment_id(+)
> and   s.sql_address=sa.address(+);
> 
> Jared
> 
> 
> On Sunday 02 December 2001 22:55, Tatireddy,
> Shrinivas (MED, Keane) wrote:
> > Hi lists,
> >
> > Solaris 2.7
> > oracle 8i
> >
> > I have a session "SYSTEM" doing import into a
> table. (logged into server
> > thru telnet from win 98 PC)
> >
> > Suddenly the power outage occurred to my PC.
> >
> > When I logged into the server thru telnet, I found
> that the session is
> > active.
> > By mistake, I killed the process at o/s level.
> >
> > For somereasons,I tried to drop the table. But I
> failed to do it, as it
> > is locked by import process.
> >
> > I tried to kill the user "SYSTEM". But the oracle
> is giving  error that
> > there is not user with such sid and serial number.
> >
> > The serial# number is often getting changed when I
> query from v$session.
> >
> > Is there a way to kill this user, without shutting
> down the database.
> >
> > And why different serial# number each time, I
> query v$SESSION.?
> >
> > Any clues?
> >
> > Thnx and Regards,
> >
> > Srinivas
> -- 
> 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).


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.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).






Corrupted data blocks in tablespace SYSTEM


2001-12-03

Thread
Kevin Bass




I have 
just started a project and have encountered a database problem. The previous DBA 
did not create any backup scripts or backup and recovery plans. 
Is there a way to get around this problem without 
re-creating the database?
 
 
When 
executing my script to get corrupted data block information , I get the 
following:
ORA-01578: ORACLE data block corrupted (file # 1, block 
# 2660)ORA-01110: data file 1: '/u02/oradata/TIE/system01.dbf' 

 
 
Trace 
file information.
 
Dump 
file /u01/app/oracle/admin/TIE/udump/tie_ora_11859.trcOracle8 Release 
8.0.5.0.0 - ProductionPL/SQL Release 8.0.5.0.0 - ProductionORACLE_HOME = 
/u01/app/oracle/product/8.0.5System name:    SunOSNode 
name:  
edi-01Release:    
5.7Version:    
Generic_106541-17Machine:    
sun4uInstance name: TIERedo thread mounted by this instance: 1Oracle 
process number: 12Unix process pid: 11859, image: 
oracleTIE
 
*** 
SESSION ID:(13.50289) 2001.11.30.15.00.00.000***Corrupt block relative 
dba: 0x0180af98 file=6. blocknum=44952.Bad header found during buffer 
readData in bad block - type:0. format:0. rdba:0x00090255last change 
scn:0x.3c07e0da seq:0x0 flg:0xb1consistancy value in tail 
0xcheck value in block header: 0x10, check value not 
calculatedspare1:0x0, spare2:0x0, spare2:0xd40Reread of rdba=180af98 
file=6. blocknum=44952. found same corupted data***
Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data***Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data***Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data***  
Corrupt block relative dba: 0x0180af98 file=6. 
blocknum=44952.Bad header found during buffer readData in bad block - 
type:0. format:0. rdba:0x00090255last change scn:0x.3c07e0da seq:0x0 
flg:0xb1consistancy value in tail 0xcheck value in block header: 
0x10, check value not calculatedspare1:0x0, spare2:0x0, 
spare2:0xd40Reread of rdba=180af98 file=6. blocknum=44952. found same 
corupted data
 
 
Kevin





RE: Buffer Busy Waits -- Sanity check please


2001-12-03

Thread
Khedr, Waleed


Enabling parallel=2 or higher on this table could resolve the problem for
the original poster.

Regards,

Waleed

-Original Message-
Sent: Saturday, December 01, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L



Malcolm,

The paragraph below would indicate that readers are blocking.

Readers don't block in Oracle.  The only reason I can think of at
the moment for a SELECT to cause buffer busy waits is delayed
block cleanout, of which there has been a lot of discussion lately.

I could be all mixed up here I guess,  it's Saturday and I dont' want
to think too hard about all this. Don't have time to break out the FM 
so I'll just sit back and wait for you to agree or refute.  ;)

Jared

On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote:
> Jeff,
>
> The 3 sessions are doing the same (or similar) queries.  In this case
> count(*) which is forcing a full table scan of the table in each session.
> The 3 sessions are thus trying to access the same blocks from the SGA,  in
> the same order.  Only 1 session can access a block in the SGA at a time -
> this is the session showing 'db file scattered read'. The other 2 sessions
> need to wait for the block (these waits show as 'buffer busy waits' - ie
> waiting for the block in the SGA).  You will see the block id (and perhaps
> the file id) changing as the FTS's progress.  Thus the sessions are
> 'chasing' each other through the blocks - holding each other up with SGA
> block contention - which shows up as 'buffer busy waits'.  Hope that
> explains things.
>
> Regards,
>
> Malcolm
>
> -Original Message-
> Sent: Monday, November 26, 2001 11:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> We recently had a new website go live.   Since then, I'm seeing constant
> buffer busy waits
> and after a period of time, I see sessions hung on the same block#.The
> SQL query
> is always a COUNT(*) (below).   It's almost as though one session has a
> lock
>
> of some sort in the buffer cache and other sessions are blocked.  
> Although, I've checked and
> there's no DML ongoing, so I'm unsure as to why we would see this.   Note
> that v$session shows
> 78 and 393 to be INACTIVE, while 159 is ACTIVE.So it's like 159 can't
> write to
> the buffer cache because 78 and 393 have a lock there.   Note that these
> are all defined
> as persistent connections, via the Vignette front-end.   I'm sure all the
> clues are there
> but my brain is too fuzzed to piece it together.
>
>  SID SQL_TEXT O/S
> User
> - 
> ---
>   159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT   FROM BBN.BBN_SRV
> vignette
>   159 _PAID_WARR_CLAIM  WHERE CUSTOMER_ID = :b1  AND ENTERPRISE_CD = :
> vignette
>   159 b2  AND (CHECK_ID IS NOT NULL   AND CHECK_ID != 'PENDING' )
> vignette
>
>  SID EVENT   P1TEXT   P1 P2TEXT  P2 P3TEXT
> P3
> - --  -- --- -- -
> --
>78 buffer busy waitsfile#  72 block#  109177  id
> 130
>   393 buffer busy waitsfile#  72 block#  109177  id
> 130
>   159 db file scattered read   file#  72 block#  109177
blocks
> 8
>
>
> 
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson multimedia Inc.
>
> Email: [EMAIL PROTECTED]
> DBA Quickplace: http://gkmqp.tce.com/tis_dba

>
> 
>
>
>
***
>* E mail Disclaimer
>
> You agree that you have read and understood this disclaimer and you agree
> to be bound by its terms.
>
> The information contained in this e-mail and any files transmitted with
> it (if any) are confidential and intended for the addressee only.  If you
> have received this e-mail in error please notify the originator or
> telephone 0191 210 2060 or e-mail [EMAIL PROTECTED]
>
> This e-mail and any attachments have been scanned for certain
> viruses prior to sending but neither Northern Electric plc nor any of the
> companies in the Northern Electric group of companies from whom this
e-mail
> originates shall be liable for any losses as a result of any viruses being
> passed on.
>
> No warranty of any kind is given in respect of any information contained
in
> this e-mail and you should be aware that that it might be incomplete, out
> of date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
>
> Northern Electric plc
> Carliol House
> Market Street
> Newcastle-upon-Tyne
> NE1 6NE
> Registered in England and Wales: Number 2366942
>
>
>
***
>*
-- 
Please see the official ORACLE-L FAQ: http



RE: DISK LAYOUT


2001-12-03

Thread
Mark Leith


Well I think it's time for you to start reading papers discussing OFA
(Optimal Flexible Architecture).

http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82846/a
ppa_ofa.htm

The above link is for the LINUX OFA document, but the concepts are the same,
and you will probably find one specific to your platform simply by searching
at http://otn.oracle.com

Regarding RAID - there is a good paper (already mentioned on the list
lately) by Gaja at www.quest.com

HTH

Mark

P.S. Actually, thinking about it - you already asked this? How about having
a read as people have already suggested? There is only a finite amount that
we can put in to an email (hey - we all have to work too!).

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


Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot
disks).4 400MHZ cpu's
Expected database size is 250G..
1) Which raid level to use ...only for performance so may be no
mirroring..
2) did i have to split hard disks on 2 sets for indexes and tables or single
set of RAID 0 etc...
3) Where to place the log files , control files, oracle software , OS ,
tablespaces - System , Users(tables) , Temp, Indx (Indexes) , Rbs , Tools.

Thanks
-Harvinder

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

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

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






RE: SQL Loader Input File Situation


2001-12-03

Thread
Koivu, Lisa

Title: RE: SQL Loader Input File Situation





Don't include them in your control file.


-Original Message-
From:   Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject:    SQL Loader Input File Situation


8.1.7


I am loading an input file to a single DB table.  The input file is
different than the table I'm loading and contains fields I don't need to
load.  I do not want to load some of the input fields.  The input file has
11 cols. and I need to ignore 5 of them.  The DB table has 15 cols and I
know how to ignore them with the filler clause.  The input file is a
delimited flat file.  How do I tell SQL*Loader not to load various input
fields?


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN



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


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

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








function help ???


2001-12-03

Thread
Andrea Oracle


Hi, Could any one show me how to write the following
function?  Thank you very, very much!  

The GPA Function

1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.

2.Repeat_delete Policy: A student may repeat a course
as many times as he
wants. However, if the first grade he receives on this
course is a D or F,
then the second grade will automatically replaces the
first grade, and the
first enrollment will not go into his GPA calculation.
Under any other
circumstances, his grades will be considered as a
regular grade and be
taken into consideration for GPA.

create table Enrollment(
Student# NUMBER (7),
SNUM NUMBER (5),
Call# NUMBER (7),
Semester char (8),
GRADE char (3),
Credit number,
Withdraw_Date Date);

SNUM + Call# represents one class.

 Insert into Enrollment
values('58001','111','70070','Sp2000','F',3, null);
Insert into Enrollment
values('58001','111','70070','Fa2000','B',3, null);
Insert into Enrollment
values('58003','222','70070','Sp2000','A',2, null);
Insert into Enrollment
values('58004','333','80025','Fa2000','A',2, null);
Insert into Enrollment
values('58005','222','80025','Fa2000','C',3, null);




__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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


2001-12-03

Thread
BINAY . KUMAR


Can you please tell us which version of NT you are working on??
also throw some info about type of database, number of users (generally as
well as concurrently)??
if possible, give a brief description about the character of your SYSADMIN???

regards



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyods Limited
London
+44 02 7441 1648
***



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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

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

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






Re: portable statistics


2001-12-03

Thread
Ruth Gramolini


The database in question is cloned so I don't have to worry.  Thanks!  Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:16 PM


> If you genuinely clone a database ie copy the
> datafiles, then the stats will also be transferred.
> Other than that, you would need dbms_stats which comes
> only at 8.1+.
>
> You could always hack the internal sys tables -
> probably not the wisest option to persue :-)
>
> Cheers
> Connor
>
>  --- Ruth Gramolini <[EMAIL PROTECTED]>
> wrote: > Good morning again,
> >
> > I know that in 8i you can move statistics where you
> > clone a database.  Is it
> > possible in 8.0.6.3?
> >
> > Thanks!
> > Ruth
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page from News and Sport to Email
and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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






SQL Loader Input File Situation


2001-12-03

Thread
Ken Janusz


8.1.7

I am loading an input file to a single DB table.  The input file is
different than the table I'm loading and contains fields I don't need to
load.  I do not want to load some of the input fields.  The input file has
11 cols. and I need to ignore 5 of them.  The DB table has 15 cols and I
know how to ignore them with the filler clause.  The input file is a
delimited flat file.  How do I tell SQL*Loader not to load various input
fields?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN


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

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

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





    
  1   2    >  
  
  

    

      
    
    
 1 - 100 of 129 matches
    

    





Has the words




From


Subject



  Date within 1 day of
  Date within 3 days of
  Date within 1 week of
  Date within 2 weeks of
  Date within 1 month of
  Date within 2 months of
  Date within 6 months of
  Date within 1 year of


e.g. Jul 18 2006 or 8/14/03


Doesn't have



  Sort by relevance
  Sort by date




    
    

      

                               Site Navigation
      
      

        
The Mail Archive home
        

          oracle-l - all messages
        

          oracle-l  - about the list
        
Expand
      
    

    

      

  				Mail list logo