can't load table from SQL file

[varocho]

I have a 1000+-line file of SQL INSERT statements for loading a table. I can copy-and-paste 30 lines from the file into SQL*PLUS at a time, and that works, but I'd rather just open the file in SQL*PLUS directly and load the table directly. But the table doesn't get loaded at all, even though autocommit is turned on. Any ideas as to what I'm doing wrong?

 

[SantaMufasa]

Var8,

Can we see a couple of representative lines of code?...Perhaps the first couple of lines and the last couple of lines in the script?

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

 

[varocho]

Turns out clicking the 'File'-'Open' menu item just displays the contents of the file, it doesn't run it.

I found out how to run the script from within SQL*PLUS from this Web page:

http://www.techonthenet.com/oracle/questions/script.php

Here's part of that page:

"To execute a script file in SQLPlus, type @ and then the file name.

SQL > @{file}
"

Maybe I should just change my user ID to 'OracleN00b'

 

[Thargy]

maybe so Varocho, but definitely not just "Noob".

You have taken the trouble to do some digging yourself and find out "how". Second, you've had the courtesy to let us know the outcome.

Both of these mark you as maybe being new to Oracle, but not new to posting on a forum.

I appreciate the courtesy.

Regards

T

Grinding away at things Oracular

 

[SantaMufasa]

I Second Tharg's motion !.

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

 

[varocho]

Thanks for the kind words, guys.