Re: Moving entire 8.1.7 database b/t machines

A full database import of a full database export recreates everything. It starts with the tablespaces, exactly as they where in the origin database. So datafiles will be created with the same names. When the directories do not exist, tablespace creation will fail. As a result, creating/altering users where the default tablespace does not exist will fail. Importing objects for users that do not exist will fail..... If tablespace creation failed you should create proper sized tablespaces before full import starts.
Also be aware of the fact that nothing of the SYS schema is exported (because it is the owner of the database dictionary that is created when the database was created).
Grants given by SYS on SYS objects must be re-granted after import. There are other schemas for special database options excluded from full export/import, see the Oracle 8i Utilities Guide, Chapter "Import".

Robert Banniza <robert_at_rootprompt.net> schreef in berichtnieuws alei29$lnr$1_at_news.laserlink.net...
| I tried this and still got many errors about altering schemas owned by
| unknown users.
|
| Robert
|
| "Tom" <tomNOSPAM_at_eazyriders.com> wrote in message
| news:pWte9.4288$mf1.33439957_at_news-text.cableinet.net...
| > did you do full=y as this should take the users with it?
| >
| > Tom
| >
| > "Robert Banniza" <robert_at_rootprompt.net> wrote in message
| > news:aldh71$4j8$1_at_news.laserlink.net...
| > > I have an Oracle instance I'm running on a Sun 3800. I'm wanting to
 make
 an
| > > exact replica of this database on a 420R for testing and general
 trashing
 to
| > > try to some new things. I thought using exp to export the entire
 database
| > > (COMPLETE) and then using imp on the 420 to import the database would
 do
| > > the trick. However, I'm getting all kinds of errors about users not
 existing
| > > and such. Therefore, how can I move the entire database without taking
 the
| > > prod database offline? If I am on the right track with exp/imp, can
 you
 tell
| > > me what flags I need to do this? I have looked everywhere and nothing
 seems
| > > to be working. I want to bring users over as well. Any help
 appreciated.
| > >
| > > Robert
| > >
| > >
| >
| >
|
|
Received on Sun Sep 08 2002 - 06:34:55 CDT