Home » RDBMS Server » Server Utilities » problem with expdp-impdp huge space occupying (oracle 11g Windows)
problem with expdp-impdp huge space occupying [message #485628] Thu, 09 December 2010 03:38 Go to next message
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 #485687 is a reply to message #485628] Thu, 09 December 2010 08:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can someone help me to resolve this problem?
Does size of new table objects match source objects of new default tablspace size?
Re: problem with expdp-impdp huge space occupying [message #485705 is a reply to message #485687] Thu, 09 December 2010 09:34 Go to previous messageGo to next message
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 #485707 is a reply to message #485705] Thu, 09 December 2010 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
so new size is about same old size which means import succeeded.
It is working as expected.
Re: problem with expdp-impdp huge space occupying [message #485708 is a reply to message #485707] Thu, 09 December 2010 09:49 Go to previous messageGo to next message
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 #485709 is a reply to message #485708] Thu, 09 December 2010 09:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>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.
You will need to manually pre-create objects in target DB to control their size.

Neither imp nor impdp allow control of object size.
Re: problem with expdp-impdp huge space occupying [message #485712 is a reply to message #485708] Thu, 09 December 2010 10:00 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
pradies wrote on Thu, 09 December 2010 15:49
I 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 Go to previous messageGo to next message
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 #485714 is a reply to message #485713] Thu, 09 December 2010 10:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.globusz.com/ebooks/Oracle11g/00000017.htm
Re: problem with expdp-impdp huge space occupying [message #485787 is a reply to message #485714] Thu, 09 December 2010 22:28 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

Thanks for reply and leave everything above. Simply I want to know is there any option to take only structure level schema export or not with expdp??

If yes then please tell me the command for the same.

Regards

Pradeep Sharma
Re: problem with expdp-impdp huge space occupying [message #485790 is a reply to message #485787] Thu, 09 December 2010 22:39 Go to previous message
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.
Previous Topic: Calling SQL*Loader utility with alias instead of password
Next Topic: DATA PUMP (3 MERGED)
Goto Forum:
  


Current Time: Tue Sep 28 20:20:21 CDT 2021