IMP data to the specified tablespace

When IMP data is imported to the specified tablespace through imp, the data is imported to the tablespace corresponding to the dmp file generated by exp by default. For example, if you use orcl_dev user and exp data and orcl_test user imp data, the data will be imported to the original tablespace by default. Www.2cto.com: Current tablespace dev, user orcl_dev, export data. Create a TABLESPACE testCREATE TABLESPACE test DATAFILE 'd: \ oracle \ data \ test. dbf 'size 50 m autoextend on next 1024 m maxsize unlimited extent management local autoallocate blocksize 8 k segment space management auto flashback off; www.2cto.com new user orcl_test, create the user create user orcl_test identified by "orcl_test" -- specify the user's default tablespace as test default tablespace test; -- Grant/Revoke role privileges grant connect to orcl _ Test; grant resource to orcl_test; -- Grant/Revoke system privileges grant create database link to orcl_test; grant create view to orcl_test; grant debug any procedure to orcl_test; grant debug connect session to orcl_test; -- revoke the unlimited permission of the table space from the table space revoke unlimited tablespace from orcl_test; -- then grant the user the permission of the current table space. Alter user orcl_test quota unlimited on orcl_test; once again, imp orcl_test/orcl_test data has been imported into the test tablespace.