Re: A newbe question about importing a dmp and creating a tablespace

You would normally do these tasks from the SYSTEM account:

create tablespace <tsname>
datafile 'fully_qualified_file_name' size 128m;

create user <username>
identified by <password>
default tablespace <tsname>
temporary tablespace <temp tsname>
quota unlimited on <tsname>;

grant connect to <username>;

Good luck, Tim

"Jens Fudge" <Jens.Fudge_at_archersoft.dk> wrote in message news:3e2fc1f9$0$148$edfadb0f_at_dread15.news.tele.dk...
> Hi there
>
> I have installed an Oracle 8.1.7i PE Oracle database on a Win98 machine.
> I need to import a dmp file from a specific user.
> The guy who gave me the dump file, said that I need to create a table
 space
> for it.
>
> How do I create a tablespace?
> Do I need to create a user with the same name as the dmp's user? Or does
 it
> do this automatically?
> If I need to create a user, how do I do this?
>
>
> Sorry for asking such dumb questions, but I'm new in managing an Oracle
 db.
>
> Thanks in advance.
>
> Jens Fudge, Archersoft
>
>
Received on Fri Jan 24 2003 - 03:02:43 CET