Exporting tables [message #119667] |
Fri, 13 May 2005 12:39 |
ksst
Messages: 10 Registered: February 2005
|
Junior Member |
|
|
Hi,
I have 2 questions :
1. Is it possible to have multiple exports or imports running simultaneously on one database at a point of time.
Some of it on a Solaris Unix server and some of it running on Windows.
Is this advisable and will it be fast ?
What will the impact be on the database?
2. If some datafiles are copied from one Large Database say 500 GB in size, to a much smaller one of size 40 GB.
What are the changes that need to be done for control files and the DB parameters ? Will anything else get affected.
Thanks in advance.
Sri Sai Krishna.
|
|
|
Re: Exporting tables [message #119671 is a reply to message #119667] |
Fri, 13 May 2005 12:53 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>Is this advisable and will it be fast ?
>>What will the impact be on the database?
Depends.
export and import by itself is a very serial process.
So you can start multiple exports, each exporting different subset (differnt schema or subset of table).
Similarly you can import in parallel ( like the same way you did import. IMPORT different subsets). import only the data NOT ndexes.
Create indexes manually in parllel.
Now any contention that applies with a regular export/import still applies here.
>>. If some datafiles are copied from one Large Database say 500 GB in size, to a much smaller one of size 40 GB.
What are the changes that need to be done for control files and the DB parameters ? Will anything else get affected.
I dont understand.
How could you 'plug-in' a 500GB databasefiles into a 40GB database.
In case that you are referring to transfer a smaller set of files, Be-ware that datafiles cannot be used in plug-and-play fashion ( You need to use Transportable Tablespaces).
|
|
|