Re: Oracle 7.3: problem running SQL script with SQL*Plus

If the tablespace name is truely mixed case (check sys.dba_tablespaces) then you'll have to enclose the tablespace name in double quotes. I know there will be those who disagree with me but Oracle named objects (tables, tablespaces, indexes, columns, etc.) should never be anything except uppercase

Ken

Bernd Rosenau wrote:

> Hi,
>
> when trying to run the ACCESS-to-Oracle migration assistant generated
> scripts, I get error messages like ORA-00933: SQL-Command incorrect
>
> Here is a sample code sequence:
>
> CREATE TABLE EMPFD001 (
> VORG_NR NUMBER ( 11, 0) NULL,
> IDENT VARCHAR2 ( 25) NULL,
> BEZ1 VARCHAR2 ( 30) NULL,
> MENGE NUMBER ( 11, 0) NULL,
> STATUS VARCHAR2 ( 1) NULL,
> FREIGABE NUMBER ( 11, 0) NULL,
> ERBENUID VARCHAR2 ( 20) NULL,
> ERDATUM DATE NULL,
> AEBENUID VARCHAR2 ( 20) NULL,
> AEDATUM DATE NULL
> )
> TABLESPACE T_n07_ora
> / => this is the line that causes the error
>

>
Received on Tue Jul 13 1999 - 06:53:24 CDT