Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: copy user accounts
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
![]() |
![]() |