RE: SP2 error

[lhoska]

Thank you Sergey,
Your solution would not work because my error took place during an update.
I was wondering what kind of errors the SP2 errors are and how to get more
info on them.
thanks to everyone who reply.

-Original Message-
Sent: Wednesday, February 13, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


You can't do that in SQL*Plus:
SET COLUMN_NAME .
You can see the list of parameters which you can set by issuing SHOW ALL
(except a few).
If you want to format a column, than:
COL col_name_or_alias FORMAT .
HTH,
Best,
Sergey

-Original Message-
Sent: Wednesday, February 13, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L

How do I investigate the following error?
SP2-0735: unknown SET option beginning "=..."
I don't seem to find much...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

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

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

SP2 error

[lhoska]

How do I investigate the following error?
SP2-0735: unknown SET option beginning "=..."
I don't seem to find much...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

optimizer_mode/optimizer_rule

[lhoska]

What is the difference between optimizet_mode and optimizer_goal parameters?
Are they being used interchangeably?
I've rtmf-ed.  It is not clear.
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: RE: sqlplus question

[lhoska]

What ring are you going to give to Kimberly?  :-)

-Original Message-
Sent: Tuesday, January 29, 2002 11:41 AM
To: Multiple recipients of list ORACLE-L


Kewl! That means I get to start taking drugs again.

I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring.
Does she like to climb mountains?

-Original Message-
Sent: Tuesday, January 29, 2002 8:25 AM
To: Multiple recipients of list ORACLE-L


Walt, don't worry. He's speaking "WaReZ" speak. You have to
follow the White Rabbit to get out. 

For further instructions, see Kimberly. She enjoys questions like these. 

-Original Message-

I'm lost here...

--Walt

-Original Message-
Sent: Monday, January 28, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L



Well, you can check the manual but use the package dbms_output.put_job that
willfix it when you are inoracle but ifyoua re
in unix environment you must use crontab

Hope this is of help for you


Roland









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

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

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

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

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

[lhoska]

Thanks Jared, that would be great and I did think about applying your
suggestion.
But there is a little detail I failed to mention.  My rundays suppose to
skip weekends( that is easy) and certain holidays.
My OS is Windows NT.
Any suggestion is greatly appreciated.

-Original Message-
Sent: Monday, January 28, 2002 6:09 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


> The script is only suppose
> to run certain days of week.
> Does anyone have a suggestion how to do that.

Yes, just run it on those days, skipping the days that
you don't want it to run.
...

But seriously, which platform?

Unix, win32, OS/390, VMS?

On unix use 'cron'.
http://www.google.com/search?hl=en&q=cron+tutorial

On Win32 use the 'at' command:
just type 'at /help' in a command window.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/28/02 02:21 PM
Please respond to ORACLE-L

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


Hello,
I need to run some script using Oracle Sqlplus.  The script is only 
suppose
to run certain days of week.
Does anyone have a suggestion how to do that.

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

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

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

sqlplus question

[lhoska]

Hello,
I need to run some script using Oracle Sqlplus.  The script is only suppose
to run certain days of week.
Does anyone have a suggestion how to do that.

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: How to calculate Last and First Day of Month?

[lhoska]

the first is always the first and the last may be calculated by using
last_day function.

-Original Message-
Sent: Wednesday, January 23, 2002 4:32 PM
To: Multiple recipients of list ORACLE-L


Charlie Mengler wrote:
> 
> I would have thought that the "first day of the month"
> is ALWAYS the 1st, as in 1 (ONE)!
> 
> Please explain why it needs to be calculated or
> could be a value other than ONE.
> 
> >
> > >>> [EMAIL PROTECTED] 01/23/02 10:35AM >>>
> > Hey guys,
> >
> > I know this is propablby easy, but I'm a bit
> > overwhelmed here this week. Can you please tell me how
> > to get first and last days of the month given SYSDATE?
> >
> > thanks a lot
> >
> > Regards
> >

Another case of 'On what day does Xmas fall this year? - on December
25th'.

I think that using the TRUNC() function with the suitable parameter must
help you truncate SYSDATE to the first day of the month - perhaps
TRUNC(SYSDATE, 'MM') or similar (too tired to RTFM). Then TO_CHAR with
the suitable format should return whatever you want.
For the last day, I presume that identifying the first day of the NEXT
month and substracting 1 must simplify the 'is this 30/31/28/29'
question.
-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
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: 
  INET: [EMAIL PROTECTED]

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

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

[lhoska]

TRUNCATE TABLE :-)


-Original Message-
Sent: Thursday, December 27, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi Gurus
How to make deletetion of millions rows faster?
Please suggest.
Thx
Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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

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

sqlloader question

[lhoska]

I need to load a text format file into my database using sqlloader.  The
table I am loading into contains a special code column  9 positions long
with a following format ##--###--## (note dashes in between).  Dashes are
being stored in the database! (don't ask me why :-)  ).  My input file data
for that column comes in straight text  ( no dashes, of course ).  It is 7
positions long.
Is there a way to somehow input dashes using control file while loading
data?  I've looked 'concatenate' sqlloader command.  It is not going to take
care of my need.
Thank you to everyone who replies.  Have a safe a joyful new year.

Lyuda Hoska

-- 
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: SQL Loader Load Problem

[lhoska]

page 121 'skipping fields you don't want to load' of g.gennick 'oracle
sql*loader' book.

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


Ken,
 Good to know that it worked.
 Not sure what books you referred to, but if you deal with SQL*Loader a lot,
then you may want to check out Jonathan Gennick's book titled 'Oracle
SQL*Loader : The Definitive Guide' by O'Reilly.  

 Regards.

- Kirti

-Original Message-
Sent: Wednesday, December 19, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

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]

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

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

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

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

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

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

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

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

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

how to pass argument to a dos batch program from sqlplus

[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: Not able to view table

[lhoska]

Mark,
I am a really confused with your last statement.
"Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves this.."

Would you or someone else elaborate on this, pleeaassee?  Are we still
talking Oracle here

-Original Message-
Sent: Friday, November 30, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L


Jyoti,

Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
user, with a default tablespace of the new tablespace, and use this user
(with the appropriate system/object privileges) to create your
tables/indexes/objects.

On to another point about your mail - the password for SYSTEM is actually
the default. How about changing that for security reasons? This may just be
a test box, but there's nothing like good safe practice.

Back to the original question:

Who were you logged on as when you created the tables?
Where did you create them? (tablespace).

Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves this..

HTH

Mark

-Original Message-
Sent: 30 November 2001 06:50
To: Multiple recipients of list ORACLE-L


Hi all,
I have created with the following details:

Global DB name: manu.ifpjyo
SID:manu
Username:   SYSTEM
Password:manager
Tables:tblBundleCon, tblTextCon, tblFinalImage

I am able to connect to the database:
SQL> connect system@manu
password: ***
Connected.

But I am unable to view the tables that I have created:
SQL>select * from tblBundleCon;
*
ERROR at line 1:
ORA-00942: table or view does not exist

I get the above error. Where am I going wrong,
Thanx a lot in advance.
Jyoti.

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

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

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

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

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

[lhoska]

'soon' command can run at any time interval.  it doesn't have to be 3600
sec, could be any number of seconds.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 4:56 PM
To: Multiple recipients of list ORACLE-L


Hi,

You could use the soon command (in the resource kit) to schedule it to run
in 3600 seconds.
The batch file could also have logic to check the current time to work out
when to schedule it next.

You could also use at and have your batch calculate the next time to run at
- using either batch commands, some other scripting language or a freeware
date time arithmetic program.

Or as mentioned below, use the NT GUI scheduler (or some other scheduling
tool that works on NT)

Do you need more details?

Regards,
Bruce Reardon

-Original Message-
Sent: Wednesday, 31 October 2001 4:40

Saroj,

The only way that I can do this is using NT's GUI Task Scheduler.  There is
an advanced option there that lets you repeat tasks at every specified
interval and the duration.

Regards,
George

-Original Message-
Sent: Tuesday, October 30, 2001 12:20 AM

Hello Guru,

I want to run one batch in Windowns NT using At scheduler.

Thw question is :

a) There will be a start time & end time ...say 7PM & 12 PM
b) Want to run the batch say in every hour (Have a fixed Interval
time )
c)want to repeat step a & b everyday

I am facing the problem in AT command how to specify the interval time i.e
every 1 hr the batch will be run.

Please help me.

Regards,
Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

weekends/holidays

[lhoska]

Hi list,
Is there a function in Oracle that will determine if particular calendar day
is weekend or a US holiday.  I need to write a function that will check the
data integrity of my db.  It will check data entered into the system and
notice any gaps.  I have to go by days(i.e. every day there should be an
entry/ies unless it is a weekend or holiday.)
Thank you in advance,

Lyuda Hoska

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

data modeling processes

[lhoska]

Hi,
I am looking for some examples of DFD(data flow diagram), BPM(business
process module), and SOW(statement of work); some web-pages with examples
would be great.  If someone can point those I would appreciate it.
Thanks.

Lyuda Hoska

-- 
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: environmental variables

[lhoska]

John, may be it is a dump question.. but...
there are certain directories my variables would go under.  Note: I am
declaring custom environmental variables.
How do I address this issue?

-Original Message-
Sent: Monday, August 20, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L


Simple. Put them in a batch file:

@echo off
set env1 = One
set env2 = Two
set oracle_sid = mydb
...

Then reference like normal

C:\> echo %oracle_sid%
mydb

Jon Walthour
> 
> From: [EMAIL PROTECTED]
> Date: 2001/08/20 Mon PM 02:36:36 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: environmental variables
> 
> Is there any way to create NT environmental variables through script?
> 
> Lyuda Hoska
> -- 
> 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: Jon Walthour
  INET: [EMAIL PROTECTED]

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

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

environmental variables

[lhoska]

Is there any way to create NT environmental variables through script?

Lyuda Hoska
-- 
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: Lost of all Control Files

[lhoska]

