Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Having problem running sql script file

user471129Apr 26 2006 — edited Oct 21 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2006
Added on Apr 26 2006
6 comments
526 views