- 连接数据库命令:
sqlplus sys/orcl@orcl as sysdba
- 创建FDLIS_SPACE01表空间执行:
CREATE TABLESPACE FDLIS_SPACE01 DATAFILE 'D:\develop_tools\oracle\oradata\orcl\FDLIS_SPACE01.dbf' SIZE 200M AUTOEXTEND ON;
- 创建fdlis 用户,密码combobox执行:
CREATE USER fdlis IDENTIFIED BY combobox DEFAULT TABLESPACE FDLIS_SPACE01 TEMPORARY TABLESPACE temp;
- 为用户赋权限执行:
GRANT CREATE SESSION,CREATE TABLE,CREATE VIEW,CREATE SEQUENCE,UNLIMITED TABLESPACE TO fdlis;
GRANT CONNECT TO fdlis;
GRANT RESOURCE TO fdlis;
GRANT DBA TO fdlis;
不需要登陆sqlplus, 进入命令窗口后,直接输入一下命令:
- 导入数据库命令:
imp fdlis/combobox@orcl file=E:\fdlis\FDLIS\fdlis1.dmp log=E:\fdlis\FDLIS\fdlis1.log rows=y FULL=y
新版本使用 impdp 命令。
- 导出命令:
exp fdlis/combobox@orcl owner=fdlis file=E:\fdlis\FDLIS\fdlis1.dmp log=E:\fdlis\FDLIS\fdlis1.log
新版本使用 expdp 命令。