I said 
if you've done it before..Otherwise you're right :-(.
May be 
a call Oracle support would help.

  -Original Message-From: Ramon Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 
  2001 3:48 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Lost of all Control Files
  Hi 
  Lyuda,
   
  Alter 
  database backup controlfile to trace doesn't work because the DB doesn't 
  mount. :-(
   
   
   
  Ramon E. Estevez
  [EMAIL PROTECTED]
  809-565-3121
  
-Mensaje original-De: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]En nombre de 
[EMAIL PROTECTED]Enviado el: Wednesday, 15 August, 2001 
2:01 PMPara: Multiple recipients of list 
ORACLE-LAsunto: RE: Lost of all Control 
Files
If  did 'alter database backup control file to 
trace'  prior to your control files going bad check your user dump 
directory.  Open that control file (it'll have .trc extension).  
They syntax will be right there.  You will have to edit it deleting 
unnecessary info.
HTH,
[Lyuda 
Hoska] 
 -Original 
Message-From: Ramon Estevez 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 
2001 1:21 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Lost of all Control 
Files

  Thanks,
   
  And 
  what is the sintax of the create controlfile command ?
   
  How 
  do I use it ?
   
  Now I 
  will backup them :-)
   
  Ramon E. Estevez
  [EMAIL PROTECTED]
  809-565-3121
  
-Mensaje original-De: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]En nombre de Djordje 
JankovicEnviado el: Wednesday, 15 August, 2001 10:37 
AMPara: Multiple recipients of list 
ORACLE-LAsunto: RE: Lost of all Control 
Files
If all three are corrupted, you have to run the 
"create controlfile" statement and to make sure that you list all your 
data files and redo logs.  You will loose the archiving and RMAN 
(if you have it) info though.
 
At least you will not forget now to backup 
control files regularly ;-).
 
Djordje

  -Original Message-From: Ramon Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
  August 15, 2001 10:22 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Lost of all Control 
  Files
  Hi 
  gurus,
   
  When my DB is 
  starting I am getting an error of corrupt block in controlfile (block 
  1, block #1) 
  Ora-00202 
  'c:\oracle\oradata\control01.con'
  Ora-00207 
  
   
  I have 3 
  controlfiles, no copies, sorry, shame.
   
  In the init.ora 
  I commented the line of the control file No1, then it gives me the 
  error in the No 2, then commented line of Control No 2, and continues 
  the error.
   
  Don't know what 
  to do.  
   
  I don't have 
  backups of the control files.
   
  Saludos,
   
   
  Ramon E. Estevez
  [EMAIL PROTECTED]
  809-565-3121
   

RE: Speed up Truncate tables

[lhoska]

No, you cannot change the size of the initial extent.
SQL> select initial_extent/1024, next_extent/1024, min_extents, max_extents
  2  from sys.dba_segments
  3  where segment_name='T1';

INITIAL_EXTENT/1024 NEXT_EXTENT/1024 MIN_EXTENTS MAX_EXTENTS
---  --- ---
 64   64   1  2147483645

SQL> ALTER TABLE T1 ALLOCATE EXTENT (SIZE 100 M);

Table altered.

SQL> select initial_extent/1024, next_extent/1024, min_extents, max_extents
  2  from sys.dba_segments
  3  where segment_name='T1';

INITIAL_EXTENT/1024 NEXT_EXTENT/1024 MIN_EXTENTS MAX_EXTENTS
---  --- ---
 64   64   1  2147483645
The purpose of 'ALLOCATE EXTENT' option of ALTER TABLE command is to let you
allocate a new extent explicitly.

-Original Message-
Sent: Wednesday, August 15, 2001 2:03 PM
To: '[EMAIL PROTECTED]'


Thomas,
are your sure you can change the initial extent?  My senior dba told me once
it is not possible; you have to drop and recreate table if there is a need
to change Initial extent.
I am going to play with it today.

-Original Message-
Sent: Wednesday, August 15, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


Chuan,

Kevin is correct.  If your truncate table is taking a *long* time (and the
table is not locked by another process), it's because your storage params
are incorrect for the amount of data you are holding.

Look at initial and next in comparison with the number of extents
(DBA_EXTENTS view) for the table in question, and modify them before you
load the data.
You can modify the INITIAL extent by issuing an 'alter table allocate
extent(size x)' command to grow the INITIAL extent.  
You can also modify the NEXT extent by issuing an 'alter table storage (next
x)' command to change the NEXT extent.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 15, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L


I had the same problem when truncating a huge table (24 Mill rows).   It
turned out that the reason my table was taking so long was the amount of
extents I had on it.  I could look at what was actually happening during a
truncate and it had to go and take each individual block and put them back
in the available lists.  

Well, after changing the settings on the table to make larger extents (and
therefore fewer) the truncates on that table went hundreds of times faster
(we had real bad settings on that table before).

You might investigate your storage parms and see just how many extents you
do have on that table.

-Original Message-
Sent: Wednesday, August 15, 2001 3:10 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Is there any way to speed up the truncating a big table with 12 million
rows?

Basically, I implemented truncating that big table on Production, but it
affected the performance much, so I had to stop it in the middle of way. All
the rows were truncated but the HWM was not shrunk at all. I want to do it
again to get the space back. Is there any way to speed up this process?

Platform: Oracle EE8.0.6 and Solaris 2.7

Thanks a lot in advance.

Chuan

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

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

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

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

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

RE: Speed up Truncate tables

[lhoska]

Thomas,
are your sure you can change the initial extent?  My senior dba told me once
it is not possible; you have to drop and recreate table if there is a need
to change Initial extent.
I am going to play with it today.

-Original Message-
Sent: Wednesday, August 15, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


Chuan,

Kevin is correct.  If your truncate table is taking a *long* time (and the
table is not locked by another process), it's because your storage params
are incorrect for the amount of data you are holding.

Look at initial and next in comparison with the number of extents
(DBA_EXTENTS view) for the table in question, and modify them before you
load the data.
You can modify the INITIAL extent by issuing an 'alter table allocate
extent(size x)' command to grow the INITIAL extent.  
You can also modify the NEXT extent by issuing an 'alter table storage (next
x)' command to change the NEXT extent.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 15, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L


I had the same problem when truncating a huge table (24 Mill rows).   It
turned out that the reason my table was taking so long was the amount of
extents I had on it.  I could look at what was actually happening during a
truncate and it had to go and take each individual block and put them back
in the available lists.  

Well, after changing the settings on the table to make larger extents (and
therefore fewer) the truncates on that table went hundreds of times faster
(we had real bad settings on that table before).

You might investigate your storage parms and see just how many extents you
do have on that table.

-Original Message-
Sent: Wednesday, August 15, 2001 3:10 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Is there any way to speed up the truncating a big table with 12 million
rows?

Basically, I implemented truncating that big table on Production, but it
affected the performance much, so I had to stop it in the middle of way. All
the rows were truncated but the HWM was not shrunk at all. I want to do it
again to get the space back. Is there any way to speed up this process?

Platform: Oracle EE8.0.6 and Solaris 2.7

Thanks a lot in advance.

Chuan

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

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

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

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

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

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

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

[lhoska]

If  did 'alter database backup control file to 
trace'  prior to your control files going bad check your user dump 
directory.  Open that control file (it'll have .trc extension).  They 
syntax will be right there.  You will have to edit it deleting unnecessary 
info.
HTH,
[Lyuda 
Hoska] 
 -Original Message-From: 
Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
August 15, 2001 1:21 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Lost of all Control Files

  Thanks,
   
  And what 
  is the sintax of the create controlfile command ?
   
  How do I 
  use it ?
   
  Now I 
  will backup them :-)
   
  Ramon E. Estevez
  [EMAIL PROTECTED]
  809-565-3121
  
-Mensaje original-De: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado 
el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple 
recipients of list ORACLE-LAsunto: RE: Lost of all Control 
Files
If 
all three are corrupted, you have to run the "create controlfile" statement 
and to make sure that you list all your data files and redo logs.  You 
will loose the archiving and RMAN (if you have it) info 
though.
 
At 
least you will not forget now to backup control files regularly 
;-).
 
Djordje

  -Original Message-From: Ramon Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 
  15, 2001 10:22 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Lost of all Control Files
  Hi 
  gurus,
   
  When my DB is 
  starting I am getting an error of corrupt block in controlfile (block 1, 
  block #1) 
  Ora-00202 
  'c:\oracle\oradata\control01.con'
  Ora-00207 
  
   
  I have 3 
  controlfiles, no copies, sorry, shame.
   
  In the init.ora I 
  commented the line of the control file No1, then it gives me the error in 
  the No 2, then commented line of Control No 2, and continues the 
  error.
   
  Don't know what to 
  do.  
   
  I don't have 
  backups of the control files.
   
  Saludos,
   
   
  Ramon E. Estevez
  [EMAIL PROTECTED]
  809-565-3121
   

RE: user holding session even after a re-boot

[lhoska]

If the user already has his information displayed on the screen( retrieve
already took place) and his/her machine freezes it is definitely application
problem, may be networking problem but not back end problem.  Printing
problem is not an Oracle problem.  
If he/she is retrieving while printing it may be either.  But still
indications are your programmers didn't write good code.
As to your question regarding the session I think it is not an unusual
behavior.  Check it in couple of minutes.  It should be gone.

-Original Message-
Sent: Wednesday, August 15, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L


I have Oracle 7.3.4 running on Windoze NT4.0.  I have been trying to
determine if I have an application problem or a database problem.  I have an
application called MP2 that is causing a user to have their PC freeze up
when they try to print from the application.  I ran a trace on their session
to see what is going on.  I have not looked at the trace file yet but when I
was doing this I noticed that when this person had a session open that I
could see with the query

SELECT sid,serial#,osuser from v$session;

That when they re-booted, their original session stayed open on Oracle.
Should a re-boot have ended the session.  When they logged back in another
session opened and the first one stayed open also.  Is this normal??

Thanks,

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

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

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

[lhoska]

t numbers) or the IRS
will
 >decide that your "business" is just a "hobby" and force you to
 >go back and
     >give up all your business deductions. It doesn't have to be a
 >huge profit,
 >but it does have to be a positive number.
 >
 >
 >
 >
 >lhoska@calibr
 >
 >esys.com To: Multiple
 >recipients of list ORACLE-L
 >Sent by:
 ><[EMAIL PROTECTED]>
 >root@fatcity.cc:
 >
 >com  Subject: RE: OT
 >-- training
 >
 >
 >
 >
 >08/13/2001
 >
 >06:05 PM
 >
 >Please
 >
 >respond to
 >
 >ORACLE-L
 >
 >
 >
 >
 >
 >
 >
 >
 >
 >I've heard from my tax adviser your business doesn't have to show
any
 >profit
 >for number of years after opening.  I suspect even then it is
 >not required.
 >What if you having hard time making profit?  It doesn't mean
 >you have to
 >close your business...I assume in that case you can also register
as a
 >non-profit organization.  Are tax breaks better for
 >non-profits?  I don't
 >know..
 >Also, if you don't already know.. some training companies
 >(Learning Tree
 >International per example) won't even register you for class
 >if you're an
 >individual.  You have to be a corporation.
 >Lyuda
 >
 >-Original Message-
 >Sent: Monday, August 13, 2001 3:42 PM
 >To: Multiple recipients of list ORACLE-L
 >
 >
 >You could create a web site that features some technical
 >materials and use
 >it to advertise your services if you are willing to moonlight on a
