随便做了个测试,没发现问题
SQL> conn study/study@ora10g
Connected
SQL> select * from session_privs;
PRIVILEGE
----------------------------------------
CREATE SESSION
CREATE TABLE
SELECT ANY TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
SELECT ANY DICTIONARY
11 rows selected
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDO1
SYSAUX
TEMP
USERS
DATA_01
INDEX_01
DATA_LOB_01
DATA_LOB_02
INDEX_LOB_01
INDEX_LOB_02
TOMS_10G
12 rows selected
SQL>
SQL> Create table test
2( A integer,
3B blob
4)
5LOB(b)
6STORE AS (TABLESPACE DATA_LOB_01)
7 TABLESPACE data_01;
Table created
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME
TABLESPACE_NAME
------------------------------ ------------------------------
TEST
DATA_01
SQL> select table_name,column_name,tablespace_name from user_lobs where table_name='TEST';
TABLE_NAME COLUMN_NAMETABLESPACE_NAME
---------------- ---------------- ---------------
TEST
B
DATA_LOB_01
C
racle10gBIN>expdp system/admin dumpfile=study.dmp schemas=study
Export: Release 10.2.0.2.0 - Production on Saturday, 26 July, 2008 18:26:26
Copyright (c) 2003, 2005, Oracle.All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":system/******** dumpfile=study.dmp sc
hemas=study
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 640 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "STUDY"."SERVER_INFO"
7.140 KB36 rows
. . exported "STUDY"."TOMS_REGION_DEF"
7.601 KB18 rows
. . exported "STUDY"."TOMS_TABLES"
9.640 KB 1 rows
. . exported "STUDY"."TOMS_TAB_COLUMNS"
7.734 KB 1 rows
. . exported "STUDY"."TOMS_TOOLS_DEF"
7.601 KB18 rows
. . exported "STUDY"."TEST"
0 KB 0 rows
. . exported "STUDY"."TOMS_SOURCE_SQL"
0 KB 0 rows
. . exported "STUDY"."TOMS_SQL"
0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
C:ADMINORA10GDPDUMPSTUDY.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:28:01
C
racle10gBIN>impdp system/admin dumpfile=study.dmp remap_tablespace=(data_01
:index_01,data_lob_01:data_lob_02) remap_schema=(study:zrp) schemas=study
Import: Release 10.2.0.2.0 - Production on Saturday, 26 July, 2008 18:28:56
Copyright (c) 2003, 2005, Oracle.All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":system/******** dumpfile=study.dmp re
map_tablespace=(data_01:index_01,data_lob_01:data_lob_02) remap_schema=(study:zr
p) schemas=study
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ZRP"."SERVER_INFO"
7.140 KB36 rows
. . imported "ZRP"."TOMS_REGION_DEF"
7.601 KB18 rows
. . imported "ZRP"."TOMS_TABLES"
9.640 KB 1 rows
. . imported "ZRP"."TOMS_TAB_COLUMNS"
7.734 KB 1 rows
. . imported "ZRP"."TOMS_TOOLS_DEF"
7.601 KB18 rows
. . imported "ZRP"."TEST"
0 KB 0 rows
. . imported "ZRP"."TOMS_SOURCE_SQL"
0 KB 0 rows
. . imported "ZRP"."TOMS_SQL"
0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 18:29:37
C
racle10gBIN>
C
racle10gBIN>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jul 26 18:12:22 2008
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter user zrp identified by zrp;
User altered.
SQL> conn zrp/zrp;
Connected.
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME
TABLESPACE_NAME
------------------------------ ------------------------------
TEST
INDEX_01
SQL> select table_name,column_name,tablespace_name from user_lobs where table_name='TEST';
TABLE_NAMECOLUMN_NAMETABLESPACE_NAME
--------------- ---------------- ---------------
TEST
B
DATA_LOB_02
SQL>
|