Re: import problem - newbie question

2003-03-28 Thread Darrell Landrum
LeRoy, Even though you start your import as system, when the process starts to import tables owned by (for example) 'appuser' it will switch to that user. What I'm thinking is that you should create the user in advance of starting the import and give the user adequate tablespace quota. I may be m

import problem - newbie question

2003-03-28 Thread LeRoy Kemnitz
I am exporting data from production to test database. I receive error of 'no privledges on tablespace'. I dropped the user from the test box and trying import full from the schema export I created. Not sure what I am doing wrong. I am running 8.1.7 on Unix. imp system/* file=uwsa.dmp log=