Home » RDBMS Server » Server Administration » Insert scripts in flat file to be executed
Insert scripts in flat file to be executed [message #56718] Fri, 18 April 2003 14:53 Go to next message
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 flat file to be executed [message #56721 is a reply to message #56718] Fri, 18 April 2003 15:19 Go to previous messageGo to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
What kind of a script has 3.2GB worth of DDL ???!!

The only way I can think of is to break the script down and run them.

Sorry , cudn't help much...
A

Report message to a moderator

Re: Insert scripts in flat file to be executed [message #56726 is a reply to message #56718] Sun, 20 April 2003 13:43 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Helo,
Which errors are coming when doing the operation ?
are u in the Unix box and hitting the 2GB issue ?

sai

Report message to a moderator

Re: Insert scripts in flat file to be executed [message #56732 is a reply to message #56718] Mon, 21 April 2003 08:27 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Most of the new UNIX OS can go beyond the 2GB limit. And specially if Oracle is installed, this could have been set to true (ulimit=unlimited).

What is the actual error you are getting, if any.

Report message to a moderator

Previous Topic: Performance tuning
Next Topic: migrating oracle 8 to oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 29 14:28:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.