| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: transportable tablespaces
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)" <MATT.ADAMS_at_APPL.GE.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 - matt.adams_at_appl.ge.com
>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:carmichr_at_hotmail.com]
> > 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)" <MATT.ADAMS_at_APPL.GE.COM>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >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 - matt.adams_at_appl.ge.com
> > >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: carmichr_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Fri Aug 03 2001 - 00:49:44 CDT
 |
 |