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

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sun, 25 Mar 2001 09:41:29 GMT
Message-ID: <3abdbbb6.3561454@news-server>

On Sun, 25 Mar 2001 14:09:15 +0800, "Venkat Iyer" <venkat_p_iyer_at_yahoo.com> wrote:

>are u referring to transportable tablespaces ????

No bloody way!

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

Read it again. Have a look in your rdbms/admin directory and read the catexp.sql file. It describes the views that export (the program) itself uses. You change the views, you change the way export works. Got it?

>
>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....
>

That's even easier: export just that user. You can do that now, with standard export functionality.

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 - 03:41:29 CST