Originally posted by pnrdba
NOT AT ALL!!!!!! Now this says, definitely you need to take a small training on export/import.

Import definitely fails if the same tablespaces are not found.
It will not fail definitely. You will have problems with large objects but look at what I just did:

SQL*Plus: Release 9.2.0.2.0 - Production on Fri Jan 17 13:05:10 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
--------------------------------------------------------------------------------
SYSTEM
UNDOTBS
TEMP
SAPDW_DATA
SAPDW_INDEX
USERS

6 rows selected.

SQL> create user A1 identified by a1 default tablespace SAPDW_DATA;

User created.

SQL> create user A2 identified by a2 default tablespace USERS;

User created.

SQL> grant connect, resource to A1;

Grant succeeded.

SQL> grant connect, resource to A2;

Grant succeeded.

SQL> conn A1/a1
Connected.

SQL> create table t1 (abc timestamp);

Table created.

SQL> insert into t1 values (systimestamp);

1 row created.

SQL> commit work;

Commit complete.

SQL> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
JServer Release 9.2.0.2.0 - Production

sapdw_v70:/opt/oracle9>cd /u04/arch1/sapdw_v70
sapdw_v70:/u04/arch1/sapdw_v70>ls -lrt

total 20496
-rw-r----- 1 oracle92 dba 10484736 Jan 13 20:14 arc_1_48.arc

sapdw_v70:/u04/arch1/sapdw_v70>exp userid=system/****** file=x.dmp owner=A1

Export: Release 9.2.0.2.0 - Production on Fri Jan 17 13:13:25 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
JServer Release 9.2.0.2.0 - Production
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user A1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user A1
About to export A1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export A1's tables via Conventional Path ...
. . exporting table T1 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.
sapdw_v70:/u04/arch1/sapdw_v70>

SQL> conn / as ssydba
SQL> drop tablespace sapdw_data including contents and datafiles;

sapdw_v70:/u04/arch1/sapdw_v70>imp userid=system/***** file=x.dmp fromuser=A1 touser=A2

Import: Release 9.2.0.2.0 - Production on Fri Jan 17 13:26:47 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
JServer Release 9.2.0.2.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing A1's objects into A2
. . importing table "T1" 1 rows imported
Import terminated successfully without warnings.

SQL> select table_name, tablespace_name, owner from dba_tables where owner in ('A1','A2');

TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
--------------------------------------------------------------------------------
OWNER
--------------------------------------------------------------------------------
T1
USERS
A2