Re: import problem

Hi Andrew,
The most obvious reason for this is the original tables reside in the SYSTEM tablespace. As resource privilege provides the user with UNLIMITED TABLESPACE privilege the tables will be created in the tablespace define in the CREATE TABLE statement, regardless of any quota. Please verify this by running your imp with show=y log=<any filename>

Hth,

Sybrand Bakker, Oracle DBA

Andrew (Work) wrote in message <7f2v0d$5d8$1_at_news6.svr.pol.co.uk>...
>I'm having a bit of trouble, I have a script that creates users and then
>imports tables into them, HOWEVER the tables get placed in the system
>tablespace, why???
>
>here's the scripts what am I missing? the tablespaces are online they have
>quotas on them it's their default tablespace.......
>
>
>Rem The file SETUP.SQL
>Rem Creates the Interlab and Datalab tablespaces and users
>Rem for Oracle 7
>
>
>create tablespace interlab
>datafile 'c:\orawin95\database\ilab1.ora' size 5m
>autoextend on
>next 1m
>maxsize 15m
>/
>
>
>create tablespace datalab
>datafile 'c:\orawin95\database\dlab1.ora' size 5m
>autoextend on
>next 1m
>maxsize 15m
>/
>drop user interlab cascade
>/
>drop user datalab cascade
>/
>create user interlab
>identified by holland
>default tablespace interlab
>temporary tablespace temporary_data
>quota unlimited on interlab
>/
>grant connect, resource
>to interlab
>/
>create user datalab
>identified by belgium
>default tablespace datalab
>temporary tablespace temporary_data
>quota unlimited on datalab
>/
>grant connect, resource
>to datalab
>/
>
>host a:\import7.bat
>
>
>del c:\datalab.dmp
>del c:\interlab.dmp
>copy a:\datalab.dmp c:\datalab.dmp
>copy a:\interlab.dmp c:\interlab.dmp
>c:\orawin95\bin\imp system/manager file=c:\Datalab.dmp fromuser=datalab
>touser=datalab tables=(*)
>c:\orawin95\bin\imp system/manager file=c:\Interlab.dmp fromuser=interlab
>touser=interlab tables=(*)
>del c:\datalab.dmp
>del c:\interlab.dmp
>
>could the answer be posted direct as well as on the newsgroup???
>
>Thanks in advance
>
>Andrew
>
>
Received on Sun Apr 18 1999 - 03:17:06 CDT