Re: export Oracle7 - import Oracle8

On Tue, 5 Feb 2002 06:44:22 +1100, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>You will indeed need to create all your own tablespaces, with the same names
>as you had in your 7 database. But that should be all you need to do: the
>dump file is quite happy to re-create all Users and roles for you.
>Unfortunately, the lines in the dumpfile requesting the creation of
>tablespaces have the old database's paths and filenames hard-coded in it, so
>unless you're importing on a machine which is laid out physically exactly as
>the source, those lines can't do their job.

Or you can just pre-create the objects and do the import with the "ignore=Y" option.

An easy way to pull the DDL out of the database and modify the tablespaces and storage clauses is to use the freeware DBATool. A few clicks of the mouse can swap the tablespace and storage clauses across the entire database.

DBATool: http://www.databee.com/dt_home.htm

Regards
Dale Edgar
Dale_at_DataBee.com Received on Mon Feb 04 2002 - 14:31:32 CST