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

"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

You have to import to user id, but it does not have to be the same user whose objects were exported proving you perform the import using the fromuser= touser= parameters. The imp and exp utilities are documented in the Utilities manual. From the command line type imp help=y for a quick list of parameters.
You do not have to create the same tablespace for a fromuser touser import. The tables will default to the touser default tablespace along with the indexes, which may be undesirable but you can use alter index move commands to reposition them among other methods.

To learn how to create a user see the "create user" command in the SQL manual:
create user NAME identified by PASSWORD
default tablespace usr <== create tables without tablespace go here
temporary tablespace tmp <== sort tablespace ususally named temp

Example import
imp file=mydump.dmp buffer=1048576 fromuser=olduser touser=newuser log=mylog

The best place to start when learning Oracle is to read the Concepts manual followed by the DBA Administration manual.

HTH -- Mark D Powell -- Received on Fri Jan 24 2003 - 03:01:22 CET