| Import export utility [message #221122] |
Sat, 24 February 2007 01:10  |
hanumanth
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
|
Does anyone know how import/export utility internally works? And how does it use the temporary tablespaces during the operation?
|
|
|
|
| Re: Import export utility [message #221128 is a reply to message #221122] |
Sat, 24 February 2007 02:36  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Why? Why would you be interested in knowing how these utilities work under the hood?
The reason I ask is that all too often people start fixing a problem, thinking their 'solution' is THE way and get deeper and deeper into problems.
If they would explain the original problem instead of the 'solution', other people can think up alternatives.
So, maybe if you would explain what it is you are trying to accomplish and where you fail, we could help you out.
[Updated on: Sat, 24 February 2007 02:37] Report message to a moderator |
|
|
|
| Re: Import export utility [message #221162 is a reply to message #221128] |
Sat, 24 February 2007 10:20 |
hanumanth
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
I had noticed in our environment, whenever importing is finished for a database(dump size 2GB), temporary tablespace was growing huge, so why i wanted to know that, whether import/export utilities use temporary segements, if yes why do they use temporary segments..
Please clarify my doubt.
Thanks in advance,
Hanu
|
|
|
|
| Re: Import export utility [message #221166 is a reply to message #221162] |
Sat, 24 February 2007 11:10 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Export/Import work logically.
During export, the ddl is extracted and data is dumped into a proprietory format.
During import, the objects are created and data is loaded again.
It is no different than a usual database process (create table/create constraint/insert data/build indexes).
>> if yes why do they use temporary segments..
You must be using the default options to import (indexes=y).
Creation of certain objects needs temp segments to do sorting.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
