oracle常用命令

//创建临时表空间 create temporary tablespace caoqikai_temp
tempfile 'F:\oracle\oracledata\caoqikai_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建表空间 create tablespace caoqikai logging
datafile 'F:\oracle\oracledata\caoqikai.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定表空间 create user caoqikai identified by caoqikai
default tablespace caoqikai
temporary tablespace caoqikai_temp; //授权 grant connect,resource,dba,sysdba to caoqikai;
//导入数据 imp caoqikai/caoqikai@10.0.51.227/orcl file=F:\caxb.dmp FULL=Y ignore=y

show parameter instance_name

创建连接 conn / as sysdba; 进入系统用户 sqlplus / as sysdba

转载于:https://my.oschina.net/kaiqi/blog/701844