Matt,
Oracle 8i Administrator's Guide, Release 2 (8.1.6) -- chapter 9 (see below)
there is also a doc on metalink that says
" Tablespace transportation between databases owning different block sizes
is allowed in Oracle9i.
Oracle9i offers the possibility to plug into a 9i database any tablespace
transported from 8i databases of any block size. "
Note:144212.1
snippet from 8i doc:
Limitations
Be aware of the following limitations as you plan for transportable
tablespace use:
The source and target database must be on the same hardware platform.
For example, you can transport tablespaces between Sun Solaris
Oracle databases, or you can transport tablespaces between NT Oracle
databases. However, you cannot transport a tablespace from a SUN
Solaris Oracle database to an NT Oracle database.
The source and target database must have the same database block size.
The source and target database must use the same character set and
national character set.
You cannot transport a tablespace to a target database in which a
tablespace with the same name already exists.
>From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: transportable tablespaces
>Date: Thu, 02 Aug 2001 05:21:31 -0800
>
>Rachel,
>
> Which doc did you find that in?
>
>Matt
>
>----
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi.
> - Larry Wall (creator of Perl)
>
>
> > -----Original Message-----
> > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 01, 2001 5:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: transportable tablespaces
> >
> >
> > According to the docs you must be on the same OS, down to
> > patches, and the
> > same version of Oracle, again down to patches.
> >
> > Rachel
> >
> >
> > >From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: transportable tablespaces
> > >Date: Wed, 01 Aug 2001 12:41:38 -0800
> > >
> > >do transportable tablespaces work between different
> > >OSes? I wouldn't think so, but I thought I'd ask.
> > >
> > >----
> > >Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > >Doing linear scans over an associative array is like
> > > trying to club someone to death with a loaded Uzi.
> > > - Larry Wall (creator of Perl)
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
