Re: Create new user on Oracle 8.0.3 for a specific database

On the shell type

SET ORACLE_SID=<ORACLE8_SID> where ORACLE8_SID is the identified of the instance you want to create the new user in. then
SQLPLUS SYSTEM/MANAGER
CREATE USER HENRYK IDENTIFIED BY XXX
DEFAULT TABLESPACE YYY
TEMPORARY TABLESPACE ZZZZ;
GRANT DBA T HENRY; (But you don't need to be a DBA though) EXIT; then perform the import and that's it !!!

Let me know if this helps
Philippe Backouche

Henrik Meldgaard Frisk a écrit :

> 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 - 15:42:55 CST