Oracle 10g importing data into a specified table space

2. --Create a temporary table space
4. Create temporary tablespace yhtemp
6. Tempfile ' d:/oracle/oradata/oracle10g/yhtemp.dbf '
8. Size 50m
10. Autoextend on
12. Next 50m maxsize 20480m
14. Extent management Local;
18. --Create a data table space
20. Create Tablespace YH
22. Logging
24. DataFile ' d:/oracle/oradata/oracle10g/yh.dbf '
26. Size 50m
28. Autoextend on
30. Next 50m maxsize 20480m
32. Extent management Local;
36. --Create a user and specify a tablespace
38. Create user yh identified by password
40. Default Tablespace YH
42. Temporary tablespace yhtemp;
46. --Granting permissions to users
48. Grant CONNECT,RESOURCE,DBA to YH;
52. --Revoke this permission
54. Revoke unlimited tablespace from YH
58. --Set the user's quota for the Yss,test1 table space to 0
60. Alter user YH quota 0 on Yss
62. Alter user YH quota 0 on Test1
66. --Set the user's quota in the YH table space is not limited
68. Alter user YH quota unlimited on YH

Reprint to another blog, I use this step to import success

There are a few novice need to note, in the import time with their own established user name and password when landing, do not use SYSDBA permissions, or will be imported into the SYS user,

After the successful import, to view the table, with their own established user name and password login do not use SYSDBA login, otherwise you can not see the table you imported

Oracle 10g importing data into a specified table space