SP2 error

How do I investigate the following error? SP2-0735: unknown SET option beginning column_name=... 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

RE: SP2 error

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

optimizer_mode/optimizer_rule

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

RE: RE: sqlplus question

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

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

RE: sqlplus question

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-

RE: How to calculate Last and First Day of Month?

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

sqlloader question

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

RE: HOW TO MAKE DELETION FAST

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

RE: SQL Loader Load Problem

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

how to pass argument to a dos batch program from sqlplus

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

RE: Not able to view table

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

RE: NT Scheduler !!

'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

data modeling processes

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:

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

RE: environmental variables

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

RE: user holding session even after a re-boot

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

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]

RE: Speed up Truncate tables

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:

RE: Speed up Truncate tables

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

RE: Lost of all Control Files

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

RE: having select from db link problems from 8.0.5.2.1

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

RE: OT -- training

are the right 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

RE: OT -- training

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

RE: OT -- training

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:

RE: closing DB on NT with a scheduled BATCH FILE

or use oradim... oradimxx.exe -shutdown -sid sid -usrpwd password -shuttype inst -shutmode i oradimxx.exe -startup -sid sid -usrpwd password -starttype inst -pfile path\initsid.ora -Original Message- Sent: Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L 1.

RE: OT Dorothy Parker :)

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

RE: closing DB on NT with a scheduled BATCH FILE

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

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

RE: sqlloader stops

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 intothe game of 20

sqlloader stops

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

RE: sqlloader stops

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

RE: sqlloader stops

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

huge datafiles/need help

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

RE: Using AT command in NT

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

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

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

RE: OT about to peeve off the vegatarians: RE: OT RE: Largest

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

RE: sqlloader process dies

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 ??

RE: sqlloader process dies

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

RE: how to clean NT services ???

Preferable solution: ORADIMxx -DELETE -SID SID xx will depend on your version or Oracle or ORADIMxx -DELETE -SRVC service_name service_name is your service name Alternative solution: In your registry settings. Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, and remove all keys

RE: setting DbName in SQL*PLUS

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:

FW: setting DbName in SQL*PLUS

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:

RE: How to search all tables for a particular field?

select table_name, column_name from sys.dba_tab_columns where column_name like 'your_column_name%'; -Original Message- Sent: Thursday, July 19, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Hi, I am looking for a particular field if it exists in a database. How to search

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

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

RE: Last Update

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

private/public rollbacks

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)

RE: alert log is not capturing all errors

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

RE: need to recreate database

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,

need to recreate database

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

RE: Rename alert log

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

oradim

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

temp tablespace is permanent tablespace

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

No Subject

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

RE: SUMMARY: BIG PROBLEM

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? :)

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

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

RE: virus question

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

RE: duel error

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 --- DUMMY

RE: SYS vs SYSTEM

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

RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

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

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

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

RE: set feedback off in procedure

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

RE: apology

'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

RE: How to prevent oracle from committing a transaction?

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

RE: Renaming columns ...

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

RE: what to put in place of null

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

RE: Auto Extend

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

RE: Auto Extend

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

RE: Script and control file

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-

simple question

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

RE: simple question

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