OraFAQ Forum: Server Utilities » Insert scripts in a flat file to be excuted

Home » RDBMS Server » Server Utilities » Insert scripts in a flat file to be excuted

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

Insert scripts in a flat file to be excuted [message #72231]

Fri, 18 April 2003 14:51

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
I have .dat file having INSERT scripts to insert a data into a table.But the file is of 3.21GB.So how can i execute this file so that the data can be inserted into a table.
Here i am not supposed to split and run the scripts page by page.
I dont have stream data or any delimiter separated file for this table data.

Please provide me the way to solve this problem?
Thanks in Advance
~V~

Report message to a moderator

Re: Insert scripts in a flat file to be excuted [message #72234 is a reply to message #72231]

Sun, 20 April 2003 07:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

depends.
you can write a script to strip away the datafieds, and create a flat file(so that you can load the text file using sqlldr).
We have done this before using awk (but definatly not of this magnitute..ie. 3 gb files)

Report message to a moderator

Previous Topic:	Lotus notes to oracle --migration
Next Topic:	Loading data with double quotes and quotes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 06:25:23 CDT 2024