Re: exporting a tablespace

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Thu, 6 Dec 2007 00:10:35 -0800 (PST)
Message-ID: <768131.56547.qm@web56608.mail.re3.yahoo.com>

Hi Nilesh,

What type of object is it ?

You may move this object to any other tablespace like SYSTEM or SYSAUX or some other tablespace and continue with transporting tablespace activitiy.

Regards

nilesh kumar <nileshkum_at_gmail.com> wrote: Hello All,

A very Good Morning!

I need to export a tablespace in oracle 10g.

first i tried to execute dbms_tts.TRANSPORT_SET_CHECK procedure which got executed successfully then after i fired the command select * from TRANSPORT_SET_VIOLATIONS.The result of this was sys owned object object_name in tablespace tablespace_name is not allowed in pluggable state.

Since it is not allowed in pluggable state i will not be allowed to export the tablespace. Is there any solution to this problem ?

Thanks

Nilesh
--

http://www.freelists.org/webpage/oracle-l        

---

Looking for last minute shopping deals? Find them fast with Yahoo! Search.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 06 2007 - 02:10:35 CST