Oracle 7.3: problem running SQL script with SQL*Plus

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Mon, 12 Jul 1999 13:00:43 GMT
Message-ID: <3789e582.6101233@news.neckar-alb.de>

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

CREATE TABLE LLOGD001 (

             VORG_NR                        NUMBER   ( 11, 0)   NULL, 
             MELDID                         VARCHAR2 (     4)    NULL,

             IDENT                          VARCHAR2 (    25)    NULL,

             AS_TYP                         VARCHAR2 (     1)    NULL,

             LPLA                           VARCHAR2 (    21)    NULL,

             INFO_LZL                       VARCHAR2 (     1)    NULL,

             VORG_TYP                       VARCHAR2 (     1)    NULL,

             KOM_NR                         VARCHAR2 (    30)    NULL,

             KOM_POS                        VARCHAR2 (     4)    NULL,

             AUFT_NR                        VARCHAR2 (    30)    NULL,

             AUFT_POS                       VARCHAR2 (     4)    NULL,

             WE_BELEG                       VARCHAR2 (    20)    NULL,

             SNR                            VARCHAR2 (     4)    NULL,

             SENDEN                         VARCHAR2 (     1)    NULL,

             ME_SOLL                        NUMBER   ( 38, 2)    NULL,

             ME_IST                         NUMBER   ( 38, 2)    NULL,

             ME_LPLA                        NUMBER   ( 38, 2)    NULL,

             ME_GESAMT                      NUMBER   ( 38, 2)    NULL,

             ERBENUID                       VARCHAR2 (    20)    NULL,

             ERDATUM                        DATE                 NULL,

             UEBENUID                       VARCHAR2 (    20)    NULL,

             UEDATUM                        DATE                  NULL

)
TABLESPACE T_n07_ora
/
CREATE TABLE LORTD001 (

             LORT                           VARCHAR2 (     4)     

etc.

What goes wrong ?

Many thanks in advance,

Cheers, Bernd. Received on Mon Jul 12 1999 - 08:00:43 CDT