0

I want to import one of my schema "vvs1" to r&d database with content=metdata_only. expdp works perfect but when i am going to import on r&d server it takes tables original size.

for example:- I have 1 table vvs.xyz with size of 10 GB. i am taking structure backup only. now import on r&d server it creates a table structure with 10 GB size. i want only table with default size while created.

expdp syntax:

expdp vvs/1 full=Y CONTENT=METADATA_ONLY directory=DATAPUMP_DIR dumpfile=full.dmp logfile=full.log KEEP_MASTER=Y

impdp syntax:

impdp vvs/1  CONTENT=METADATA_ONLY directory=DATAPUMP_DIR dumpfile=full.dmp logfile=full_impdp.log schemas=vvs

main database :-Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

r&d database:- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

  • It will use the init and next segment sizes when creating the table. You will have to create it manually before you do the import. – sandman Nov 16 '18 at 12:08
  • Just out of interest, are you really using standard in prod, and EE in R&D? – Phil Sumner Nov 19 '18 at 11:58
  • yes, i did this only on dev & testing server only – vvs Nov 19 '18 at 13:10
2

Typically caused by the segment attributes of the tables.

You can use TRANSFORM=SEGMENT_ATTRIBUTES:N, so the tables will be created with default options.

You can use TRANSFORM=SEGMENT_CREATION:N as well, so your segments will not be created at all, unless deferred segment creation is disabled in your database.

TRANSFORM

DEFERRED_SEGMENT_CREATION

  • thanks a lot @Balazs Papp, from this parameter it works proper – vvs Nov 19 '18 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.