Andrew Clark wrote:
> Hello,
>
> I have fixed my error 1659's and now I just have to create some users
> that the designers of the database neglected to mention. This is what I
> have so far:
>
> CREATE TABLESPACE foo DATAFILE 'F:\DATABASE\foo.ORA' SIZE 200M AUTOEXTEND
> ON NEXT 1M MAXSIZE 400M;
>
> CREATE USER foouser
> IDENTIFIED BY foopass
> DEFAULT TABLESPACE foo
> TEMPORARY TABLESPACE footemp
> QUOTA UNLIMITED ON foo
> QUOTA UNLIMITED ON footemp;
>
> GRANT CONNECT TO foouser;
>
> That creates the user and the tablespace that no one told me about! Now I
> would like to import ONLY this new user's objects from my dump file using
> imp. Should this work?
>
> imp LOG=C:\Data\IMPLOG.log FILE=C:\Data\IMPORT.dmp FROMUSER=foouser
> TOUSER=foouser
>
> I ask because I do not want to screw it up and have to do the whole
> import over. Thanks!
>
> Andrew
Yes. But sitting around asking questions like this to avoid screwing
things up is really good way to not learn anything. Get used to doing
things several times and learning from the experience.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Mar 07 2005 - 21:17:28 CST
