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

Report message to a moderator

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;

Report message to a moderator

Previous Topic: Buffer value during export
Next Topic: More Than Urgent! How to recover Database without control file?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 20:21:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.