Re: Tablespace export ???? how ???

nuno....

are u referring to transportable tablespaces ???? i don't think transportable tablespaces solves my problem...coz i will be using the same datafiles ( as i have understood from the documentation...also transportable tablespaces do not copy rows ?????)

i really didn't uderstand ur explanation pal....forgive me...could u please elaborate..????

what i basically need to do is this :

i have a user with all his objects on a tablespace which is obscenely sized...and i know that it can be accomodated in less than half the space....so i need to do away with all those giant sized datafiles, recreate decently sized ones with all the data in it....

thanx in advance
venkat

"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3abd8566.2593134_at_news-server...
> On Sun, 25 Mar 2001 13:34:40 +0800, "Venkat Iyer"
> <venkat_p_iyer_at_yahoo.com> wrote:
>
> >i'm trying ot reclaim some space from my datafiles....i need to drop a
> >tablespace and recreate it with the rite storage and sizing
> >parameters.....how do i just export the contents of a tablespace, drop it
> >and recreate it ?????
> >
>
> Hehehe! Look at how exp operates. It uses views kept in catexp.sql.
> Create your own copy of these, modify to only look at a single, named,
> tablespace, then create them in user other than SYSTEM. Give this
> user export database rights and you're away.
>
> <Copyleft method, all rights made public>
>
> HTH
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Sun Mar 25 2001 - 00:09:15 CST