Oracle Database tablespace issues during project implementation

Problem description: Some time ago, when the project was deployed on the server of the customer's data center, we found that the tables of our test database were all placed under the system or users tablespace. The corresponding table is not placed in the corresponding tablespace. For example, when I create a cncb tablespace and database user, the data is not imported to the corresponding tablespace when we import data, as shown in: For this reason, I checked some information online and processed it as follows: SQL code -- first, back up the database exp cncb/join @ orcl file = f: \ cncb20120331.dmp owner = (cncb) revoke unlimited tablespace from cncb; www.2cto.com alter user cncb quota 0 on tablespace name; -- Supplement: All Tables with cncb in other tablespaces execute the preceding statement, it is absolutely guaranteed that the quota of cncb storage space for other tablespaces is set to 0 alter user cncb quota unlimited on cncb; -- after execution, refresh the database you just backed up, as shown in: by the way, the tablespace creation command in Windows is: (windows and Linux are slightly different.) First, Log On As A dba, alternatively, use sqlplus or plsqlSql code sqlplus/nolog connect system/admin @ ORCL as sysdba drop tablespace test including contents; create tablespace test datafile 'f: \ oracle \ product \ 10.2.0 \ oradata \ ORCL \ test. ora 'size 100 m reuse autoextend on maxsize unlimited default storage (initial 320 k next 320 k minextents 1 maxextents unlimited pctincrease 0 ); -- create user database username identified by password default tablespace name temporary tablespace temp; www.2cto.com -- authorization, generally for convenience, we directly authorize dba grant dba to database user; create a tablespace in Linux: SQL code -- create temporary tablespace test_temp tempfile '/opt/oracle/oradata/orcl/test_temp01.dbf' size 64 m autoextend on next 65 m maxsize 2048 m extent management local; -- create a tablespace create tablespace test_data logging datafile '/opt/oracle/oradata/orcl/test_data01.dbf' size 64 m autoextend on next 65 m maxsize 2048 m extent management local; author laoli5290