OraFAQ Forum: Server Utilities » Export with DML/Modification

Home » RDBMS Server » Server Utilities » Export with DML/Modification (Oracle 10g R2, Win2003)

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

Export with DML/Modification [message #418904]

Wed, 19 August 2009 02:22

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Hi

I want to take an "export" or "datapump export" of a database user (complete schema) with modification (DNL) in few columns
i.e.
All values of employee.Salary columns should become '000'
All values of user account.Security code columns should become 'abc'
All values of client.Contact should become 'xyz'
etc

Can anyone guide me the best practices to achieve it?

Wishes

Report message to a moderator

Re: Export with DML/Modification [message #418908 is a reply to message #418904]

Wed, 19 August 2009 02:28

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ It is NOT backup or recovery question
2/ It is NOT an export or datapump question, they are NOT ETL tools, just export and import one.
3/ Find an ETL tool

Regards
Michel

Report message to a moderator

Previous Topic:	SQL Loader DATE Datatype error (merged)
Next Topic:	IMPDP ignore=y

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:24:38 CST 2024