Home » RDBMS Server » Server Utilities » Export with DML/Modification (Oracle 10g R2, Win2003)
Export with DML/Modification [message #418904] Wed, 19 August 2009 02:22 Go to next message
weekend79
Messages: 188
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

Re: Export with DML/Modification [message #418908 is a reply to message #418904] Wed, 19 August 2009 02:28 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Sun Jul 23 18:12:12 CDT 2017

Total time taken to generate the page: 0.10543 seconds