Re: copy user accounts

From: philippe rigaux <pri_at_freeos.tzo.org>
Date: Sat, 18 Dec 1999 00:05:44 +0100
Message-ID: <385ac07c$1_3@goliath.newsfeeds.com>

Simply do a full export, create your new database with the new file locations, create all tablespaces, then import the file with option full=y ignore=y.

That's it !

Philippe

don't forget to verify that all object are VALID (status in DBA_OBJECTS) if not :
alter OBJECT_TYPE OWNER.OBJECT_NAME compile;

"S. Han" <shan168_at_yahoo.com> a écrit dans le message news: 83c5tp$rle$1_at_nnrp1.deja.com...
> We are moving the entire database from one NT to another.
> I have to copy all user accounts/roles/profilesso that everything will
> be transparent to the users. How can I do this? Using a script (but no
> passwords) or export utility? Any help will be deeply appreciated!
>
> shan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Dec 17 1999 - 17:05:44 CST