Re: Exporting a tablespace

From: Ronald <ronr_at_wxs.nl>
Date: Fri, 26 Feb 1999 6:20:14 +0100
Message-ID: <01HW.B2FBED9E00005F2F11EA7EC0@news.wxs.nl>

On Thu, 25 Feb 1999 15:35:04 +0100, srallapally_at_netscape.net wrote (in message <7b3n2n$s8s$1_at_nnrp1.dejanews.com>):
>
> Hello, Okay so exporting a tablespace sounds stupid..perhaps i should have
> said exporting the tables/indexes belonging to a tablespace. Now, I am
> trying to write a script which does this. My question is can i specify
> multiple table names in one line ? e.g suppose the tables belonging to
> tablespace ts_A are X,Y,Z then is exp80 username/passwd full=n consistent=y

> compress=y tables=(X,Y,Z) a valid command ? any DBA among you ever try this ?

> any forseeable pitfalls like while importing it and such ? thanks

What I do is generate a paramfile using awk & sqlplus to select the table and tablespace names. When the tablespaces are on seperate devices you can win some speed by exporting & importing them in parallel.

nice work
--

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl

Received on Thu Feb 25 1999 - 23:20:14 CST