Home » RDBMS Server » Server Utilities » transportable tablespace (Oracle 9i 9.2.0.8 Linux)
transportable tablespace [message #467461] Sat, 24 July 2010 11:14 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Hi,

I want to transportable tablespace feature of EXP/IMP. I did it with no error. But when I check user by user I found that no Function Procedures were imported. How to deal with these objects using transportable tablespace feature.


Regards,
Re: transportable tablespace [message #467462 is a reply to message #467461] Sat, 24 July 2010 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I found that no Function Procedures were imported.
This is because Functions & Procedures actually reside in SYSTEM tablespace.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: transportable tablespace [message #467463 is a reply to message #467461] Sat, 24 July 2010 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You transport what is the tablespaces you transport and not what is outside them; seems logic.
So query dba_segments to know what is inside your tablespace.

Regards
Michel
Re: transportable tablespace [message #467464 is a reply to message #467462] Sat, 24 July 2010 11:30 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Then how to move functions/procedures (with grants) after transport tablespaces successfully.
Re: transportable tablespace [message #467465 is a reply to message #467464] Sat, 24 July 2010 11:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Then how to move functions/procedures (with grants) after transport tablespaces successfully.
DBMS_METADATA.GET_DDL
Re: transportable tablespace [message #467466 is a reply to message #467465] Sat, 24 July 2010 11:44 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Please explain it with example.
Re: transportable tablespace [message #467467 is a reply to message #467466] Sat, 24 July 2010 11:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please explain it with example.

Please Read The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#i1019414
Re: transportable tablespace [message #467468 is a reply to message #467467] Sat, 24 July 2010 12:00 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Manual is for all options mix. But I want only copy those objects with their grants that are not migrated using transportable tablespace. If some one have some idea OR facing the same issue and get solved Please share it.
Re: transportable tablespace [message #467469 is a reply to message #467468] Sat, 24 July 2010 12:07 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
since we don't know what is being moved & what is not being moved no specific solution can be provided.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

How can an independent observer conclude when a valid solution has been posted?
Previous Topic: Migration from postgress into oracle columns with spaces
Next Topic: imp/exp
Goto Forum:
  


Current Time: Thu Mar 28 13:54:19 CDT 2024