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: Transport tablespace problem

Re: Transport tablespace problem

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Tue, 06 Aug 2002 16:21:23 +1000
Message-ID: <3D4F6AE3.8BBC7EE8@oracle.com>


Hi Rudy,

The transportable tablespace option is not available with Standard Edition.

Cheers

Richard

Rudy Susanto wrote:
>
> Hi all,
>
> I found a problem when i tried to export database with transport
> tablespace option, and my question is how to enable it? Here is what
> i've done.
>
> SQL> alter tablespace ilms_data read only;
> Tablespace altered.
>
> D:\>exp 'sys/change_on_install_at_v817_turtle as sysdba'
> transport_tablespace=y tablespaces=ilms_data
>
> Export: Release 8.1.7.0.0 - Production on Tue Aug 6 11:13:21 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Connected to: Oracle8i Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
> Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
> character set
> EXP-00017: feature "Export transportable tablespaces" is needed, but
> not present in database
> ORA-00439: feature not enabled: Export transportable tablespaces
> EXP-00000: Export terminated unsuccessfully
>
> D:\>
>
> Thanks in advance
>
> Rudy Susanto


Received on Tue Aug 06 2002 - 01:21:23 CDT

Original text of this message

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