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
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member


I want to take an "export" or "datapump export" of a database user (complete schema) with modification (DNL) in few columns
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'

Can anyone guide me the best practices to achieve it?


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: 63930
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


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

Current Time: Thu Oct 27 02:46:22 CDT 2016

Total time taken to generate the page: 0.10474 seconds