OraFAQ Forum: Server Utilities » Export/Import Unused column

Home » RDBMS Server » Server Utilities » Export/Import Unused column (11g Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export/Import Unused column [message #668534]

Wed, 28 February 2018 10:53

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

The source database(Production) schema contains tables with unused columns.The schema is exported with expdp.
Now when the schema is imported to the destination database(Testing) i don't see the columns marked as Unused anymore in(dba_unused_col_tabs)

Is there any way to exclude these unused columns with expdp/impdp.I know i can drop the unused columns from source but this takes a long time which i want to avoid.

[Updated on: Wed, 28 February 2018 10:55]

Report message to a moderator

[Message index]

		Export/Import Unused column By: preet_kumar on Wed, 28 February 2018 10:53
		Re: Export/Import Unused column By: Michel Cadot on Wed, 28 February 2018 11:34
		Re: Export/Import Unused column By: preet_kumar on Wed, 28 February 2018 12:20
		Re: Export/Import Unused column By: Michel Cadot on Wed, 28 February 2018 12:27

Previous Topic:	DataPump errors on EXCLUDE table syntax
Next Topic:	Exporting from Physical standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 10:06:44 CDT 2024