Hello gurus
I am in a position to export a user and drop it then
create again and import it. Why I am doing this is
because I want to change the default tablespace of the
user to a different one and also its tabel are out of
extents.
Now , my question ; may be very stupid though, Would
it break anything like indexes and views depends on
it. Once imported back everything would be same as it
was before.
Is there a way I know how many views , indexes and
every other objects depend on this user before even I
export.
All help is much appreciated.
Thank you very much
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kishore
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
