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: 198
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: 68597
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: Wed Feb 28 16:47:43 CST 2024