Export , Import specific columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Export , Import specific columns

  1. #1
    Join Date
    Feb 2003
    Posts
    24

    Export , Import specific columns

    Hi all,

    I need your expertise here. I need to export tables and the data into another database. I will export the structure of the table and specific columns only, not all data are required. Only specific column data are needed to be exported.

    Can Oracle export and import utilities do this straight away?

    Thanks so much, your help is appreciated.
    God bless
    ROb

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    No.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  3. #3
    Join Date
    Jun 2003
    Posts
    108
    You can export the tables only without rows.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    You could import the table and copy the selected columns, then drop the imported tables.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Import the tables and drop the columns which you don't need.

  6. #6
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    create a temp table with the required column. export the same.
    Cheers!
    OraKid.

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