Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exporting multiple tablespaces then importing to single tablespace

Re: exporting multiple tablespaces then importing to single tablespace

From: Kee <keedae_at_hotmail.com>
Date: Thu, 12 May 2005 20:57:47 GMT
Message-ID: <frPge.62339$tg1.45572@edtnps84> 






> There are some situations where both approaches can fail

> 1) If you have tables with longs, you can not move

> 2) If you have tables consisting of more than 1 segment ( lobs,

> partitions etc), you must habe those tables precreated

> Then generate ddl scripts and edit them might be the most appropriated

> way...

>

> Regards

>

> Maxim





Thank you for the heads up.



This was my issue causing the imp to fail.  Each table spaces contained 
tables with CLOB field.



Sincerely,





Kee 
Received on Thu May 12 2005 - 15:57:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US