Create new user on Oracle 8.0.3 for a specific database

From: Henrik Meldgaard Frisk <hfr_at_bang-olufsen.dk>
Date: Thu, 9 Dec 1999 13:23:45 +0100
Message-ID: <82o70k$me9$1@news.inet.tele.dk>

Hi all you out there.

I am working on a project where I have to export a 7.3.3 database into a 8.0.4
I have Created the new empty database on Oracle 8.0.4, the instance is started, and I have create my export file. Now I want to import the data from my export file, and here I get into trouble. As far as I can see, I first have to create a new user for the new database. Am I right about that?

If I am, how do I create the new user. I know the command <create user> but I just can't find where I can setup which database the user is created for. I allready have one databases running on Ora8, and the new user should only be for my new database.

Or maybe there is an parameter in the import paramater-file that specify which database I will import to.

Can anyone help me?

Henrik Received on Thu Dec 09 1999 - 06:23:45 CST