few
 >jobs,
 >just enough to turn a profit within a couple years.  Then I
 >would presume
 >you would have no trouble writing the training off as a legitimate
biz
 >expense.
 >
 >- Ethan
 >- http://www.geocities.com/epost1
 >
 >>-Original Message-
 >>From: Ron Rogers [mailto:[EMAIL PROTECTED]]
 >>Sent: Monday, August 13, 2001 11:42 AM
 >>To: Multiple recipients of list ORACLE-L
 >>Subject: Re: OT -- training
 >>
 >>
 >>Patrice,
 >> There is "resistance" to any training that I feel is
 >>necessary to further my knowledge and/or enhance my
 >>understanding of the Oracle processes. Even though I have
 >>money in the budget for such items I have to submit a business
 >>case defining the gains to the company and after completing
 >>the course with a passing grade the company will reimburse me
 >>the expenses for the course only. I also have to sign a waver
 >>that I will pay the company back the full cost of the course
 >>if I leave their employment before 365 days. Needless to say I
 >>pay for everything myself and hope to write it off on taxes if
 >>they ever get the bill signed into law.
 >>ROR mª¿ªm
 >>
 >>>>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
 >>Just out of curiosity, how many days / weeks of real training did
your
 >>employer provide you with in the last couple of years?
 >>
 >>"real" is in quotes, I don't mean the little 1 - 3 day
 >>seminars given by
 >>CareerTrack and other "training" companies, or
 >>management-related stuff like
 >>little MBA-flavoured certificates from universities.
 >>
 >>Oh, and did the amount of training you received match what you
 >>were told
 >>during your job interview?
 >>
 >>Regards,
 >>Patrice Boivin
 >>Systems Analyst (Oracle Certified DBA)
 >>
 >>Systems Admin & Operations | Admin. et Exploit. des systèmes
 >>Technology Services| Services technologiques
 >>Informatics Branch | Direction de l'informatique
 >>Maritimes Region, DFO  | Région des Maritimes, MPO
 >>
 >>E-Mail: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
 >>
 >>--
 >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
 >>--
 >>Author: Boivin, Patrice J
 >>  INET: [EMAIL PROTECTED]
 >>
 >>Fat City 

RE: having select from db link problems from 8.0.5.2.1

[lhoska]

did you try to recreate the link?

-Original Message-
Sent: Tuesday, August 14, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L


already did that , doesn't work, funny thing is I can tnsping that foreign
database but doesn't work through db link.
Thanks
Sandesh


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L



Add the foreign host name to your local /etc/hosts file.

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


 

"Naik, Sandesh

S"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>  
   Subject: having select from db
link problems from 8.0.5.2.1  
Sent by:

[EMAIL PROTECTED]

om

 

 

08/14/2001

12:06 PM

Please respond

to ORACLE-L

 

 





Dear List,
 I have 8.0.5.2.1(32bit) database on HP-UX 11.0 server.
 I have a database link connecting to other database.  I get following
error
while trying to access objects thorough db link ( db link goes to 8.1.6.2.0
(64bit) database on HP-UX 11.0

" ORA-12545: Connect failed because target host or object does not exist "

There is work around to put IP address for this host in tnsnames.ora which
fixes the problems. Is there any other good solution to this problem?
 All your suggestions are always welcome.

Thank you

Sandesh Naik
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naik, Sandesh S
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

[lhoska]

knock, 
knock...
:-)
 
 
p.s. I always wondered if you 
can put blame on your tax adviser in case of trouble.  I suspect, they 
won't buy it...

  [Lyuda Hoska]  -Original 
  Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 4:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  OT -- training
  Either to 
  don't need to incorporate, or my 
  tax 
  accountant lied to me,  I don't know
  which, but 
  I have written off training
  and IOUG-A 
  trips (that were paid for 100% by
  me) while 
  I was an employee of
  a 
  consulting firm.
   
  (Is that 
  the IRS I hear knocking?)
   
   Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is 
  like   trying to club someone 
  to death with a loaded Uzi.  
  - Larry Wall (creator of Perl) 
   
  
-Original Message-From: JOE TESTA 
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001 3:42 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
OT -- training
You can't write off training.  you need to get 
incorporated.  I'm a business entity and if/when the company i work for 
won't pay for training, you can bet it will get written off on my taxes, 
that includes all of the oracle books, OCP exams, you name it, it gets 
deducted as a legitimate company expense.  
 
2 years ago the company i was working for didnt want to 
send me to openworld(and I knew i'd be leaving in less than 2months 
anyways), so i ate the cost and wrote the entire trip off.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 08/13/01 02:41PM 
>>>Patrice,There is "resistance" to any training that I 
feel is necessary to further my knowledge and/or enhance my understanding of 
the Oracle processes. Even though I have money in the budget for such items 
I have to submit a business case defining the gains to the company and after 
completing the course with a passing grade the company will reimburse me the 
expenses for the course only. I also have to sign a waver that I will pay 
the company back the full cost of the course if I leave their employment 
before 365 days. Needless to say I pay for everything myself and hope to 
write it off on taxes if they ever get the bill signed into law.ROR 
mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 11:46AM 
>>>Just out of curiosity, how many days / weeks of real 
training did youremployer provide you with in the last couple of 
years?"real" is in quotes, I don't mean the little 1 - 3 day 
seminars given byCareerTrack and other "training" companies, or 
management-related stuff likelittle MBA-flavoured certificates from 
universities.Oh, and did the amount of training you received match 
what you were toldduring your job interview?Regards,Patrice 
BoivinSystems Analyst (Oracle Certified DBA)Systems Admin & 
Operations | Admin. et Exploit. des systèmesTechnology 
Services    | Services 
technologiquesInformatics 
Branch | Direction de 
l'informatique Maritimes Region, DFO  | 
Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]  
--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: 
Boivin, Patrice J  INET: [EMAIL PROTECTED] Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from).  You mayalso send the 
HELP command for other information (like subscribing).--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron 
Rogers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from).  You mayalso send the 
HELP command for other information (like 
subscribing).

RE: OT -- training

[lhoska]

I've heard from my tax adviser your business doesn't have to show any profit
for number of years after opening.  I suspect even then it is not required.
What if you having hard time making profit?  It doesn't mean you have to
close your business...I assume in that case you can also register as a
non-profit organization.  Are tax breaks better for non-profits?  I don't
know..
Also, if you don't already know.. some training companies (Learning Tree
International per example) won't even register you for class if you're an
individual.  You have to be a corporation.
Lyuda

-Original Message-
Sent: Monday, August 13, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L


You could create a web site that features some technical materials and use
it to advertise your services if you are willing to moonlight on a few jobs,
just enough to turn a profit within a couple years.  Then I would presume
you would have no trouble writing the training off as a legitimate biz
expense.

- Ethan
- http://www.geocities.com/epost1

>-Original Message-
>From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 13, 2001 11:42 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: OT -- training
>
>
>Patrice,
> There is "resistance" to any training that I feel is 
>necessary to further my knowledge and/or enhance my 
>understanding of the Oracle processes. Even though I have 
>money in the budget for such items I have to submit a business 
>case defining the gains to the company and after completing 
>the course with a passing grade the company will reimburse me 
>the expenses for the course only. I also have to sign a waver 
>that I will pay the company back the full cost of the course 
>if I leave their employment before 365 days. Needless to say I 
>pay for everything myself and hope to write it off on taxes if 
>they ever get the bill signed into law.
>ROR mª¿ªm 
>
 [EMAIL PROTECTED] 08/13/01 11:46AM >>>
>Just out of curiosity, how many days / weeks of real training did your
>employer provide you with in the last couple of years?
>
>"real" is in quotes, I don't mean the little 1 - 3 day 
>seminars given by
>CareerTrack and other "training" companies, or 
>management-related stuff like
>little MBA-flavoured certificates from universities.
>
>Oh, and did the amount of training you received match what you 
>were told
>during your job interview?
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services| Services technologiques
>Informatics Branch | Direction de l'informatique 
>Maritimes Region, DFO  | Région des Maritimes, MPO
>
>E-Mail: [EMAIL PROTECTED]  
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Boivin, Patrice J
>  INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Ron Rogers
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


--
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy.   Thank you.


==

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note

RE: closing DB on NT with a scheduled BATCH FILE

[lhoska]

I had the same question.
'How does it matter whether the command file is on 
C drive or D/E (other) drives?'
Does anyone know?

-Original Message-
Sent: Thursday, August 09, 2001 4:31 AM
To: Multiple recipients of list ORACLE-L


Jared,
Just out of curiosity I am asking ( May be I am 
missing something)
How does it matter whether the command file is on 
C drive or D/E (other) drives?

Some other things I would suggest is 
1. Generate a logfile for every command file (including 
one in schedular) for example on schedular you type the 
command as:

c:\backup\startorcl.bat >> c:\backup\startorcl.log

and not just 

c:\backup\startorcl.bat

2. Define the environment variables (ORACLE_SID , ORACLE_HOME etc)
in bat file and provide the full path of commands e.g.

SET ORACLE_SID=ORCL
d:\orant\816\bin\svrmgrl.exe "connect internal/pass"
>h:\backup\logs\shut1supp.log

3. Use some GUI version of Schedular e.g. WINAT or NT's native
schedular.

If you need any more assistance do get back..
 
Regards,
Rajesh

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 4:45 AM
To: Multiple recipients of list ORACLE-L




Because you are running this in the AT scheduler, it is not executing
with the same permissions.

I'll bet that your batch script it not on the C: drive.

Put it on the C: drive and see if it works.

Jared




 

"Bunyamin K.

Karadeniz"  To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
  Subject: closing DB on
NT with a scheduled BATCH FILE  
Sent by:

[EMAIL PROTECTED]

 

 

08/08/01 06:15 AM

Please respond to

ORACLE-L

 

 





Dear Gurus , I have a question , In fact I wonder if it is a bug of NT .

I want to close and reopen database with a .BAT file .
 When I execute the .bat file directly it executes correctly . But When
I
execute it with a schedule with AT command then it connects but does not
close database.

How can I handle That. ?
What do you do when you want to schedule startups and shutdowns of
database
on NT?

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: Rajesh Dayal
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: OT Dorothy Parker :)

[lhoska]

Congratulations on your survival Shrek.  Having more work is better than
having NO work.

-Original Message-
Sent: Thursday, August 09, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L


geez, is it friday yet?  i hope so, cuz we just got done laying off 25% of
the people here.

same work + less people := get-out-of-dodge-NOW.


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

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

MIPS:  Meaningless Indicator of Processor Speed.

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

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

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

