Re: Transportable Tablespaces and Temp Tables

g3000 wrote:

> I am trying to transport all tablespaces that belong to an application.
>
> As far as the Oracle docs state, global temp tables are stored in the
> data dictionary (system tablespace) then for each users session it is
> created (on the fly Im assuming, a temp segment for the temp table) in
> my temp tablespace. (which is what i want and not a problem)
>
> Problem is when I try to create a "self-containted" tablespace set to
> transport all the tablespaces my schema uses.
> Oracle has a pointer from the system tablespace pointing to another
> tablespace that holds the primary key for the temp table. That causes
> my tablespace set to not be self contained.
>
> Oracle does not allow you to transport the SYSTEM tablespace.
>
> Is there a way I can get around this without having to drop the temp
> table primary key then execute DDL for my temporary tables and recreate
> the pk's on tablespace set import?
> Thank you in advance for your time
> Carlton G

Why would you want to transport the SYSTEM tablespace? Or the TEMP tablespace? Or even though you didn't mention it SYSAUX and UNDO tablespaces. Look at what TTS does.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)