Oracle Plsql Code backwards

Log in to Plsql with the DBA user and Execute

The first step is to create a table space

CREATE Smallfile
Tablespace "ASSETS"
LOGGING
DataFile
' E:\ORACLE\PRODUCT\10.2.0\ORADATA\SDZC0216\ASSETS1.ora ' SIZE
500M Autoextend
On NEXT 10M MAXSIZE UNLIMITED,
' E:\ORACLE\PRODUCT\10.2.0\ORADATA\SDZC0216\ASSETS2.ora ' SIZE
500M Autoextend
On NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

Where assets is the table space name, ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\SDZC0216\ASSETS1.ora ' for the path, if you want to build multiple tablespace files, remember the back order +1

Assets1.ora Assets2.ora Assets3.ora .......

The second step is to create a user

Create User Username
Default tablespace Table Space name
identified by user password;

Step three, assign permissions
Grant DBA to User name;
Grant Select any table to user name;
Grant execute any procedure to user name;
Grant CREATE table to user name;

Fourth step, import the Library

Login Plsql with new user (knock on Blackboard, focus), select tool-Import Table

PS: If there is an error (such as a lack of table space, etc.), want to re-get, execute the bottom statement

Drop user username cascade; (dba user login execution)

Oracle Plsql Code backwards