| oracle 8.1.7 data migration question [message #73247] |
Tue, 09 March 2004 03:42  |
Phil
Messages: 32
Registered: March 2001
|
Member |
|
|
Hi,
i am a rookie in oracle world and i have to face a great challange:
We use oracle 8.1.7 on 4 cpu unix HP server, an we need to have only a percentage of the production data (production is 300 Go data in about 1000 tables) on the test databases (same server an oracle version) every month. Some of the production data have to be transform (hiding crypt) for security reasons. Can somebody tell me the best solution for doing this ? how to use correctly the 4 severver cpu
1) dblink ?
2) sql*loader ?
3) exp/imp ?
Can somebody tell the best way to do that ?
Thanks.
|
|
|
|
| Re: oracle 8.1.7 data migration question [message #73249 is a reply to message #73247] |
Tue, 09 March 2004 05:29  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. dblink
still anyone in the network can tap the data.
a sniffer would do the job.
2. do u want to generate junks of text files and and then load them again...?
3. will work..
You can selectively export a certain tables.
and import them.
IF u want to secure data over network you have to secure the sql*net connections between the servers( in case of dblink).
then, You need to look into sqlnet encryption IN which
all data tansnfered between a client and server is ENCRYPTED.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
