Data refresh on dev instance
Hello: I have a stage instance and a dev instance.There are around 15 schemas each having around 20 tables. I want to populate dev instance with following conditions: a) Some tables have to be imported to Dev instance as they are in stage instance b) Some tables have to be imported to Dev instance after scrambling the data c) Some table have to be imported to Dev instance without any data. d) Some table have to be imported to Dev instance with partial data. Please let me know what should be the approach for this. My email id is sinha73#gmail.com Thanks in Advance. Dee
If you insist in using sqldev and keeping it easy, A and C can be done with Tools - Database Export. You can do the same for D, and delete rows from the script before running it. And you can do the same for B, then manipulate the data afterwards (with UPDATE). Also consider using database links and INSERT INTO xxx SELECT * FROM xxx#link, or the external IMPDP/EXPDP tools. For any questions other than the Database Export, post them under the correct forums (SQL And PL/SQL, Export/Import) Have fun, K.
Copying subprograms to another schema
Can adhoc DML be echoed to Data Editor Log?
SQL Developer 1.5.5 Tables Node Works a few times
SQL tab not working in V2.1 EA1 for non-DBA users -- how to fix?
Wrong error line number
2.1 EA2 Error Message Line number off by 1.
Tiny 2.1 EA1 SQL Formatter Bug?
Dependencies option missing when exporting
SQLDeveloper 2.1 EA2- Bug in spatial index creation
SQL Developer 2.1 general performance feedback
SQL Developer 220.127.116.11 - Export Data menu missing for SQL Server databases
Sql Developer 2.1 - Save Package Spec and Body
Where are these packages stored? Database or Application server?
30EA3->2.*: Weird performance issues for editing objects
SQLDEV 18.104.22.168 gives ORA-904 on UT_TEST_RESULTS when running unit test
SQL Developer 2.1 EA2 Compiler ORA-00911: invalid character error