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,
>
> 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!
You don't need to construct perfectly matching sets of tablespaces. You must get the names right and the sizes must ok, but if your DB is as small as you say that should not be a problem. You don't need to create tablespaces that have the exact same physical filenames - what matters from the perspective of 'import' is the tablespace name, not the names of its component files.
The two data dictionary views you should look at are:
DBA_TABLESPACES
DBA_DATA_FILES
You might find this SQL Statement useful:
select t.tablespace_name, f.file_name, f.bytes/(1024*1024) size_mb from dba_tablespaces t
, dba_data_files f
where t.tablespace_name = f.tablespace_name
/
You absolutely, positively, must install oracle on the new machine first. The fact that you even asked this question suggests that you should do a few dry runs before the real thing :). When you install Oracle get it to buid a starter database as well. Then you can add your stuff to it rather than having to figure out the magic DB creation incantation from scratch.
You need to read on the following:
Don't expect this to work the first time. Write unix scripts for things - you may have to repeat different steps and life will rapidly get tedious if you don't. I would suggest you break this up as follows: