Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Imp keeps putting data in SYSTEM

Imp keeps putting data in SYSTEM

From: Jeff Wiegand <jwiegand_at_ancept.com>
Date: Tue, 23 May 2000 09:42:52 -0500
Message-Id: <10506.106375@fatcity.com>


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????????? Received on Tue May 23 2000 - 09:42:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US