[lhoska]

or use oradim...
oradimxx.exe -shutdown -sid  -usrpwd  -shuttype inst
-shutmode i
oradimxx.exe -startup -sid  -usrpwd  -starttype inst -pfile
.ora>

-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L


1. Create Batch file startdb.bat

containts of startdb.bat
---
SVRMGRL @c:\yourdirectory\startup.sql

2. create startup.sql

containts of startup.sql

connect internal/***;
startup exclusive open;

3. Create Batch file stopdb.bat

containts of stopdb.bat
---
SVRMGRL @c:\yourdirectory\stop.sql

4. create stop.sql

containts of stop.sql

connect internal/***;
shutdown immediate;

now schedule startdb.bat & stopdb.bat into NT scheduler. If you want to do
it 
thru a single bat file than call the 2nd bat from 1st.

I hope this clarifies your problem.

Regards,
Ramesh D Papnoi
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

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

Hi  Ihoska ,
I am sorry to read your reply.
Firstly Not a silly question.
Yes I am sure batch file runs because I can run it directly correctly. Yes I

create log file.
I investigate task manager if svrmgrl runs and look at v$session and it 
connects .
 So not a silly question as you see. Only thing is you do not understand the

problem perhaps.


  - Original Message - 
  From: [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, August 08, 2001 8:33 PM
  Subject: RE: closing DB on NT with a scheduled BATCH FILE


  silly question.
  Are you sure your batch file runs?  Do you create logs?  If so, did you 
check if log was created?
  How do you know it connects.
  I have similar batch files.  They run either way with no problems.
-Original Message-
From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject: closing DB on NT with a scheduled BATCH FILE


Dear Gurus , I have a question , In fact I wonder if it is a bug of NT .

I want to close and reopen database with a .BAT file .
 When I execute the .bat file directly it executes correctly . But When
I 
execute it with a schedule with AT command then it connects but does not 
close database. 

How can I handle That. ?
What do you do when you want to schedule startups and shutdowns of 
database on NT?

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

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

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

RE: sqlloader stops

[lhoska]

one after 
another.
Thanks for your 
interest...

  -Original Message-From: Stephen Andert 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 
  2001 1:17 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: sqlloader stops
  Lyuda, 
   
  I'll jump into the game of 20 questions.
   
  Is the batch file kicking off the jobs in serial (one after 
  the other) or in parallel (maybe using & to put each one in the 
  background)?
   
   
   
   
  Stephen Andert>>> [EMAIL PROTECTED] 08/08/01 
  07:06AM >>>If I execute one load at the time maually it loads 
  fine.  It gives me hardtime when I try to run multiple loads(one 
  after another) through the batchfile.- Original Message 
  -To: "Multiple recipients of list ORACLE-L" 
  <[EMAIL PROTECTED]>Sent: Tuesday, August 07, 2001 9:05 
  PM> How about using some GUI tool (or even SQL) to see 
  what> SQL its running, if any, and what counters and waits are> 
  incrementing...>> Good luck, keep in touch :-)>> 
  Yosi>>> [EMAIL PROTECTED] wrote:>> > 
  Thanks Yosi.> > No, that is not the case..:-(> >> 
  > -Original Message-> > Sent: Tuesday, August 07, 2001 
  5:37 PM> > To: Multiple recipients of list ORACLE-L> 
  >> > Silly ol' me. Are you out of space in your archive log 
  destination?> >> > This is like a guessing game. 
  :-)> >> > [EMAIL PROTECTED] wrote:> 
  >> > > Hi List,> > > I have another 
  problem.> > > I have a process that loads multiple (~ 20 ) files 
  through sqlloader.It> > > works fine on other servers.  
  There is this one server that is givingme a> > > hard 
  time.  It loads 3 files and then stops.  I commented out 
  thethird> > call> > > to sqlloader thinking may be 
  there is something wrong with a thirdtext> > > file.  It 
  loaded 3 files again and stopped on the forth one.> > > There is 
  nothing in alert log (no errors).  Also, there is enoughspace 
  on> > > the drive where the logs are going.> > > 
  Oracle 7.3.4 on NT.> > > If anyone has any idea please let me 
  know...> > >> > > Lyuda Hoska> > > 
  (703)797-8656> >> > --> > Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com> > --> 
  > Author: Yosi Greenfield> >   INET: 
  [EMAIL PROTECTED]> >> > Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051> 
  > San Diego, California    -- Public 
  Internet access / Mailing Lists> > 
  > 
  > To REMOVE yourself from this mailing list, send an E-Mail message> 
  > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
  in> > the message BODY, include a line containing: UNSUB 
  ORACLE-L> > (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).>> --> 
  Thanks,>> Yosi>>> 
  -> Yosi 
  Greenfield> Oracle Certified DBA> 
  [EMAIL PROTECTED]>>> --> Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com> --> 
  Author: Yosi Greenfield>   INET: 
  [EMAIL PROTECTED]>> Fat City Network Services    
  -- (858) 538-5051  FAX: (858) 538-5051> San Diego, 
  California    -- Public Internet access 
  / Mailing Lists> 
  > 
  To REMOVE yourself from this mailing list, send an E-Mail message> to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the 
  message BODY, include a line containing: UNSUB ORACLE-L> (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: 
  lyudah  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
 

RE: closing DB on NT with a scheduled BATCH FILE

[lhoska]

silly 
question.
Are 
you sure your batch file runs?  Do you create logs?  If so, did you 
check if log was created?
How do 
you know it connects.
I have 
similar batch files.  They run either way with no 
problems.

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 
  9:15 AMTo: Multiple recipients of list ORACLE-LSubject: 
  closing DB on NT with a scheduled BATCH FILE
  Dear Gurus , I have a question , In fact I wonder 
  if it is a bug of NT .
   
  I want to close and reopen database with a .BAT 
  file .
   When I execute the .bat file directly 
  it executes correctly . But When I execute it with a schedule with AT command 
  then it connects but does not close database. 
   
  How can I handle That. ?
  What do you do when you want to schedule startups 
  and shutdowns of database on NT?
   
  Thank you
   
   

RE: sqlloader stops

[lhoska]

Thanks Yosi.
No, that is not the case..:-(

-Original Message-
Sent: Tuesday, August 07, 2001 5:37 PM
To: Multiple recipients of list ORACLE-L


Silly ol' me. Are you out of space in your archive log destination?

This is like a guessing game. :-)


[EMAIL PROTECTED] wrote:

> Hi List,
> I have another problem.
> I have a process that loads multiple (~ 20 ) files through sqlloader.  It
> works fine on other servers.  There is this one server that is giving me a
> hard time.  It loads 3 files and then stops.  I commented out the third
call
> to sqlloader thinking may be there is something wrong with a third text
> file.  It loaded 3 files again and stopped on the forth one.
> There is nothing in alert log (no errors).  Also, there is enough space on
> the drive where the logs are going.
> Oracle 7.3.4 on NT.
> If anyone has any idea please let me know...
>
> Lyuda Hoska
> (703)797-8656

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

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

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

[lhoska]

My impression is the ERRORS parameter is set for each single load not number
of loads.
No, there is no bad file.  Thanks David.

-Original Message-
Sent: Tuesday, August 07, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Just a stab here...

Check the .bad files to see if you are getting any data rows kicked out due
to errors.  If so, you might be exceeding the ERRORS parameter by the time
you finish the third file.

HTH.

David Wagoner
DBA


-Original Message-
Sent: Tuesday, August 07, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L

Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.  It
works fine on other servers.  There is this one server that is giving me a
hard time.  It loads 3 files and then stops.  I commented out the third call
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know... 

Lyuda Hoska
(703)797-8656

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

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

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

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

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

sqlloader stops

[lhoska]

Hi List,
I have another problem.
I have a process that loads multiple (~ 20 ) files through sqlloader.  It
works fine on other servers.  There is this one server that is giving me a
hard time.  It loads 3 files and then stops.  I commented out the third call
to sqlloader thinking may be there is something wrong with a third text
file.  It loaded 3 files again and stopped on the forth one.
There is nothing in alert log (no errors).  Also, there is enough space on
the drive where the logs are going.
Oracle 7.3.4 on NT.
If anyone has any idea please let me know...  

Lyuda Hoska
(703)797-8656

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

huge datafiles/need help

[lhoska]

Hi List,
I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask
me who created such a file because I don't know.  I am trying to rescue the
database that has multiple problems.  Something you've never seen before.  
Bye the way, did anyone ever run a test how much stuff you can put on your
disc before it dyes?  Well, yesterday I found a disc which was 99.07 % full.
Anyway...
The tablespace is ~ 50 % free.  The bad news is it doesn't let me to reduce
the size of the datafiles by using 'alter database datafile ... resize...';.
That tablespace contains 32 indexes.  Some of them are as large as 600 -800
M.  I need to develop a plan of attack.
My options are:
1) drop and recreate the indexes;
2) rebuild the indexes in different tablespace/tablespaces;
3) export/import indexes or may be even tablespace all at once.

Is there anyone who has done something similar before?
All suggestions are greatly appreciated.  That database is screaming for
help!!
It running Oracle 8.1.6 on NT.

Lyuda Hoska

-- 
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: OT about to peeve off the vegatarians: RE: OT RE: Largest

[lhoska]

There are some farmers who will let you visit their farm and let you pick
some berries.  I assume you need to pay a fee. A friend of mine invited me
to go berry-picking with her passed Saturday.   I could not make it because
I had to work..  But if someone is interested there probably are some farms
like that around your area.

-Original Message-
Sent: Wednesday, August 01, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L


Are they still there? anyone up for a field trip? :)


>From: April Wells <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
>Date: Wed, 01 Aug 2001 13:22:02 -0800
>
>Canteberry Acres farm
>
>Nutt Road
>
>Grove City Pennsylvania
>
>They were the farm next door when I was growing up.  Charles Hamilton
>owner/operator... It was heavenly.  I worked for him for 10 years clipping
>blossoms & picking berries.  It was then that I learned why you run your
>irrigation systems when there is frost in the early spring...
>
>=)
>
>-Original Message-
>Sent: Wednesday, August 01, 2001 4:02 PM
>To: Multiple recipients of list ORACLE-L
>
>
>While you're at it, April, could you tell me where I could get about 80
>pounds of those strawberries?  The frozen ones I've been using to make wine
>are not quite what I have hoped they'd be.
>
>David
>
>-Original Message-
>Carmichael
>Sent: Wednesday, August 01, 2001 1:16 PM
>To: Multiple recipients of list ORACLE-L
>
>
>April,
>
>Okay, now tell me WHERE I can get those?  The ones from the greenmarket are
>already insanely wonderful, I'm not sure I could stand anything more 
>intense
>:)
>
>Rachel
>
>
> >From: April Wells <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
> >Date: Wed, 01 Aug 2001 10:37:19 -0800
> >
> >Rachel,
> >
> >You need to try strawberries, warm from the sun, wet from the irrigation
> >system, with the light dusty dirt still crunching on them.
> >
> >April
> >
> >-Original Message-
> >Sent: Wednesday, August 01, 2001 12:17 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Ian,
> >
> >You have my sympathies for your struggles. And my respect for how you 
>seem
> >to be dealing with them. My husband was a hemophiliac. Just living with
> >that
> >
> >as an adult was hard. To live with a genetic disorder in a child must be
> >infinitely harder. I have an enormous respect for my mother-in-law who
> >raised such a child and did not wrap him in cotton-wool, "in case he got
> >hurt".
> >
> >You are in CA, where you can get a much better assortment of
> >non-store-bought produce than I can here in NYC, although I tend to
> >frequent
> >
> >the greenmarkets and try to buy what is in season when I buy in stores.
> >Even
> >
> >then, store-bought doesn't taste as good as fresh-picked. I have 
>converted
> >one person at work to never eating store-bought strawberries again, he
> >tried
> >
> >some from the greenmarket when they were in season and was convinced.
> >
> >Rachel
> >
> >
> > >From: "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
> > >Date: Tue, 31 Jul 2001 15:15:35 -0800
> > >
> > >So where do I get my woolly mammoth steaks.  What was the life 
>expectancy
> > >of early hominids?  I don't know about Maine Blue Berries, but wild
> > >blueberries in Nova Scotia are just as sweet if not sweeter than the
> >store
> > >bought ones.
> > >
> > >Where in a reputable peer-reviewed journal can one find an article 
>store
> > >bought food is less nutritious than wild food.  The purpose of fruit is
> >to
> > >be eaten, the seeds passing through the digestive  system intact to be
> > >planted with a little fertilizer.  The sweeter the fruit, the more
> >animals
> > >are attracted, the greater chance of the plant dispersing its progeny.
> > >
> > >As far as I can tell taste takes a second seat to looks with commercial
> > >produce.  Produce is picked before its time so it can be transported
> > >unbruised.  It doesn't taste as good as the stuff off a backyard tree.
> > >
> > >
> > >My daughter is autistic.  We have her on a cassein and gluten free 
>diet.
> > >It seems to have done her some good; her attentiveness has increased 
>and
> > >her perserveration has dropped.  My wife swears it has; I lean more
> >towards
> >
> > >non-casual coincidence, but I don't want  to give her bread pudding in
> >case
> >
> > >I'm wrong.  You won't believe how many things have gluten and cassein.
> > >Gluten is not naturally found in corn, but it's in corn flakes.  Most 
>soy
> > >cheeses have cassein in them  so they melt like dairy cheeses.  It is
> >very
> > >difficult to keep on such a diet,  ta

RE: OT -- suggestions to ensure nerdiness in potential IT staff

[lhoska]

We need to admit the rest of the world considers us geeks.  Even in IT world
dba's are probably one of the geekeest (is it a new word I invented?), not
too many people like us.  Well, may be C++ programmers would come close in
geekeness (new word again?) to us.
My friend tried to hook me up with a guy whose profession had nothing to do
with IT.  He was concerned about my occupation... I need to let him read
some of the e-mails on this list so he may know we're normal people and we
know how to laugh.  Should we also let duhvelopers in to prove to them we're
OK?  No, we won't bother...
Lyuda

-Original Message-
Sent: Wednesday, August 01, 2001 4:52 PM
To: Multiple recipients of list ORACLE-L


> What famous character was used to first advertise the IBM PC?

Charlie Chaplin, easy one.

> Was it possible to connect two screens to the original IBM PC? How?

I believe I did one through a Hercules graphics card, but dont quote me.

> How many boot disks did computers require before 1982?

0

> How would you convert a 1-sided 5 ¼" diskette into a 2-sided one?

Flip the floppy and cut a notch.  I actually used scissors.  I loved it when
they came out with those precise clippers.

> How did the Commodore Pet make use of hard disk drives?  Floppy drives?

Never had one, sorry.

> What colour were the Verbatim 5 ¼" diskette pockets?

Was it grey?  Was that 3Ms?  I remember paying 50 bucks for 10 floppies.  I
thought it was a great deal!!

> What IBM PS/2 model was listed as having a 2.88M diskette drive?

Sorry, I went with all the generic PCs.

> What version of Windows did OS/2 not support?  Why not?
> Did the first macintosh computer come with a handle?
> What is an MWave Windsurfer card?
> Which company could be argued started the certification fad in IT?
> Bonus points:  What figurines appear on PC Magazine Vol 1., Issue 1's
cover?
> (I notice PC Magazine has gone back to the thickness it had for issue 1,
vol
> 1... heh heh I wonder what happened).
> Extremely important entertainment bonus question:  What cartridges came
with
> the Atari 2600 game system upon initial purchase?

Asteroids, I think. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, 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).
-- 
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: Using AT command in NT

[lhoska]

or try winat and get a window version of it..

-Original Message-
Sent: Wednesday, August 01, 2001 4:04 PM
To: Multiple recipients of list ORACLE-L


Try,

at 12:00pm /every:m,t,w,th,f c:\my_backups\backup.bat

George

-Original Message-
Sent: Wednesday, August 01, 2001 11:28 AM
To: LazyDBA.com Discussion


I'm looking into setting up my backups and want to use the AT command in NT 
but I need some examples of the command line.

I Know that I want it daily at midnight,but how do I do this in command line

mode, What is the command?

This is what I have tried and it does'nt work.
AT /every:date M,T,W,TH,F 12:00pm "c:\my_backups" -- this does not work.

Help please

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



Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  INET: [EMAIL PROTECTED]

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

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

[lhoska]

Preferable solution:
ORADIMxx  -DELETE  -SID
xx will depend on your version or Oracle
or
ORADIMxx  -DELETE  -SRVC  
service_name is your service name

Alternative solution:
In your registry settings.
Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, and remove all
keys that begin with ORACLE.

-Original Message-
Sent: Tuesday, July 31, 2001 7:06 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I installed, deinstalled, and reinstalled some Oracle
tools.  In the NT service window, I still see the
service name for non-extisting services.  How can I
clean out these services?  (NT 4.0, Oracle 815 EE for
NT, OEM 204).


Thanks.
Andrea

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: 
  INET: [EMAIL PROTECTED]

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

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

RE: sqlloader process dies

[lhoska]

I could do it but the trick it to load it all at once...

-Original Message-
Sent: Tuesday, July 31, 2001 7:06 PM
To: Multiple recipients of list ORACLE-L


Why don't you try to divide this load in several parts.

Alex Hillman

-Original Message-
Sent: Tuesday, July 31, 2001 6:26 PM
To: Multiple recipients of list ORACLE-L


Thank you Kevin.
No, drive has plenty of space.
Any one else has a guess?
-Original Message-
Sent: Tuesday, July 31, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L


Since it can't create a log file either ... how about space ???  running out
of space on the machine ??

-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L


Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load.  It tries to load between 1 and 2 millions records.  Sometime during
the load it just dies. I see an attempt to create a log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

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

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

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

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

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

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

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

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

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

[lhoska]

Thank you Kevin.
No, drive has plenty of space.
Any one else has a guess?
-Original Message-
Sent: Tuesday, July 31, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L


Since it can't create a log file either ... how about space ???  running out
of space on the machine ??

-Original Message-
Sent: Tuesday, July 31, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L


Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load.  It tries to load between 1 and 2 millions records.  Sometime during
the load it just dies. I see an attempt to create a log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

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

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

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

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

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

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

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

sqlloader process dies

[lhoska]

Hi,
I am experiencing a problem with sqlloader not being able to finish a large
load.  It tries to load between 1 and 2 millions records.  Sometime during
the load it just dies. I see an attempt to create a log file but the file
size remains 0 bytes.  It remains 0 size until the next day when new process
kicks off.  The described scenario occurs day after day.  It is a cron job
kicked from a batch file running multiple loads simultaneously.  There are
two particular loads that die every day...
Anyone has any idea?
Thank you for your help  

Lyuda

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

FW: setting DbName in SQL*PLUS

[lhoska]

I looked at rtfm and found sqlprompt will only work if sqlnumber is off.
Added that line to the script, still doesn't work.  Looks like it is not
picking glogin.sql.  Anyone has any idea what else I need to do?
Thank you.
Lyuda
-Original Message-
Sent: Monday, July 23, 2001 1:17 PM
To: Lyuda Hoska


I looked at rtfm and found sqlprompt will only work if sqlnumber is off.
Added that line to the script, still doesn't work.  Looks like it is not
picking glogin.sql.  Anyone has any idea what else I need to do?
Thank you.
Lyuda
-Original Message-
Sent: Monday, July 23, 2001 12:59 PM
To: '[EMAIL PROTECTED]'


I changed my glogin.sql logged out, logged back on to sqlplus and 
nothing happened...
Is there anything else I need to do?

-Original Message-
Sent: Monday, July 23, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm
Script and explaination included.

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 1:27 PM


> Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS
> thru glogin.sql? 
> 
> Shailesh
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Yadav, Shailesh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Andrew Lieu
  INET: [EMAIL PROTECTED]

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

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

[lhoska]

I changed my glogin.sql logged out, logged back on to sqlplus and 
nothing happened...
Is there anything else I need to do?

-Original Message-
Sent: Monday, July 23, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm
Script and explaination included.

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 1:27 PM


> Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS
> thru glogin.sql? 
> 
> Shailesh
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Yadav, Shailesh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Andrew Lieu
  INET: [EMAIL PROTECTED]

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

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

[lhoska]

select table_name, column_name 
from sys.dba_tab_columns
where column_name like 'http://explorer.msn.com/intl.asp

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

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

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

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

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

RE: Re[2]: security problem with 8i

[lhoska]

My old job had never changed any of the default passwords. And the reason
why standard passwords are kept is because it is 'easy to remember'.  Go
figure...

-Original Message-
Sent: Wednesday, July 18, 2001 1:48 PM
To: Multiple recipients of list ORACLE-L


Not at all.  Just last week I had a vendor who came in to install a
package.  They were very upset because SYS didn't have the "standard"
password and their install script wouldn't work.

I questioned their use of the SYS schema for the installation but powers
wiser than me had me change the SYS password to the "standard" value and
leave the room.

Hey, it's a job.

-- 
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: Last Update

[lhoska]

Guys,
can you please confirm to me you found dba_tab_modifications table.  I
checked both 7.3.4 and 8i versions and I don't seem to find the table.
Thank you.
-Original Message-
Sent: Tuesday, July 17, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L




Hi,

Thanks for the clarification.   Always welcome.


  shreepad




To:   Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT
  INTERNET@CCMAIL
cc:



However you can query the view dba_tab_modifications
for checking when and how many
updates/deletes/inserts/truncate have been done on the
table. If this is enough, great, don't you think so ?.

Regards.


--- Shreepad Vaidya <[EMAIL PROTECTED]>
wrote:
>
>
> Hi,
>
> This is what is mentioned in the manual.
> Alter table MONITORING
>  specifies that Oracle can collect modification
> statistics on table.
>  These statistics are estimates of the number of
> rows affected by DML
> statements over a particular period of time.
> They are available for use by the optimizer or for
> analysis by the
> user.
>
> I think erik is looking out for the date and time
> when the DML
> occurred.  ,
> whereas the monitoring clause woud give the  rows
> affected  .
>
> Hope my interpretation is correct.
>
> shreepad
>
>
>
>
>
> To:   Shreepad Vaidya/EMEA/ALLTELCORP,
> [EMAIL PROTECTED] AT
>   INTERNET@CCMAIL
> cc:
>
>
>
> alter table monitoring.
> --- Shreepad Vaidya <[EMAIL PROTECTED]>
> wrote:
> >
> >
> > Hi Erik,
> >
> > Check out the dba_objects tables.
> > There is a column called as Last_ddl_time , which
> > will give the ddl
> > time.  But if you want to capture
> > select,insert,delete,update
> > times ?
> > I guess you will have to write trigger and capture
> > the times.
> >
> >
> >
> > HTH
> >
> > shreepad
> >
> >
> > shreepad
> >
> >
> >
> >
> > To:   Shreepad Vaidya/EMEA/ALLTELCORP,
> > [EMAIL PROTECTED] AT
> >   INTERNET@CCMAIL
> > cc:
> >
> >
> >
> > How can I tell when a table was last updated? I am
> > able to tell when
> > it is
> > last anylized, but I am looking for the date of
> the
> > last DML on the
> > table.
> >
> > Thanks
> > Erik
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Erik Williams
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

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

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : 541149816062
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Christian Trassens
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

private/public rollbacks

[lhoska]

Hi List,
Who can tell me what advantages/disadvantages of having private rollback
segments versus public rollback segments?
Thank you.

Lyuda Hoska

-- 
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: alert log is not capturing all errors

[lhoska]

Thank you 
John.

  -Original Message-From: John Carlson 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 5:56 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  alert log is not capturing all errors
  The alert log does not capture anything it considers 
  to be a user error.
   
  HTH,
  John
  >>> [EMAIL PROTECTED] 07/12/01 12:35PM 
  >>>Hi List,I have encountered a little strange 
  incident.  Here is a brief:I ran a package which runs every day early 
  in the morning.  I create a logof the process through the spool 
  command.Today my package didn't run.  It had an error saying 'ERROR 
  at line 1: ORA-04068: existing state of packages has been discarded' 
  .  Anyway, not abig deal.  I think I eliminated the 
  error.The thing that puzzles me is that error IS NOT in the alert 
  log.  I had animpression that alert log would capture ALL of the 
  errors occurring on thesystem.  Isn't it the case?Thank you for 
  your support.Lyuda Hoska-- 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-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

alert log is not capturing all errors

[lhoska]

Hi List,
I have encountered a little strange incident.  Here is a brief:
I ran a package which runs every day early in the morning.  I create a log
of the process through the spool command.
Today my package didn't run.  It had an error saying 'ERROR at line 1: 
ORA-04068: existing state of packages has been discarded' .  Anyway, not a
big deal.  I think I eliminated the error.
The thing that puzzles me is that error IS NOT in the alert log.  I had an
impression that alert log would capture ALL of the errors occurring on the
system.  Isn't it the case?
Thank you for your support.

Lyuda Hoska
-- 
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: need to recreate database

[lhoska]

Thank you very much to all who replied to this post and the post about
oradim.  Mission was accomplished successfully and everybody is happy.

-Original Message-
Sent: Wednesday, July 11, 2001 10:09 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


Lyuda,

If I understand your post correctly, your networking
folks didn't install Oracle on the new server, but
instead just copied the directory structures over. 
This means you don't have any of the registry entries.
 While it is theoretically possible to export the
registry keys from one server and import them into
another, I would NOT recommend doing this - it's far
too easy to make a mistake somewhere and totally mess
things up.  Besides, Oracle Support will tell you
you're unsupported if you do so.

As long as the db was cleanly shut down when the files
were backed up you should be able to open the db OK.

1.  Install the software (select custom install and
don't have it create a starter db for you).

2.  Edit the init.ora and make any changes to
directory locations, as needed.

3.  Create the services for the db (see note: 61621.1
"WINNT/WIN2000 Recreating Oracle Services and
Instances from the Command Line")

4.  If the directory structures (datafiles, online
logs, etc...) and db_name will be the same on the new
server then you don't need to recreate the
controlfile.  If they need to change, see steps 1, 6,
& 8 of note: 73301.1 "How to make a copy of a database
on the same Windows NT machine"

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
> Hello,
> I need to recreate a database, basically make a
> complete copy of one of the
> existing databases on a new server.  My networking
> people already copied all
> datafiles, control file, log files, init file, etc
> to the target server.
> They also reproduced operating system directory
> structure.
> What I need to do is to make the second part of the
> task work, create the
> database, services, etc and make it run.
> I have not done it before and if I was doing it I
> would probably do
> export/import type of thing but the higher ups would
> like to have it done
> this way.
> One of the people has an idea suggesting just
> recreating the registry
> setting by exporting it from the existing machine to
> the new one.
> The other option is to reinstall Oracle but I am not
> sure how to make it to
> accept existing physical components(datafiles,
> control file, etc).
> If someone has a suggestion I would greatly
> appreciate it.
> Thank you in advance.
> 
> Lyuda Hoska
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
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).

oradim

[lhoska]

Can anyone point to oradim utility documentation?  I am having a little hard
time finding it.
Thank you.
Lyuda Hoska

-- 
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: Rename alert log

[lhoska]

Yes, it can.  Just rename it and there will be new one created with an old
name at some point.

-Original Message-
Sent: Tuesday, July 10, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

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

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

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

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

need to recreate database

[lhoska]

Hello,
I need to recreate a database, basically make a complete copy of one of the
existing databases on a new server.  My networking people already copied all
datafiles, control file, log files, init file, etc to the target server.
They also reproduced operating system directory structure.
What I need to do is to make the second part of the task work, create the
database, services, etc and make it run.
I have not done it before and if I was doing it I would probably do
export/import type of thing but the higher ups would like to have it done
this way.
One of the people has an idea suggesting just recreating the registry
setting by exporting it from the existing machine to the new one.
The other option is to reinstall Oracle but I am not sure how to make it to
accept existing physical components(datafiles, control file, etc).
If someone has a suggestion I would greatly appreciate it.
Thank you in advance.

Lyuda Hoska

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

temp tablespace is permanent tablespace

[lhoska]

Hi,
One of the generic users (multiple people use the same logon/password) on
one of my db's has been assigned temporary tablespace which is a permanent
tablespace type, i.e. 
(select contents from dba_tablespaces where tablespace_name=my_ts_name;
returns PERMANENT).   
I was told by let it stay that way. I am investigating the whole thing (just
for myself).  Is there any true reason why the user would need their temp
tablespace to be permanent?  Could my situation cause any major problems?
If so, what things I need keep my eye on in order to avoid them?
Thank you.
Lyuda Hoska
-- 
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).

sqlloader question

[lhoska]

Hello oradba's,
I have a general question about sqlloader.  
There is an option called ROWS.  According to Oracle Complete reference by
G.Koch and K.Loney ROWS is the number of rows to buffer together for an
insert and commit.  Default value is 64.
According to one of my coworkers specifying ROWS in combination with
LOAD=DIRECT is not a good idea.  Supposedly it will confuse and slow down
the load, possibly throw it to a non-direct load.  The theory is based on
the following idea:  during direct load sql loader is not supposed to count
and commit records.
Does it sound like true?

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

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

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

No Subject

[lhoska]

test
Lyuda Hoska
-- 
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: SUMMARY: BIG PROBLEM

[lhoska]

Why don't you cc: copy your e-mail to your HR.  Just one look at the subject
line will make them to realize what they've done... ;-)

-Original Message-
Sent: Friday, June 29, 2001 6:24 PM
To: Multiple recipients of list ORACLE-L


Does that mean you won't need an Oracle DBA anymore? :)

-Original Message-
Sent: Friday, June 29, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L


This worked great!!!

Thanks to all who replied!

-Original Message-
Applewhite
Sent: Friday, June 29, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L


Edward,

Your database backup is OK.  RMan just can't backup and delete the archived
redo logs that you moved.

If you want RMan to backup, then delete, those archived redo logs, you'll
have to move them back to the drive from which they came.  Then do another
backup.  If you've got lots of logs, it may take several "batches" to get
them all.

If you just want to go forward, with RMan backing up and deleting the logs
from now on, issue the following command at the RMan prompt:

 allocate channel for maintenance type disk;
 change archivelog all crosscheck;
 release channel;

That will cause RMan to "forget about" the archived redo logs you've moved,
but it will pick up with the logs that have since been created and are still
in the expected directory.

Good luck.

Jack


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


-Original Message-
Carr
Sent: Friday, June 29, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L


Hello all, I just joined this list today and am in need of desperate help!!!
In its infinite wisdom HR decided to lay off our only oracle dba!!!

I am trying to get some backups working on our database using rman.
It seems to backup our datafiles ok, but I am getting the following error
...

RMAN-03022: compiling command: backup
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not
found or out of sync with catalog

The problem here is twofold:
1) It is looking in the wrong directory for the archive logs
2) We have been moving old archive logs off of the server to another server
to keep the disk from filling up while we were working on this backup
problem, so I do not want it looking for the old logs.

As I am not a DBA I have no clue how to fix this, but it needs to be done
A.S.A.P.  ...

Thanks to anyone who can help me!!!

--
Edward W. Carr
UNIX Systems Administrator
Qwest Communications
Broadband Services Inc.


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

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

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

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

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

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

RE: Venkata's pc is back in line "VIRUS" messgaes again

[lhoska]

He finally got me, too.  I received one e-mail sent directly to me as a
reply to my yesterday's post to the list.  I blocked his e-mail but is there
anything we can do to refuse him access to the list for now?  It becomes
annoying, not to mention that if he is doing it on purpose he is the lowest
form of life on this Earth.
HELP

-Original Message-
Sent: Thursday, June 28, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I Just received 3 messages from Venlata Apparao that had virus's attached.
My mail server deleted the attachment. The mail was sent directly to me and
not the ORACLE-L list.
ROR mª¿ªm

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

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

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

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

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

[lhoska]

I think it might've been send directly because I did not receive any of the
infected e-mails from that individual.  Again I just joined the list
recently.  To refresh your memory, I also don't receive as many recruitment
adds as you guys do.  So, some people might've got a hold of the list
members before I joined the list.  Would you be able to determine if there
were other e-mails from that person sent to the list with Oracle related
questions or he/she is not even interested in Oracle but just a hacker?  Buy
the way, I don't have any of his/her e-mails...
Just a little FYI.

-Original Message-
Sent: Wednesday, June 27, 2001 4:23 PM
To: Multiple recipients of list ORACLE-L


I think I must have something confused here.

If this list removes attachments to avoid viruses, how does a virus in
an attachment come through the list?

I would think that it might be sent out directly. This makes some
sense as it seems that not everyone is receiving the same
attachment. At this point I haven't received any but since I
frequently receive messages out of order that does prove anything.


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

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

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

[lhoska]

I think Dual is a table.

  1  SELECT TABLE_NAME FROM SYS.DBA_TABLES
  2* WHERE TABLE_NAME='DUAL'
SQL> /

TABLE_NAME
--
DUAL

SQL> DESC DUAL
 NameNull?Type
 ---  
 DUMMYVARCHAR2(1)


-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
>You could always just run catalog.sql as sys.
>
>-Original Message-
>Sent: Tuesday, June 19, 2001 11:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Your email says duel. You created dual, with an a, right?
>
>And did you grant select on dual to public? And create a
>public synonym for it?
>
>HTH,
>
>Yosi
>
>
>Shirish Khapre wrote:
>
> > hi
> > i accidentally  dropped duel table from sys..then recreated it.
> > now when i am using rman during running the catrman.sql for
>recovery_catalog
> > it is flashing error
> >
> > select '08.00.05' from dual
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > u'r help is highly appreciated
> >
> > Shirish Khapre, SE Rolta India Ltd.
> > Off Ph No. (+91) (022) 832,826,8300568
> > Ext'n 2730
> > Minds are like parachutes. They only function when they are open
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shirish Khapre
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Thanks,
>
>Yosi
>
>
>-
>Yosi Greenfield
>Oracle Certified DBA
>[EMAIL PROTECTED]
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

[lhoska]

How about oradim and server manager?

-Original Message-
Sent: Friday, June 15, 2001 5:02 PM
To: Multiple recipients of list ORACLE-L


Trying to connect using INTERNAL via SQLPLUS.

Platform is Solaris 2.6, Oracle 9i.  Logged in as oracle user.  Oracle user
is a member of the dba group and CONNECT INTERNAL works fine in 8i.

See following error message for 9i:

ORA-09275: CONNECT INTERNAL is not a valid DBA connection

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, June 15, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Is it the same old rumor or it could be confirmed 100%?

-Original Message-
Sent: Friday, June 15, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Well you will have alot of scripts to change, internal is gone in 9i.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Friday, June 15, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L


Greg,

I was told by Oracle Support when I started using Rman under version 8.0 to
use SYS or INTERNAL, as it is "better".

Between you and me, "better" is quite subjective.  But, I wrote scripts that
connect as INTERNAL, and it has been working fine ever since, so I did not
re-visit it.

Do you use a DBA account?  Is there a better way?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, June 15, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L


Tom,

Why do you use SYS exclusively for startup and shutdown, since your DBA priv
account could also accomplish this?

- Greg

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

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

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

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

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

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

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

RE: SYS vs SYSTEM

[lhoska]

Is it the same old rumor or it could be confirmed 100%?

-Original Message-
Sent: Friday, June 15, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Well you will have alot of scripts to change, internal is gone in 9i.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Friday, June 15, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L


Greg,

I was told by Oracle Support when I started using Rman under version 8.0 to
use SYS or INTERNAL, as it is "better".

Between you and me, "better" is quite subjective.  But, I wrote scripts that
connect as INTERNAL, and it has been working fine ever since, so I did not
re-visit it.

Do you use a DBA account?  Is there a better way?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, June 15, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L


Tom,

Why do you use SYS exclusively for startup and shutdown, since your DBA priv
account could also accomplish this?

- Greg

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

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

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

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

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

[lhoska]

FYI,
I am on the list and not on newsgroup and I did not receive that message.
Another clue:  I had joined just recently so it might've been some time ago
some one got a hold of the list..

-Original Message-
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

->FYI,
->
->I got one of these at home, but not at work.
->
->At home I have logged into the oracle.server newsgroup, but never Jared's
->list.
->
->At work I subscribe to Jared's list, but never went to the newsgroup.
->
->This tells me that unless I received the e-mail at work as well and didn't
->notice, our addresses were lifted off the newsgroup and not this list.
->
->Another reason why I don't like newsgroups all that much.

except i got 2 and never go to the newsgroup.;-) but i did go to lazyDBA for
a few hours.

--
Bill "Shrek" Thater   Certifiable 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.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

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

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

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

RE: HELP !!! scrpt works with sql plus but not in a procedure

[lhoska]

It may not be the real fix but you need a space before 'RECEIVED'
on line 3.
line 3: SUM(INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY) RECEIVED.

Another thing: you don't need to say ALL in your select.  ALL is a default.


-Original Message-
Sent: Wednesday, June 13, 2001 5:52 PM
To: Multiple recipients of list ORACLE-L


I have this script that works fine in sql plus but when I attach it to a
procedure in my report it gives me an error

"error 101 Encountered a symbol SELECT when expecting one of the
following"
The error surfaces when the bolded line (choosing the date) is included in
the script.
What is the possible fix for this?

INSERT INTO AWW_ISSUED
SELECT ALL INV.MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID,
SUM(INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY)RECEIVED
FROM INV.MTL_MATERIAL_TRANSACTIONS
WHERE (INV.MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID=3
AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID IN (1, 31, 32,
33,
34, 36, 40, 41, 42, 18, 2, 50, 51, 12, 61, 21, 4, 80)
AND INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY > 0)
AND  INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE BETWEEN
'01-JUN-01' AND
'30-JUN-01'
AND  INV.MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE BETWEEN (SELECT
TO_DATE('01' || SUBSTR(TO_CHAR(SYSDATE),3,9)) FROM DUAL)AND
(SELECT
LAST_DAY(SYSDATE) FROM DUAL)
GROUP BY INV.MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID;

I appreciate all the help


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

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

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

[lhoska]

'The Soviet Union does not exist any more in its present format'.

What is that suppose to mean?  Just curious...

-Original Message-
Sent: Tuesday, June 12, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L


On Tue, 12 Jun 2001,Thater, William scribbled on the wall in glitter crayon:
->well, i'm jealous.  i could use some.  my aunt died from breast cancer
over the weekend and the funerial was today.

oh damn, this was not supposed to go to the list.  i'm sorry for bothering
everyone with my personal stuff.  put it down to lack of single malt.;-)

--
Bill "Shrek" Thater   Certifiable 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.
~~
The Soviet Union does not exist any more in its present format.

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

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

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

[lhoska]

I am not sure what you're trying to do but look at the possibility of using
dbms_output.put_line(...) in your pl/sql code.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Hi Harvinder!

Sorry - no, you can't  use these commands inside PL/SQL. 
"set feedback on|off "  and alike are not SQL statements, but extensions
outside SQL ( indicated by SQL*PLUS )
only available in the SQL*PLUS executables , but not in the PL/SQL or SQL
engines of your
Oracle clients or servers ( You can execute these commands without being
connected to an Oracle instance).

Does your application invoke SQL*PLUS?

If yes, your application could invoke SQL*PLUS to build dynamically a script
and
then execute the script which contains the call to your procedure and 
embeds the  "set feedback ..." commands.

I need more information about what your program should do to, to get a
chance to help you a little bit more.


Andreas
> --
> Von:  Harvinder Singh[SMTP:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 12. Juni 2001 01:50
> An:   Multiple recipients of list ORACLE-L
> Betreff:  set feedback off in procedure
> 
> Hi,
> 
> Can we use the following commands inside the pl/sql procedure.(due to
> application requirement)
> 
> set feedback off 
> 
> set fedback on
> 
> If yes at what point in procedure.
> 
> Thanks
> 
> Harvinder
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haunschmidt Andreas VASL/FAS
  INET: [EMAIL PROTECTED]

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

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

FW: userenv error

[lhoska]

Please disregard my posting.  The problem is resolved.

>  -Original Message-
> From: Lyuda Hoska  
> Sent: Thursday, June 07, 2001 4:20 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  userenv error
> 
> Hi,
> Some one (probably developers) dropped number of our application specific
> tables used for user's application log on.  
> Not nice of them but at least they did it on their own test database.  If
> they did it on production db it would be more stressful.
> At this point tables have been restored.
> Now when attempting to log on to the application user's get this error:
> ORA-02003: invalid USERENV parameter 
> Cause: An invalid parameter was specified for the USERENV function. 
> Action: Specify one of the allowable parameters TERMINAL, SESSIONID,
> ENTRYID, or NLS_LANG.
> Please bring some light to my problem.
> Thank you very much. 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

userenv error

[lhoska]

Hi,
Some one (probably developers) dropped number of our application specific
tables used for user's application log on.  
Not nice of them but at least they did it on their own test database.  If
they did it on production db it would be more stressful.
At this point tables have been restored.
Now when attempting to log on to the application user's get this error:
ORA-02003: invalid USERENV parameter 
Cause: An invalid parameter was specified for the USERENV function. 
Action: Specify one of the allowable parameters TERMINAL, SESSIONID,
ENTRYID, or NLS_LANG.
Please bring some light to my problem.
Thank you very much. 


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

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

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

RE: what to put in place of null

[lhoska]

Try applying data conversion function to_char/to_date or nvl function if dd
and dd1 are numbers to the nulls in the second select.
Example:

cursor c1 is 
select dd,dd1,dd2,dd3 from dd
union
select to_char(null),to_char(null),dd2,dd3 
from dd1;

The point here is you need to have as many columns in your second select
statement as your first select has  and the datatypes have to match. 

-Original Message-
Sent: Tuesday, June 05, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a cursor declared as 
cursor c1 is 
select dd,dd1,dd2,dd3 from dd
union
select null,null,dd2,dd3 from dd1;

i am getting error:
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at "DY.REST", line 4
ORA-06512: at "DY.REST", line 10
ORA-06512: at line 1

what to replace null with..
dd1 has only 2 columns dd2 and dd3.

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

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

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

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

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

[lhoska]

This 
will work:
RENAME TABLE_NAME TO table_name_2; 

create table TABLE_NAMEas select * 
from table_name_2;
DROP TABLE table_name_2;
Note you 
don't need to issue a 'commit' after after create table or drop table.  
Also, when you do create table as select from another table there is no need to 
specify the columns.  The new table you created will have the same columns 
as the tables you're selecting your data from.

  -Original Message-From: Helen rwulfjeq 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 05, 2001 3:45 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Renaming columns ...
  will this work? 
  RENAME TABLE_NAME TO table_name_2; 
  create table TABLE_NAME( column_name_you_want...)as select * 
  from table_name_2;COMMIT; 
  DROP TABLE table_name_2;COMMIT; 
  HTH 
    "Deshpande, Kirti" <[EMAIL PROTECTED]> 
  wrote: 
  Hi 
Raj,1. There is a way to do it. And Mr. Steve A. has some good info 
about it (&its implications) on his web site. (Sorry I do not have a 
direct URL link toit). I believe this works for all versions. 2. 
Yes, it does. I have played with it on my test database.However, I 
will not do this on a Production database as it involves adirect DML to 
modify sys.COL$. And Oracle does not recommend doing suchthings to your 
databases. I am not sure if renaming column is supported in 9i. 
Anyone else know forsure? If you are using 8i, the safe way to 
address this is to add a new column tothe table, populate it with the 
contents from the old, and drop the oldcolumn. If the column is not 
nullable, and if there are plenty of nullablecolumns towards the end of 
the table, I suggest considering reorganizationof the table. I just did 
that (! ! reorg) in the last couple of weeks with a60Mil row table to 
get the new & not nullable columns towards the 'head' ofthe table. 
HTH,Regards,- Kirti Deshpande Verizon 
Information Serviceshttp://www.superpages.com> -Original 
Message-> From: Jamadagni, Rajendra 
[SMTP:[EMAIL PROTECTED]]> Sent: Monday, June 04, 2001 8:51 
AM> To: Multiple recipients of list ORACLE-L> Subject: 
Renaming columns ...> > Hi all,> > although I am 
searching information on Metalink and OTN, I just want to> 
ask> this question to the list ...> > 1. Is it possible 
to rename a column? (we have lots of columns that need> to> be 
renamed). Which version supports it?> 2. Does renaming automatically 
takes care of indexes?> > Coding will be a lot of manual 
labor, but that's okay we can handle it.> > Thanks in advanc! 
! e> Raj> 
__> Rajendra 
Jamadagni MIS, ESPN Inc.> Rajendra dot Jamadagni at ESPN dot 
com> Any opinion expressed here is personal and doesn't reflect that 
of ESPN> Inc.> > QOTD: Any clod can have facts, but 
having an opinion is an art !> -- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- Author: Deshpande, 
KirtiINET: [EMAIL PROTECTED]Fat City Network Services 
-- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public 
Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from). You mayalso send the! ! HELP 
command for other information (like subscribing).
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! 
Mail.

RE: How to prevent oracle from committing a transaction?

[lhoska]

Commit will take place after any DDL statement.  Besides that, Oracle
Complete Reference by George Koch and Kevin Loney states that commit will
occur after you execute the following commands: exit, quit, and even
connect.
If you are worried about unmanaged commits after the sudden instance crash
then don't worry it won't happen. Oracle will roll everything back after the
instance comes back up.  As to commits occurring due to the 'exit' command
it seems it is not possible to stop.  But you have control in that
situation.  Just before typing 'exit' type 'rollback' and no changes will
take place.
Hope this helps, and please correct me if I am wrong.

-Original Message-
Sent: Tuesday, June 05, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L



Wait a minute here.

Why would oracle do a commit on your transaction
just because it needs to do a checkpoint, logfile switch, or shutdown?

What if errors occur during validation?

Do you think Oracle will commit the data anyways?


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

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

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

[lhoska]

Raj,
don't do it.  The statement below is supported by a VERY special version or
Oracle.  
It won't work for the most of us ;-)

-Original Message-
Sent: Monday, June 04, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L


ALTER TABLE table_name MODIFY ( new_col_name DATATYPE);

It works for me in 8i.


 



-Original Message-
Sent: Monday, June 04, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Chris:

I've been browzing the on-line docs for 9i and the release notes and have
seen nothing about renaming a column...can you point me to the location in
the docs that give the syntax?

Thanks
Kevin

-Original Message-
Sent: Monday, June 04, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L


Yes renaming a column is supported, in fact you can change almost every
aspect of a table online.
it works parallel to existing table, right before switching them over, it
gets the latest DML applied, then switches over.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Monday, June 04, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Hi Raj,
 1. There is a way to do it. And Mr. Steve A. has some good info about it (&
its implications) on his web site. (Sorry I do not have a direct URL link to
it). I believe this works for all versions. 
 2. Yes, it does. I have played with it on my test database.

 However, I will not do this on a Production database as it involves a
direct DML to modify sys.COL$.  And Oracle does not recommend doing such
things to your databases. 

I am not sure if renaming column is supported in 9i. Anyone else know for
sure? 

If you are using 8i, the safe way to address this is to add a new column to
the table, populate it with the contents from the old, and drop the old
column. If the column is not nullable, and if there are plenty of nullable
columns towards the end of the table, I suggest considering reorganization
of the table. I just did that (reorg) in the last couple of weeks with a
60Mil row table to get the new & not nullable columns towards the 'head' of
the table.  

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 04, 2001 8:51 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Renaming columns ...
> 
> Hi all,
> 
> although I am searching information on Metalink and OTN, I just want to
> ask
> this question to the list ...
> 
> 1. Is it possible to rename a column? (we have lots of columns that need
> to
> be renamed).  Which version supports it?
> 2. Does renaming automatically takes care of indexes?
> 
> Coding will be a lot of manual labor, but that's okay we can handle it.
> 
> Thanks in advance
> Raj
> __
> Rajendra JamadagniMIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
> 
> QOTD: Any clod can have facts, but having an opinion is an art !
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: who locked table??

[lhoska]

select username, sid, serial#, status from v$session; 
alter system kill session \',\'; 

Also, you can use ORAKILL utility.

select sid, spid thread, osuser, s.program 
from sys.v_$process p, sys.v_$session s 
where p.addr = s.paddr; 
C:\>orakill  
--
The script below gives you a lot of detailed information about your lock.

set linesize 132 pagesize 66 
break on Kill on username on terminal 
column Kill heading 'Kill String' format a13 
column res heading 'Resource Type' format 999 
column id1 format 990 
column id2 format 990 
column lmode heading 'Lock Held' format a20 
column request heading 'Lock Requested' format a20 
column serial# format 9 
column username format a10 heading "Username" 
column terminal heading Term format a6 
column tab format a35 heading "Table Name" 
column owner format a9 
column Address format a18 
select nvl(S.USERNAME,'Internal') username, 
nvl(S.TERMINAL,'None') terminal, 
L.SID||','||S.SERIAL# Kill, 
U1.NAME||'.'||substr(T1.NAME,1,20) tab, 
decode(L.LMODE,1,'No Lock', 
2,'Row Share', 
3,'Row Exclusive', 
4,'Share', 
5,'Share Row Exclusive', 
6,'Exclusive',null) lmode, 
decode(L.REQUEST,1,'No Lock', 
2,'Row Share', 
3,'Row Exclusive', 
4,'Share', 
5,'Share Row Exclusive', 
6,'Exclusive',null) request 
from V$LOCK L, 
V$SESSION S, 
SYS.USER$ U1, 
SYS.OBJ$ T1 
where L.SID = S.SID 
and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2) 
and U1.USER# = T1.OWNER# 
and S.TYPE != 'BACKGROUND' 
order by 1,2,5 
/ 


-Original Message-
Sent: Friday, June 01, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Hi Friends

Does any body have script to see who locked the table and subsequently If 
needy to kill the user?? I had it but I want to update mine.

TIA
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

[lhoska]

I am running multiple Oracle 7.3-8i databases on NT.  Is there someone on
this forum who can answer my question:which parameter I need to set up to
increase the file size limit?  I have a feeling there may not be one.
I was told by one of the super-senior Oracle people :-) there is an Oracle
(not NT) bug with Oracle versions below 8i which creates problems with
datafiles above 2G size.
Thank you.

-Original Message-
Sent: Thursday, May 31, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


On our old AIX system we had to set a system parameter for the file system
that allowed us to have files bigger than 2 GB.  I do not know if your
system has something like that.

-Original Message-
Sent: Thursday, May 31, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L


What do you mean by 'the system is not set up'.  How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit.  Is it documented?
Please explain.  Thank you.

-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


If the system is not setup to allow files bigger than 2 GB then the
datafiles WILL NOT EXTEND and you will get an oracle error.

-Original Message-
Sent: Thursday, May 31, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?

. 

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

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

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

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

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

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

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

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

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

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

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

RE: Auto Extend

[lhoska]

What do you mean by 'the system is not set up'.  How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit.  Is it documented?
Please explain.  Thank you.

-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


If the system is not setup to allow files bigger than 2 GB then the
datafiles WILL NOT EXTEND and you will get an oracle error.

-Original Message-
Sent: Thursday, May 31, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


I have taken over an Oracle database that is setup with autoextend on the
tablespaces.  Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?

. 

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

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

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

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

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

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

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

RE: simple question

[lhoska]

Problem resolved.  Oracle 8 Complete Reference I was using contains an
incorrect syntax.  They use MAXSIZE instead of SIZE in the syntax.
Thank you to all of those who replied.

-Original Message-
Sent: Tuesday, May 29, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L


Does any one have an example of 'alter tablespace add datafile'
statement?  I am having a little trouble..
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: 
  INET: [EMAIL PROTECTED]

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

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

[lhoska]

Does any one have an example of 'alter tablespace add datafile'
statement?  I am having a little trouble..
Thank you.




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

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

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

RE: Script and control file

[lhoska]

If it is NT you can create a batch file similar to Unix example given below
which will do the same.  The only difference here is you'll have to save
your sqlplus scripts in a text or *.sql format and call them from the batch
file.  After that you can call sqlloader.


-Original Message-
Sent: Tuesday, May 29, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L


Andrea,

Is this UNIX or NT.

In UNIX ( I don't know NT that well), the most simple method would be to use
a shell script.

The following is about as basic as it comes but would need to be embellished
with environment settings and error checking etc..

eg.

Start of Script


sqlplus username/passwd <

sqlplus username/password