Plsql Developer Operation

1. Setting

1) Download 32-bit Oracle Instantclient
2) Extract the Oracle instantclient to a directory 3) Set environment variables (modify Nls_lang and tns_admin environment variables) for Nls_lang environment variables, preferably set to the same database side, first query the character set information from the database side:
Sql> Select Userenv (' language ') Nls_lang from dual;

2. CREATE TABLE Space

Create Tablespace User_data
Logging
DataFile ' D:\oracle\oradata\Oracle9i\user_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
Edit:
Delete: Drop tablespace tablespace_name

3. Create user set permissions

4. Data export:

Exp System/manager FILE=D:\DAOCHU.DMP

5. Data import:

Imp system/manager file=d:\daochu.dmp fromuser= "touser="

Plsql Developer Operation