Database Utilities (MOSC)

MOSC Banner

how to impdp a schema that has tables with embedded sequences

edited Mar 10, 2016 2:48PM in Database Utilities (MOSC) 5 commentsAnswered

Hello,

I have a schema created in Oracle 12c that has tables defined with columns that are sequences similar to this

CREATE TABLE "schema1"."PERSON"

   (    "ENTITY_NO" NUMBER(*,0) DEFAULT "schema1"."SEQPERSON"."NEXTVAL",

    "PREFIX_NO" NUMBER(*,0),

    "FIRST_NAME" VARCHAR2(100 BYTE),

    "MIDDLE_NAME" VARCHAR2(100 BYTE),

    "LAST_NAME" VARCHAR2(100 BYTE)

,morecolumns

)

I need to copy schema1 from one Oracle 12c instance to another using expdp and impdp.  The .dmp file is created but I am having troubles getting the data imported into the second instance.  I created the new schema owner and granted DBA privileges and quota on our application data tablespaces.  All impdp commands include the REMAP_SCHEMA=origschema:schema1 parameter.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center