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 r
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
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)
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
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
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 Service
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 t
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 worl
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
fo
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 S
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
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
'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 resour
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 sho
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.
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
Sim
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 Inte
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 Con
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
--- ---
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: Multi
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]
-
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 i
ot;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
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 Messa
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
PMT
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
n
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
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
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
cont
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 questio
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 PROTE
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
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
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 s
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 ca
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 far
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
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
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
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 P
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 ??
-Origina
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
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: Lyu
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
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 D
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 h
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 clarificat
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-505
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 us
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 package
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,
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 Dieg
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 off
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
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 t
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
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
-
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? :)
-
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
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
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
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 an
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 a
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
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
'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:
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
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
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
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 i
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 t
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
t
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 wor
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:
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
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 y
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 h
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
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-
Se
79 matches
Mail list logo