[oracle@node1 ~]$ sqlplus phil/phil

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 2 17:28:15 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace imptest datafile '/u01/app/oracle/oradata/PHIL112/imptest.dbf' size 100m;

Tablespace created.

SQL> create user imptest identified by imptest default tablespace users;

User created.

SQL> grant connect, resource to imptest;

Grant succeeded.

SQL> conn imptest/imptest
Connected.
SQL> create table imptesttable ( a number ) ;

Table created.

SQL> insert into imptesttable values ( 1 ) ;

1 row created.

SQL> commit;

Commit complete.

SQL> select tablespace_name from user_tables;

TABLESPACE_NAME
------------------------------
USERS

SQL> quit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ exp imptest/imptest file=imptest.dmp;

Export: Release 11.2.0.2.0 - Production on Tue Oct 2 17:28:50 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user IMPTEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user IMPTEST
About to export IMPTEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export IMPTEST's tables via Conventional Path ...
. . exporting table                   IMPTESTTABLE          1 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@node1 ~]$ sqlplus phil/phil

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 2 17:28:56 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> drop table imptest.imptesttable;

Table dropped.

SQL> alter user imptest default tablespace imptest;

User altered.

SQL> revoke unlimited tablespace from imptest;

Revoke succeeded.

SQL> alter user imptest quota 0 on users;

User altered.

SQL> quit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ imp imptest/imptest file=imptest.dmp;

Import: Release 11.2.0.2.0 - Production on Tue Oct 2 17:29:19 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
. importing IMPTEST's objects into IMPTEST
. . importing table                 "IMPTESTTABLE"
IMP-00058: ORACLE error 1536 encountered
ORA-01536: space quota exceeded for tablespace 'USERS'
Import terminated successfully with warnings.
[oracle@node1 ~]$