-
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
-
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
You can export the tables only without rows.
-
You could import the table and copy the selected columns, then drop the imported tables.
MH
I remember when this place was cool.
-
Import the tables and drop the columns which you don't need.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|