Oracle 10 GB Data import to the specified tablespace

1. -- Create temporary tablespace
2. Create temporary tablespace yhtemp
3. Tempfile 'd: \ oracle \ oradata \ Oracle10g \ yhtemp. dbf'
4. Size 50 m
5. Autoextend on
6. Next 50 m maxsize 20480 m
7. Extent management local;
9. -- Create a data table space
10. Create tablespace YH
11. Logging
12. Datafile 'd: \ oracle \ oradata \ Oracle10g \ YH. dbf'
13. Size 50 m
14. Autoextend on
15. Next 50 m maxsize 20480 m
16. Extent management local;
18. -- Create a user and specify a tablespace
19. Create user YH identified by password
20. Default tablespace YH
21. Temporary tablespace yhtemp;
23. -- Grant permissions to users
24. Grant connect, resource, DBA to YH;
26. -- Revoke this permission
27. Revoke unlimited tablespace from YH
29. -- Set the table space quota of the user in YSS and test1 to 0.
30. Alter user YH quota 0 on YSS
31. Alter user YH quota 0 on test1
33. -- The user's quota in the YH tablespace is not limited.
34. Alter user YH quota unlimited on YH

Reposted to another blog. I imported the data in this step successfully.

Note that you should not use the sysdba permission when logging on to the system using your username and password. Otherwise, the system will import the data to the Sys user,

After the import is successful, when you want to view the table, do not use sysdba to log on with your own user name and password. Otherwise, you cannot see the imported table.