Re: Export/Import

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:996005535.21854.0.pluto.d4ee154e_at_news.demon.nl...
> Import imports in
> a) the tablespace of the create tablespace
> b) the default tablespace if
> - the orginal tablespace doesn't exist
> ---------> The user has no quota on the tablespace
> So to move a table by exp/imp
> make sure : the target tablespace is the default tablespace of the owner
 of
> the tables.
> This account doesn't have unlimited tablespace privilege,
> and doesn't have quota on the original tablespace.
>
> Sorry to say so, but all answers were incomplete.

And an added little problem.

If your table contains lob data which is stored out of row. i.e. the table is something like

create table t1(
id number,
binary_data blob)
lob (binary_data) store as
(tablespace lob_data
disable storage in row)
tablespace users;

then an import into a new database which does not contain the tablespace lob_data will fail.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**