Having problem running sql script file
Hello,
I had been trying to run a sql script file using @c:\xeschema.sql in my win XP. But I kept getting "ORA-00900: invalid SQL statement" in the SQL Command.
This file only has 2 create table statement as follows:
CREATE TABLE OASIS.AMX_COMPANY_TABLE (
CODE CHAR(10) NOT NULL,
NAME CHAR(125),
ADDRESS CHAR(200),
CITY CHAR(25),
STATE CHAR(25),
COUNTRY CHAR(25),
POSTCODE CHAR(10),
PHONES CHAR(25),
FAX CHAR(25),
REGISTRATION_NUMBER CHAR(35),
FUNCTIONAL_CURRENCY_CODE CHAR(5) NOT NULL,
CURRENCY_DESCRIPTION CHAR(25),
GLX_RETAIN_EARNING_CODE CHAR(25),
GLX_SUSPENSE_ACCOUNT_CODE CHAR(25),
GLX_JOURNAL_AUTO_SUSPENSE CHAR(1) DEFAULT 'N' NOT NULL
CONSTRAINT ORA80 CHECK (GLX_JOURNAL_AUTO_SUSPENSE IN ('Y','N')),
GLX_CONV_PERIOD_CODE VARCHAR2(10),
GLX_OPENING_BAL_POSTED CHAR(1) DEFAULT 'N' NOT NULL
CONSTRAINT ORA81 CHECK (GLX_OPENING_BAL_POSTED IN ('Y','N')),
STATUS_CODE INTEGER DEFAULT 0 NOT NULL,
CONSTRAINT PK_ORA82 PRIMARY KEY (CODE)
);
CREATE TABLE OASIS.AMX_CURRENCY_TABLE (
COMPANY_CODE CHAR(10) NOT NULL,
CODE CHAR(5) NOT NULL,
DESCRIPTION VARCHAR2(25) NOT NULL,
COMMON_UNIT INTEGER DEFAULT 1 NOT NULL
CONSTRAINT ORA116 CHECK (COMMON_UNIT >= 0),
OPERATOR_MODE CHAR(1) DEFAULT '*' NOT NULL,
INACTIVE_FLAG CHAR(1) DEFAULT 'N' NOT NULL
CONSTRAINT ORA117 CHECK (INACTIVE_FLAG IN ('Y','N')),
DEFAULT_CURRENCY CHAR(1) DEFAULT 'N' NOT NULL
CONSTRAINT ORA118 CHECK (DEFAULT_CURRENCY IN ('Y','N')),
GLX_ACCOUNT_CODE VARCHAR2(15),
GLX_SOURCE_CODE VARCHAR2(10),
GLX_COST_CENTER_CODE VARCHAR2(10),
RLZ_GLX_ACCOUNT_CODE VARCHAR2(15),
RLZ_GLX_SOURCE_CODE VARCHAR2(10),
RLZ_GLX_COST_CENTER_CODE VARCHAR2(10),
ARX_GLX_ACCOUNT_CODE VARCHAR2(15),
ARX_GLX_SOURCE_CODE VARCHAR2(10),
ARX_GLX_COST_CENTER_CODE VARCHAR2(10),
APX_GLX_ACCOUNT_CODE VARCHAR2(15),
APX_GLX_SOURCE_CODE VARCHAR2(10),
APX_GLX_COST_CENTER_CODE VARCHAR2(10),
SALES_GLX_ACCOUNT_CODE VARCHAR2(15),
SALES_GLX_SOURCE_CODE VARCHAR2(10),
SALES_GLX_COST_CENTER_CODE VARCHAR2(10),
PURCHASE_GLX_ACCOUNT_CODE VARCHAR2(15),
PURCHASE_GLX_SOURCE_CODE VARCHAR2(10),
PURCHASE_GLX_COST_CENTER_CODE VARCHAR2(10),
CONSTRAINT PK_ORA119 PRIMARY KEY (COMPANY_CODE, CODE)
);
I also had tried running each of the statememts individually on the SQL Command, I got "Success.." result.
Can someone help me out here because I am in the middle of evaluating XE and I need to report the findings to my management.
Thanking you for your kind assistant.
Regards,
Peter