Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transfer a complete database (8i)
Hi,
Try this simple method.
1. Create identical directory structure for Oracle database as in your
source server.
2. Cleanly shutdown your source database.
3. Transfer all your datafiles,controlfiles,redo log
files,initiallization parameter files to the identical new location.
4. startup your new database
bye
Nilanjan
"Punu" <punupuatoro_at_NOSPAMfairesuivre.com> wrote in message news:<asfbka$p3n$1_at_s1.read.news.oleane.net>...
> Hello,
> I have to migrate my 8.1.7 database to a new server. I would like to migrate
> the entire database (schemas, user defs, etc...)
> I have tried to do an export and an import on the new server but the user
> defs are not transfered :
> exp system/manager BUFFER=4096 FULL=Y FILE=/backup/expdat.dmp
> Is there a solution ?
> Thanks a lot.
Received on Tue Dec 03 2002 - 04:07:04 CST