Re: copy user accounts
Date: Sat, 18 Dec 1999 00:05:44 +0100
Message-ID: <385ac07c$1_3_at_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 Sat Dec 18 1999 - 00:05:44 CET