expdp: don't save some tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: expdp: don't save some tables

  1. #1
    Join Date
    Apr 2010
    Posts
    5

    Unhappy expdp: don't save some tables

    Today I used expdp to save an entire schema, and I seen some tables (with USER_OBJECTS.DATA_OBJECT_ID is null) are not exported.
    Why ?

    Regards,
    Dave

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Today I used expdp to save an entire schema,
    what do you mean "save an entire schema"?? you mean you have exported entire schema?

    check out the logs what you exported and what you imported.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Apr 2010
    Location
    Chennai
    Posts
    5

    Today I used expdp to save an entire schema, and I seen some tables (with USER_OBJEC

    Actually, Export/Exportdp & Import/Importdp will take the meta data of the schema.

    After importing. you can able to see the the column with null values in the table.

    Regards,

    Anil.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Actually, Export/Exportdp & Import/Importdp will take the meta data of the schema.
    there is NO such utilities (exportdp & importdp) in Oracle.

    depends on the utility (exp / expdp) we can tell Oracle to export only meta data but that is not the default behaviour.

    Thanks,
    Last edited by vnktummala; 04-12-2010 at 09:15 AM. Reason: typo
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width