Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Nick.

Asked: July 26, 2017 - 7:13 am UTC

Last updated: July 26, 2017 - 10:24 am UTC

Version: 12c Release 1 (12.1.0.2.0)

Viewed 1000+ times

You Asked

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

and Chris said...

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?

Is this answer out of date? If it is, please let us know via a Comment