| problem with expdp-impdp huge space occupying [message #485628] |
Thu, 09 December 2010 03:38  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
I am using expdp-impdp to export the Struncure of a user's object to another user using the below command
====> expdp dumpfile=talkies.dmp logfile=talkies.log schemas=talkies directory=test_dir
When I am importing this structure to test user it is taking so much space at OS level and increasing tablespace size. Command is
=====> impdp dumpfile=talkies.dmp logfile=talkies_imp.log remap_schema=talkies:test directory=test_dir
As per the export import this problem can be resolve using compress option. But I m not able to find the resolution with expdp-impdp.
Can someone help me to resolve this problem?
Regards
Pradeep
|
|
|
|
|
|
| Re: problem with expdp-impdp huge space occupying [message #485705 is a reply to message #485687] |
Thu, 09 December 2010 09:34  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
Currently user table objects having the 21 GB size. I have counted this by the below command.
select sum(bytes) from dba_segments where owner='TALKIES' and segment_type='TABLE';
21097152512
But the number of rows in all the table is 0.
Source tablespace size is approx 20GB.
Regards
Pradeep
|
|
|
|
|
|
| Re: problem with expdp-impdp huge space occupying [message #485708 is a reply to message #485707] |
Thu, 09 December 2010 09:49 |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi Dear,
I am here just importing the structure of objects only and its taking high amount of space.
This amount of space is already on production server but that is with data.
I want to know if I will import this any system where I want only structure of schema and there is not sufficient space then how this will be done.
Regards
Pradeep
|
|
|
|
|
|
| Re: problem with expdp-impdp huge space occupying [message #485712 is a reply to message #485708] |
Thu, 09 December 2010 10:00 |
cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
pradies wrote on Thu, 09 December 2010 15:49I am here just importing the structure of objects only and its taking high amount of space.
Not if you're using the command line from your first post. It doesn't mention the content parameter so structure and data will be exported.
|
|
|
|
| Re: problem with expdp-impdp huge space occupying [message #485713 is a reply to message #485709] |
Thu, 09 December 2010 10:01 |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
Means everytime when I will have to import the structure of schema from production to test environment then I can only to create the objects with creation scripts.
But As per my knowledge in export-import a Feature exist compress which resolve this issue when using export and import.
But this feature has been substracted from expdp-impdp.
Regards
Pradeep
|
|
|
|
|
|
|
|
| Re: problem with expdp-impdp huge space occupying [message #485790 is a reply to message #485787] |
Thu, 09 December 2010 22:39 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
below are options for expdp
COMPRESSION
Reduce the size of a dump file.
Valid keyword values are: ALL, DATA_ONLY, [METADATA_ONLY] and NONE.
CONTENT
Specifies data to unload.
Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
