Home » SQL & PL/SQL » SQL & PL/SQL » data refresh in Dev instance
data refresh in Dev instance [message #437897] Wed, 06 January 2010 07:23 Go to next message
sinha73
Messages: 4
Registered: November 2006
Location: ST LOUISELOPER
Junior Member

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
Re: data refresh in Dev instance [message #437900 is a reply to message #437897] Wed, 06 January 2010 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ The answer depends on your version
2/ We do not do homework for you, you have to tell us what you searched and found or thought.
3/ All conditions cannot be satisfied at the same time

Regards
Michel
Re: data refresh in Dev instance [message #437914 is a reply to message #437900] Wed, 06 January 2010 09:06 Go to previous messageGo to next message
sinha73
Messages: 4
Registered: November 2006
Location: ST LOUISELOPER
Junior Member

I am new bee.
The tables thast I have to do the cleaning I am thinking of doing something like this on the stage insatnce and then moving to Dev.

CREATE TABLE NEW_tbl_1 AS SELECT column1, mask(column2), column3, trim(column4), ... from tbl_1 WHERE <criteria for keeping>;

ALTER TABLE NEW_tbl_1 add constraints, indexes, etc.

DROP TABLE tbl_1T;

ALTER TABLE NEW_tbl_1 RENAME TO tbl_1;

Re: data refresh in Dev instance [message #437921 is a reply to message #437914] Wed, 06 January 2010 09:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1/ The answer depends on your version


Regards
Michel
Re: data refresh in Dev instance [message #437932 is a reply to message #437921] Wed, 06 January 2010 09:40 Go to previous messageGo to next message
sinha73
Messages: 4
Registered: November 2006
Location: ST LOUISELOPER
Junior Member

sry...
Database is 10G
Re: data refresh in Dev instance [message #437935 is a reply to message #437932] Wed, 06 January 2010 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 24908
Registered: January 2009
Senior Member
>Database is 10G
10G is marketing label

Post results of
SELECT * from v$version
Re: data refresh in Dev instance [message #437938 is a reply to message #437932] Wed, 06 January 2010 09:55 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
a) exp/imp or Data Pump
b) Data Pump with Data Masking
c) exp/imp or Data Pump
d) exp/imp or Data Pump with query clause or custom script

Regards
Michel
Re: data refresh in Dev instance [message #437940 is a reply to message #437935] Wed, 06 January 2010 09:58 Go to previous message
sinha73
Messages: 4
Registered: November 2006
Location: ST LOUISELOPER
Junior Member

the version is:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

Thanks
sinha73

[Updated on: Wed, 06 January 2010 10:28]

Report message to a moderator

Previous Topic: Need help for query
Next Topic: loop
Goto Forum:
  


Current Time: Tue Sep 27 17:56:06 CDT 2016

Total time taken to generate the page: 0.11351 seconds