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: Rudy Susanto <rsusanto_at_atlas-sp.com>
Date: 6 Aug 2002 18:19:34 -0700
Message-ID: <1a928d0b.0208061719.2b575507@posting.google.com>


Hi Richard,

Thank you very much.

Regards,
Rudy Susanto

Richard Foote <Richard.Foote_at_oracle.com> wrote in message news:<3D4F6AE3.8BBC7EE8_at_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 - 20:19:34 CDT

Original text of this message

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