Re: Import Database
Date: 1996/11/14
Message-ID: <01bbd282$981958c0$510a07c2_at_year2751>#1/1
All you have to make sure of is, that if you want to import the database in 7.3 the tablespace names are the same. It doesn't realy matter how big they are and how you define them. As long as Oracle can find them by name, it should work.
Keep in mind that if you want an exact replica of the 7.1 database with exactly the same tablespace on the same locations, rollback segments, etc. you do not even need to precreate the tablespace all you must do is create the database and then run imp and you should be fine.
Arnoud
Fanie Dai <fanie_at_ockham.stanford.edu> wrote in article
<328A79A2.7EDE_at_ockham.stanford.edu>...
> Hi, there
>
> We are working on Oracle ver 7.1.4 now. My company just got a new version
of Oracle
> (7.3.2). And we installed it on our new server. When we installed this
new version of
> Oracle , we didn't install default Database. Now I try to use SQL command
to create
> Database. My question is :
> Should I use the same stucture (eg. same tablespace name ,space,
definition ) as the old
> Database when I import full Database (I already exported our current
using Database)?
>
>
> Thanks in advance!
>
Received on Thu Nov 14 1996 - 00:00:00 CET