OraFAQ Forum: Server Utilities » transportable tablespace

Home » RDBMS Server » Server Utilities » transportable tablespace (Oracle 9i 9.2.0.8 Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

transportable tablespace [message #467461]

Sat, 24 July 2010 11:14

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,

Report message to a moderator

Re: transportable tablespace [message #467462 is a reply to message #467461]

Sat, 24 July 2010 11:22

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/

Report message to a moderator

Re: transportable tablespace [message #467463 is a reply to message #467461]

Sat, 24 July 2010 11:26

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: transportable tablespace [message #467464 is a reply to message #467462]

Sat, 24 July 2010 11:30

smunir362
Messages: 310
Registered: September 2007

Senior Member

Then how to move functions/procedures (with grants) after transport tablespaces successfully.

Report message to a moderator

Re: transportable tablespace [message #467465 is a reply to message #467464]

Sat, 24 July 2010 11:34

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

Report message to a moderator

Re: transportable tablespace [message #467466 is a reply to message #467465]

Sat, 24 July 2010 11:44

smunir362
Messages: 310
Registered: September 2007

Senior Member

Please explain it with example.

Report message to a moderator

Re: transportable tablespace [message #467467 is a reply to message #467466]

Sat, 24 July 2010 11:46

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

Report message to a moderator

Re: transportable tablespace [message #467468 is a reply to message #467467]

Sat, 24 July 2010 12:00

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.

Report message to a moderator

Re: transportable tablespace [message #467469 is a reply to message #467468]

Sat, 24 July 2010 12:07

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?

Report message to a moderator

Previous Topic:	Migration from postgress into oracle columns with spaces
Next Topic:	imp/exp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 14:14:42 CST 2024