Procedure to insert the data

[zircon06]

I have bunch of insert data into tables. These scripts are failing if I running as individual scripts. I'm Looking to ways to run insert data scripts in unix environmnet. If I want run a single concat file how to do it.

Thanks in advance

 

[SantaMufasa]

...These scripts are failing...

Sorry, Zircon, we are Oracle experts, not Oracles...we have no crystal ball to devine what you mean by "failing"...Are you receiving:

1) Syntax errors
2) Run-time errors, or
3) Logic errors?

...and, whichever the error, we need to see a copy and paste of the error message (for syntax or run-time errors) or the fault results (for logic errors).

Once you post the evidence of your problem AND the code at the beginning and the end of each script (including one or more sample INSERT statements that cause your problems) then we can offer more help.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]