Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to move Oracle database to a new machine?
"Joan" <joan48105_at_yahoo.com> wrote in message
news:39d54693.0404250808.4f8f4d15_at_posting.google.com...
> D Rolfe <dwrolfeFRUITBAT_at_orindasoft.com> wrote in message
news:<NTxic.5513$qP2.13375_at_news.indigo.ie>...
> > Joan,
> >
> > You didn't say what OS the new machine is - If it's different moving
> > data files around could get weird. Given how small the database is why
> > not just export it from the old machine and import it on the new machine
> > after creating a set of matching tablespaces? Not only is this very
> > simple you can practice it repeatedly without having to break into a
sweat.
> >
> > David Rolfe
> > Orinda Software
> > Dublin Ireland
> >
> >
>
> Thanks David. Bear with me if my question sounds too fundamental.
>
> To be able to create the matching tablespaces, I would assume I need
> to know how tablespaces are set up on the old system, right? Can this
> information be abtained from Data Dictionary Views completely? Do I
> need to reinstall Oracle on the new machine first? (The both machines
> run Linux, I am not sure what version) Use Export in User mode or full
> database mode?
>
> Thank you very much!
The names must match, file layout (number and location) can be different.
select * from dba_tablespaces I think, file ad path and size info select *
from dba_data_files
Jim
Received on Sun Apr 25 2004 - 11:21:46 CDT