RE: Imp keeps putting data in SYSTEM

check what the default tablespace for this user is .. might be that the user whose schema you are improting in has its default tablespace set to system

deepAk

-----Original Message-----
From: Jeff Wiegand [mailto:jwiegand_at_ancept.com] Sent: Tuesday, May 23, 2000 9:00 AM
To: Multiple recipients of list ORACLE-L Subject: Imp keeps putting data in SYSTEM

We have some databases with user data is SYSTEM.

I exported the data, and set the users default tablespace to users, temporary tablespace to temp, quota 0 on SYSTEM.

Upon import, the users data goes right back into the SYSTEM tablespace.

I've also tried dropping and recreating the user.

I've set import from the command line:

imp user file=user.dmp

I've tried it this way:

imp user file=user.dmp fromuser=user touser=user

Still, the data is placed into SYSTEM.

Why, Why, Why?????????

Jeff

-- 
Author: Jeff Wiegand
  INET: jwiegand_at_ancept.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).