Re: Export / IMPORT on Oracle 7

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 11 Jan 2003 19:24:13 +0100
Message-ID: <16o02vk9l4toiq9gd3jms5vk5udbs2k8i3@4ax.com>

On Sat, 11 Jan 2003 10:38:07 -0500, Lorraine Lachoade <Lorraine_lachoade_at_hotmail.com> wrote:

>After I install Oracle 7 server, how do I first create the
>tablespaces?
>
>I assume once I have the tablespace created, I only then need to
>create the same user name / password as on the source server so that I
>can import.

A full database export has
- the create tablespace statements
- the create user statements

If you want to change file locations, you need to run the import with show=y log=<any filename> first, and edit the create tablespace statements from <any file> with vi.
There should be no need to precreate the users. As import/export didn't change in later versions, you can use the 8i server utilities manual to get further info.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jan 11 2003 - 12:24:13 CST