OraFAQ Forum: Server Utilities » ORA-00600 while data insertion through SQLLDR

Home » RDBMS Server » Server Utilities » ORA-00600 while data insertion through SQLLDR (ORACLE 9i -- SOLARIS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600 while data insertion through SQLLDR [message #361352]

Wed, 26 November 2008 01:06

pankajkmeena
Messages: 46
Registered: September 2007

Member

I am getting below error while data Upload using SQLLDR

Record 16: Rejected - Error on table GLIF.
ORA-00600: internal error code, arguments: [ktspgsb-1], [], [], [], [], [], [], []

However i am able to insert manually in that table.

Database is opened properly. No error in alert log file execept that comes during Upload of data through SQLLDR.

Is it a bug or something else (like Inter proccess communication).

Thankx in advance for your reply.

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361357 is a reply to message #361352]

Wed, 26 November 2008 01:16

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug - the first argument is the internal error number

Show us what you are trying to do ?

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361359 is a reply to message #361357]

Wed, 26 November 2008 01:22

pankajkmeena
Messages: 46
Registered: September 2007

Member

Inserting Data from a Flat File to table using sqlldr.
same is working fine 2 days ago.
Due to some problem PC was rebooted (normally) 2 days ago.
After that this problem start comming.

Oracle is now Up

However there was some problem in bringing up oracle earlier as disk containg datafile showing some error during rebooting of Pc.
But now that is solved.

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361363 is a reply to message #361359]

Wed, 26 November 2008 01:28

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

Show us what you are trying to do ?

Quote:

Inserting Data from a Flat File to table using sqlldr.

Well that is quite clear....
By the word show, I mean provide an example...

Quote:

same is working fine 2 days ago.

So "something" has happend to your environment

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361365 is a reply to message #361352]

Wed, 26 November 2008 01:44

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361386 is a reply to message #361363]

Wed, 26 November 2008 03:14

pankajkmeena
Messages: 46
Registered: September 2007

Member

physical volume is remaped
Also when i am running long query it is giving below error

     *
ERROR at line 2:
ORA-08103: object no longer exists

[Updated on: Wed, 26 November 2008 03:16]

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #361427 is a reply to message #361359]

Wed, 26 November 2008 06:23

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

pankajkmeena wrote on Wed, 26 November 2008 08:22

However there was some problem in bringing up oracle earlier as disk containg datafile showing some error during rebooting of Pc.
But now that is solved.

Doesn't seem like that if you are getting ORA-08103

An incomplete recovery perhaps ?

[Updated on: Wed, 26 November 2008 06:23]

Report message to a moderator

Re: ORA-00600 while data insertion through SQLLDR [message #362214 is a reply to message #361427]

Mon, 01 December 2008 05:52

pankajkmeena
Messages: 46
Registered: September 2007

Member

Our database is running in noarchievelog mode

Also V$RECOVER_FILE view doesnot shows any file that requires recovery

Report message to a moderator

Previous Topic:	Import of a schema, without the its data
Next Topic:	Exporting from Access to Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:26:50 CDT 2024