SQL Plus & Creating tables from SQL Files

SQL Plus & Creating tables from SQL Files

Post by Daniel Suare » Sun, 31 Dec 1899 09:00:00



How do you suggest I do this for several files that are over 6000 lines long
each? :o) If the "/" has to be on the next blank line I can't do a search
and replace using notepad becase it does not allow me to insert a carriage
return. Is there a better text editor out there that will allow me to do
this?

Daniel

-----Original Message-----

Sent: Wednesday, August 16, 2000 9:29 AM
To: Daniel Suarez
Subject: Re: SQL Plus & Creating tables from SQL Files

You need to remove the ';' and put a '/' on the following blank line. This
will cause the statement to execute. ';' is specifically for SQL*Plus to
execute a statement at the end of the line.
----- Original Message -----

Newsgroups: comp.databases.oracle.server
Sent: Tuesday, August 15, 2000 3:50 PM
Subject: SQL Plus & Creating tables from SQL Files

> Attached is an SQL file that I am trying to run from Oracle 8i from the
SQL
> Plus tool. I am very new to Oracle. However, the errors that I am
receiving
> make no sense - for instance - the first error I receive is invalid
> character on the ";" of the first create statement. If I were to remove
the
> ";" then the statement will not get executed. The file is over 6000 lines
> long. I cannot copy and paste the entire file into SQL Plus because it
does
> not execute all the statements - only about 100 lines worth.

> What am I missing here? Any other ways of executing the SQL files other
than
> SQL Plus?

> Daniel

 
 
 

SQL Plus & Creating tables from SQL Files

Post by Daniel Suare » Sun, 31 Dec 1899 09:00:00


I've tried this, twice already, since it was suggested by a couple of folks.
It does not work. SQL+ returns:

ORA-00922: missing or invalid option

Referring to the missing ";"

Daniel


> How do you suggest I do this for several files that are over 6000 lines
long
> each? :o) If the "/" has to be on the next blank line I can't do a search
> and replace using notepad becase it does not allow me to insert a carriage
> return. Is there a better text editor out there that will allow me to do
> this?

> Daniel

> -----Original Message-----

> Sent: Wednesday, August 16, 2000 9:29 AM
> To: Daniel Suarez
> Subject: Re: SQL Plus & Creating tables from SQL Files

> You need to remove the ';' and put a '/' on the following blank line. This
> will cause the statement to execute. ';' is specifically for SQL*Plus to
> execute a statement at the end of the line.
> ----- Original Message -----

> Newsgroups: comp.databases.oracle.server
> Sent: Tuesday, August 15, 2000 3:50 PM
> Subject: SQL Plus & Creating tables from SQL Files

> > Attached is an SQL file that I am trying to run from Oracle 8i from the
> SQL
> > Plus tool. I am very new to Oracle. However, the errors that I am
> receiving
> > make no sense - for instance - the first error I receive is invalid
> > character on the ";" of the first create statement. If I were to remove
> the
> > ";" then the statement will not get executed. The file is over 6000
lines
> > long. I cannot copy and paste the entire file into SQL Plus because it
> does
> > not execute all the statements - only about 100 lines worth.

> > What am I missing here? Any other ways of executing the SQL files other
> than
> > SQL Plus?

> > Daniel


 
 
 

1. Oracle*&SQL*Plus 8.0/Net8 versus Designer&SQL*Plus 3.x/SQL*Net

Hello all,

I've read in an Oracle white paper about the subject, it was written that
"Oracle*&SQL*Plus 8.0 use Net8 as a connection and Designer&SQL*Plus 3.x/SQL
use SQL*Net".
My question is what do I have to install/configure on the client Designer
side and on the server Oracle 8 side ?.

DAn G.

2. PowerBuilder vs. MS-SQL problem?

3. SQL Plus 3.3 vs. SQL Plus 8.0

4. Sql Transaction Analysis for System XI migration or performance & tuning

5. SQL-CREATE-TABLE & D3

6. Primary Node Recovery

7. create temp table: -261 Cannot create file for table - Not owner

8. Attach data to ADO recordset items

9. Create flat files from SQL Server table

10. create a cvs file using sql table