Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Help on import/export
Stefan Dohn wrote:
>
> Hey there, I have 2 Linux Servers whith Oracle
> 8.1.6 my boss told me to migrate all tablespaces
> from on maschine to the second. But I can not find
> a way to do this. Can someone tell me in detail
> how I can do that ? Yes, I see there are imp and exp,
> but how to use them in detail ?
1. Shutdown the instance on sevre 1.
2. Copy all files (control, log files, database files, password files,
and init files) from server 1 to server 2. maintaining the files in the
proper directories.
3. Set up the environment on server 2 (ORACLE_HOME, etc.)
4. Start the instance on server 2
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Mon Nov 05 2001 - 14:53:28 CST