Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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????????? Received on Tue May 23 2000 - 09:42:52 CDT
![]() |
![]() |