使用Oracle创建数据库

1.连接数据库

export ORACLE_SID=mydb
sqlplus /nolog
connect / as sysdba

2.创建表空间

create tablespace mydbtest datafile ‘/home/oracle/mydb.dbf’ size 1000m;

3.创建用户

create user mydbuser identified by mypassword default tablespace mydbtest;

4.用户授权

grant create session,create table,unlimited tablespace to mydbuser;

5.用户授权dba

grant dba to mydbuser;

6.查询表空间

SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;

7.根据表空间查询表空间磁盘地址

SELECT * FROM Dba_Data_Files ddf WHERE ddf.tablespace_name = 'DUAL_REFERRAL';

8.导入DMP文件

imp  username/password@localhost/orcl file='E:\*.dmp' full=y;

9.导出DMP文件

exp system/666666@ORCL file=f:\demo\demo1.dmp full=y

exp system/666666@ORCL file=f:\demo\demo2.dmp owner=ORACLEDEMO(导出用户(例如我创建的ORACLEDEMO用户)下所有数据)