Hello. I'm using SQLDeveloper for coping my database from one server to another. So I choose Tools->Database Export..., then connection and couple of options (like this one
https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm#BABHFHGH ). The resulting SQL not working, cause it contains NOPARALLELALTER (that means, I guess, NOPARALLEL; ALTER) and not contains semicolons.
Tell me please, Tom, what I do wrong?
This is a fragment from my export.sql:
CREATE TABLE APPEAL_TRANSFER
(
MESSAGE_ID NUMBER(10, 0) NOT NULL
, "DATE" NUMBER(10, 0)
, USER_FROM NUMBER(10, 0)
, USER_TO NUMBER(10, 0)
, GROUP_ID NUMBER(10, 0)
, CONSTRAINT APPEAL_TRANSFER_MESSAGE_ID_PK PRIMARY KEY
(
MESSAGE_ID
)
USING INDEX
(
CREATE UNIQUE INDEX APPEAL_TRANSFER_MESSAGE_ID_PK ON APPEAL_TRANSFER (MESSAGE_ID ASC)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
)
ENABLE
)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOCOMPRESS
NOPARALLELALTER TABLE APPEAL_TRANSFER
ADD CONSTRAINT APPEAL_TRANSFER_MSG_FK FOREIGN KEY
(
MESSAGE_ID
)
REFERENCES MSG_MESSAGES
(
ID
)
ENABLE
Here it is:
NOPARALLELALTER TABLE APPEAL_TRANSFER
Hard to say what's going on without seeing precisely what you're doing... But it could be an issue with the SQL Dev export option.
Here's some things to check:
- Make sure you're on the latest version of SQL Dev (currently 17.2)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html - If it still doesn't work:
- Raise a bug!
- Try enabling/disabling "Export DDL" options. e.g. do you really need all the storage options?