oracle常用语句

连接数据库
sqlplus sys/@orcl as sysdba;

新建用户
CREATE USER “USER” PROFILE “DEFAULT” IDENTIFIED BY “9003”
DEFAULT TABLESPACE “USERS” TEMPORARY TABLESPACE “TEMP” ACCOUNT UNLOCK;

赋予权限
GRANT CREATE ANY TABLE TO “USER”;
GRANT UNLIMITED TABLESPACE TO “USER”;
GRANT “CONNECT” TO “USER”;
GRANT “RESOURCE” TO “USER”;
GRANT CREATE ANY VIEW TO “USER”;
GRANT DBA TO “USER”;

导入数据库
imp user/9003@test full=y file=数据库备份文件路径 ignore=y;

备份数据库
exp user/9003@test owner=nguser file=‘D:\数据库备份文件路径.dmp’;