Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [12-2007 Date Index] [Date Next] || [Thread Prev] [12-2007 Thread Index] [Thread Next]

Re: exporting a tablespace

  • From: Asif Momen <asif_oracle@xxxxxxxxx>
  • To: nileshkum@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 6 Dec 2007 00:10:35 -0800 (PST)
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@xxxxxxxxx> 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.




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.