启动数据库 oracle用户:
[oracle@oraclehost ~]$ sqlplus /nolog;
conn /as sysdba;
startup;
shutdown;
启动监听 oracle用户:
lsnrctl start;//监听启动
lsnrctl stop;//监听停止
lsnrctl status;//监听状态
/*分为三步 */
/*第1步:创建数据表空间 */
create tablespace house
logging
datafile '/u01/app/oracle/oradata/orcl/house.dbf'
size 500m
autoextend on
next 50m maxsize 20480m
extent management local;
/*第2步:创建用户并指定表空间 */
/* 用户名 密码*/
create user house identified by house
default tablespace house
temporary tablespace temp;
/*第3步:给用户授予权限 */
grant connect,resource,dba to house;
------------------------------
root用户:
mkdir -p /u01/app/oracle/dmpdir;
chmod -R 777 /u01/app/oracle/dmpdir;
oracle用户:
[oracle@oraclehost ~]$ sqlplus /nolog;
SQL> conn /as sysdba;
SQL> CREATE DIRECTORY dmpdir AS '/u01/app/oracle/dmpdir';
Directory created.
SQL> GRANT read, write ON DIRECTORY dmpdir TO scott;
Grant succeeded.
开始用 datapump 导出
[oracle@oraclehost ~]$ expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
//"dmpdir" 为导出目录;
//"scott.dmp" 为导出的 datadump 文件;
导入到另一个数据库
$ impdp system/oracle DIRECTORY=dmpdir DUMPFILE=scott.dmp