SQL Developer


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.

Related Links

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 2.1.0.63 - 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 2.1.0.63 gives ORA-904 on UT_TEST_RESULTS when running unit test
SQL Developer 2.1 EA2 Compiler ORA-00911: invalid character error

Categories

ORACLE DEV
Oracle Database + Options
Text
Database Installation
TopLink/JPA
Documentation
JD Edwards EnterpriseO...
On Demand: SaaS and Ma...
Integration - B2B
Secure Enterprise Search
Secure Backup
Developer Suite (Korean)
E-Business Suite (Korean)
Recovery Manager (RMAN...
Migration and Moderniz...
Technologies - JSP (Ko...
Applications Integrati...
LCM: Maintenance Wizard
PeopleSoft Enterprise
Siebel Archived Forums
Hyperion System 9 BI+ ...
Siebel Mobile
Oracle Fusion Middlewa...
Smart Space
Performance Testing
Test Management/Functi...
Communications Service...
weblogic.developer.int...
WebLogic Server/Java E...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
BEA SALT 2.0 Beta
Primavera Contractor U...
Primavera Contractor
Evolve
Retail Data Model
SOA & Web Services (Ch...
程序人生
广州 User Group
Private Discussion For...
Java Sound
Java 3D
Algorithms
Solaris 11
Java Game Development
Solaris 9
Sun Update Connection
AVK Portability
Oracle Communications ...
Systems Maintenance
Sun ONE Certificate Se...
JavaFX 2.0 and Later
Oracle Database 11g Ex...
NoSQL Database
Oracle University Deli...
Big Data Appliance
Developer [ARCHIVE]
Engineered Systems
Database Track
Houston TX Eloqua Users
Markies: Sales Impact
Eloqua Users with Orac...
Privacy and Compliance
Oracle Compute Cloud S...
Global Trade Management
Java SE [ARCHIVE]
Interact 2014: A Moder...
Español
Oracle Academy - Commu...
Optimized Solutions
Oracle Learning Library
OU Guided Boot Camps
OMC - Industry Solutio...
Cloud Accelerate
Service Supply Chain
Chile
APEX Gruppe
Group Verticurl
Ecuador
Spatial
Contracts
C++ Call Interface (OCCI)
Products (Korean)
OA Framework (Korean)
Communications Converg...
PeopleSoft General Dis...
Siebel Technology
Oracle Authentication ...
Security
Enterprise 2.0
WebLogic Server - General
weblogic.developer.int...
Primavera Archived For...
dev2dev - BEA China
Tuxedo (Chinese)
J2ME Development (Chin...
Parallel Graph Analytics
Middleware Track
SQL and PL/SQL (Portug...
Oracle Storage Cloud S...
Do It
Imagine How

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App