Re: A newbe question about importing a dmp and creating a tablespace
Date: 23 Jan 2003 18:01:22 -0800
Message-ID: <2687bb95.0301231801.54f568a5_at_posting.google.com>
"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