Home » RDBMS Server » Server Utilities » DataPump Schema (10g RAC, Red Hat 6)
DataPump Schema [message #608538] Thu, 20 February 2014 13:36 Go to next message
aislanluiz
Messages: 8
Registered: February 2014
Junior Member
Hi,

Is it normal that the duplicated schema is about half size that the original?

I got only 12 same errors:
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

The size:
Tablespace----%Used----Alocated----Used----Free--------Datafiles
xxx_DATA------59,35-----28642,25-----16998------11644,25-----9
xxx_INDEX-----70,39-----20765-------14616-------6149--------7
yyy_DATA------84,05-----11320-------9514,75-----1805,25-----1
yyy_INDEX-----58,32-----10000-------5832,19-----4167,81-----1


The commands:

expdp xxx/xxx@xxx schemas=xxx directory=expdir dumpfile=xxx.dmp logfile=xxx.log

impdp yyy/yyy@yyy schemas=xxx directory=expdir dumpfile=xxx.dmp logfile=yyy.log remap_schema=xxx:yyy remap_tablespace=xxx_index:yyy_index remap_tablespace=xxx_data:yyy_data TABLE_EXISTS_ACTION=replace
Re: DataPump Schema [message #608539 is a reply to message #608538] Thu, 20 February 2014 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 22679
Registered: January 2009
Senior Member
>Is it normal that the duplicated schema is about half size that the original?
does size matter in this case?
would not a COUNT(*) of actual objects be more definitive?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: DataPump Schema [message #608540 is a reply to message #608538] Thu, 20 February 2014 13:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58846
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Is it normal that the duplicated schema is about half size that the original?


Yes, it may be.

Quote:
I got only 12 same errors:
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself


This is expected with the parameters you gave.
If you want to avoid that you must not import with the account to you remap.

Re: DataPump Schema [message #608541 is a reply to message #608540] Thu, 20 February 2014 13:49 Go to previous messageGo to next message
BlackSwan
Messages: 22679
Registered: January 2009
Senior Member
>(10g RAC, Red Hat 6)
NOT a supported combination
Re: DataPump Schema [message #608545 is a reply to message #608541] Thu, 20 February 2014 14:11 Go to previous messageGo to next message
aislanluiz
Messages: 8
Registered: February 2014
Junior Member
Sorry guys.
First the OS on that machine is 2.6.9-55.ELsmp, so Red Hat 4. I use the 6 on other machine that I intend to install 11g.

Quote:
would not a COUNT(*) of actual objects be more definitive?

I'm new on oracle world so I even know that I can count a schema. The compare tool told me that they are equal.

My principal concern now is what can I do to decrease the used size to reach the same as the new schema. Is there a "vacuum full" in oracle?
Re: DataPump Schema [message #608546 is a reply to message #608545] Thu, 20 February 2014 14:20 Go to previous messageGo to next message
Michel Cadot
Messages: 58846
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
what can I do to decrease the used size to reach the same as the new schema


Drop the old schema and import it.

Re: DataPump Schema [message #608547 is a reply to message #608546] Thu, 20 February 2014 14:29 Go to previous message
BlackSwan
Messages: 22679
Registered: January 2009
Senior Member
>Is there a "vacuum full" in oracle?
push back from the keyboard & consider the bigger picture.
The most common scenario when a large disparity exists between allocated & used is that periodically old data has been removed from the table.
If/when ZERO free space exists within a table & more rows need to be added to the table, then Oracle must incur the overhead to add more space to the table.
If you force the free space towards ZERO, then Oracle must expend extra resources to grow the table as new rows get added.
If you leave the free space alone & do nothing, then Oracle will REUSE the free space as new rows get added.
You are treating the table like an accordion; always expanding & contracting. The net results is wasted resource consumption.
Previous Topic: SQl Loader
Next Topic: SQLLDR help
Goto Forum:
  


Current Time: Wed Aug 20 09:54:49 CDT 2014

Total time taken to generate the page: 0.09062 seconds