Exforsys
+ Reply to Thread
Results 1 to 4 of 4

Oracle data pump

This is a discussion on Oracle data pump within the Oracle Database forums, part of the Database category; I would like to know if there is a possibility of exporting only one column from a table with the ...

  1. #1
    RachellT is offline Junior Member Array
    Join Date
    Jul 2007
    Answers
    1

    Exclamation Oracle data pump

    I would like to know if there is a possibility of exporting only one column from a table with the data pump?


  2. #2
    Uldis is offline Junior Member Array
    Join Date
    Oct 2006
    Answers
    3
    No, the smallest unit, AFAIK, is still a table. You, however, can use "CREATE ... AS SELECT ..." or "INSERT ... SELECT ..." to make an additional table with column you need.


  3. #3
    Larry Cumber is offline Junior Member Array
    Join Date
    Jul 2007
    Location
    Birmingham-UK
    Answers
    12
    Does this mean you cannot export an empty table with data pump?
    Because you could export the metadata and exclude data.


  4. #4
    Uldis is offline Junior Member Array
    Join Date
    Oct 2006
    Answers
    3
    Quote Originally Posted by Larry Cumber View Post
    Does this mean you cannot export an empty table with data pump?
    Because you could export the metadata and exclude data.
    ROWS=NO in parameters... Often used to trabfer schemas w/o data.


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...