Menu de navegação

[WendelParticipante]

Olá, tenho uma dúvida em relação a compatibilidade do Oracle 9 para o 10. Veja abaixo um pedaço do script para criação de uma tabela, os outros seguem o mesmo padrão, vejam o que voces acham.

Tenho uns scripts que foram testados no Oracle 9 e executou com sucesso, mas no ambiente do Oracle 10 retornou os seguintes erros abaixo. Eu acredito que no Oracle 10 os comandos sejam diferentes, ou seria alguma restrição de configuração do SGBD do ambiente Oracele 10?

SCRIPT ABAIXO –>

CREATE TABLE GRAOWN.AREA

(

CD_AREA INTEGER NOT NULL,

SL_AREA VARCHAR2(3 BYTE) NOT NULL,

DS_AREA VARCHAR2(50 BYTE) NOT NULL

)

TABLESPACE GRATSD01

PCTUSED 40

PCTFREE 10

INITRANS 1

MAXTRANS 255

STORAGE (

INITIAL 64K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

LOGGING

NOCACHE

NOPARALLEL

NOMONITORING;

ALTER TABLE GRAOWN.AREA ADD (

CONSTRAINT CD_AREA

PRIMARY KEY

(CD_AREA)

USING INDEX

TABLESPACE GRATSI01

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

INITIAL 64K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

));

ALTER TABLE GRAOWN.AREA ADD (

CONSTRAINT SL_AREA

UNIQUE (SL_AREA)

USING INDEX

TABLESPACE GRATSI01

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

INITIAL 64K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

));

CREATE UNIQUE INDEX GRAOWN.CD_AREA ON GRAOWN.AREA

(CD_AREA)

LOGGING

TABLESPACE GRATSI01

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

INITIAL 64K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

NOPARALLEL;

CREATE UNIQUE INDEX GRAOWN.SL_AREA ON GRAOWN.AREA

(SL_AREA)

LOGGING

TABLESPACE GRATSI01

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

INITIAL 64K

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

NOPARALLEL;

—ERROS RELATADOS à

SP2-0734: unknown command beginning “TABLESPACE…” – rest of line ignored.

SP2-0734: unknown command beginning “PCTUSED …” – rest of line ignored.

SP2-0734: unknown command beginning “PCTFREE …” – rest of line ignored.

SP2-0734: unknown command beginning “INITRANS …” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning “MAXTRANS …” – rest of line ignored.

SP2-0734: unknown command beginning “STORAGE …” – rest of line ignored.

SP2-0734: unknown command beginning “INITIAL …” – rest of line ignored.

SP2-0734: unknown command beginning “MINEXTENTS…” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning “MAXEXTENTS…” – rest of line ignored.

SP2-0734: unknown command beginning “PCTINCREAS…” – rest of line ignored.

SP2-0734: unknown command beginning “FREELISTS …” – rest of line ignored.

SP2-0734: unknown command beginning “FREELIST G…” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning “BUFFER_POO…” – rest of line ignored.

SP2-0042: unknown command “)” – rest of line ignored.

SP2-0042: unknown command “LOGGING” – rest of line ignored.

SP2-0042: unknown command “NOCACHE” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0042: unknown command “NOPARALLEL” – rest of line ignored.

SP2-0734: unknown command beginning “NOMONITORI…” – rest of line ignored.

SP2-0734: unknown command beginning “TABLESPACE…” – rest of line ignored.

SP2-0734: unknown command beginning “PCTFREE …” – rest of line ignored.

SP2-0734: unknown command beginning “INITRANS …” – rest of line ignored.

SP2-0734: unknown command beginning “MAXTRANS …” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning “STORAGE …” – rest of line ignored.

SP2-0734: unknown command beginning “INITIAL …” – rest of line ignored.

SP2-0734: unknown command beginning “MINEXTENTS…” – rest of line ignored.

SP2-0734: unknown command beginning “MAXEXTENTS…” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning “PCTINCREAS…” – rest of line ignored.

SP2-0734: unknown command beginning “FREELISTS …” – rest of line ignored.

SP2-0734: unknown command beginning “FREELIST G…” – rest of line ignored.

SP2-0734: unknown command beginning “BUFFER_POO…” – rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

Quem puder dar a opniao do que pode estar acontecendo…

WENDEL G. PEDROZO
User Oracle 9i[/u][/b]

[chduarteParticipante]

Parece estar sendo algum caracter invalido no arquivo. Tente copiar todo o DDL e colar no SQLPLus.

Tb nao é mais usual utilizar estas clausulas de storage.

[]

[WendelParticipante]

Acho q é isto mesmo. Estou sem o Oracle 10 aqui, mas um amigo meu testou e não deu erro não. Acho que é espaço em branco ou quebra de linha. Valeu

Wendel 8)

[Autor]

Posts