Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving Oracle 8i DB from /abc to /def
It shouldn't be too hard. Follow these instructions.....
This was just off the top of my head and may require some tweaking...
Cheers,
Brian
"Steve N." wrote:
>
> Hi All,
>
> I have an Oracle 8.1.6 (Enterprise Ed.) database that has a UNIX
> datafile-based configuration. Its laid out in a directory structure
> that starts with /live. I want to take a copy of that database and
> place it in /save. We are not using RMAN.
>
> At present, we know of two ways to do this:
>
> 1) Export all the data, then import it into another database.
>
> 2) Use exp with TRANSPORT_TABLESPACE, copy all the files into the new
> directory, then imp the metadata.
>
> Both of these are very time consuming. I was wondering if there was a
> way to shutdown the database, simply copy all the data files to the
> new directory, then somehow tell the control file to find the data
> files in the new directory instead of where they were previously.
>
> Does anyone know how this might be done? I've had to recover from a
> lost controlfile before so I know we can recreate that using trace
> files, so I was thinking it may be possible to alter the file paths so
> that it finds the new files in the new location in the process...
>
> Thanks in advance for any ideas...
>
> Regards,
>
> SteveN.
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Aug 04 2003 - 14:01:00 CDT