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

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 12 Jul 1999 08:14:21 -0400
Message-ID: <3789DC1D.F5C2822A@Unforgettable.com>

Do you have such a tablespace in your database? Do you have quotas for that tablespace?

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 Mon Jul 12 1999 - 07:14:21 CDT