Home » RDBMS Server » Server Utilities » import/export selected columns
import/export selected columns [message #72371] Fri, 30 May 2003 12:57 Go to next message
Y Yu
Messages: 2
Registered: May 2003
Junior Member
Can Oracle 8i able to exp/imp selected columns from a table? I have a table on production DB. I want to export key columns and import into history DB. Do any one know how?

Thank you!
Y yu
Re: import/export selected columns [message #72372 is a reply to message #72371] Fri, 30 May 2003 15:47 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i beleive, there is no direct method to do it.
create temp table from original table and export just the temp table.

create table temp as select c1,c3,c5 from sourcetable;
Previous Topic: Buffer value during export
Next Topic: More Than Urgent! How to recover Database without control file?
Goto Forum:
  


Current Time: Tue Dec 24 06:38:51 CST 2024