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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Move lobs

Re: Move lobs

From: Jan van Mourik <jmourik_at_yahoo.com>
Date: 7 Oct 2003 12:47:00 -0700
Message-ID: <ffe966de.0310071147.5cc877dd@posting.google.com>


> My basic problem was to move the objects from a tablespace to another one
> and then to resize the first tablespace.

Why can't you just resize it anyway? What exactly is your goal.

> The problem of this solution is that some lobs are no longer readable. In
> the Oracle tables, I can read <Value Error> instead of <CLOB>.

Do you get any Oracle error messages?
Is that <Value Error> there before the move?

> The problem of this solution is that exporting seems to keep the "storages
> clauses" and therefore re-imports the data in the first tablespace.

If you drop the first tablespace and assign the new one as the default tablespace, imp will import into the default tablespace. Or import with show=y and pre-define the tables, then import with ignore=y.

And aren't you using locally managed tablespaces???

jan Received on Tue Oct 07 2003 - 14:47:00 CDT

Original text of this message

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