Oracle常用命令

--进入到sqlplus
sqlplus / as sysdba

--连接到数据库
conn /as sysdba

--启动数据库实例
startup

--关闭数据库实例                                     
shutdown immediate                                          

-- 查看dbf存放位置
SQL>select name from v$datafile;

-- 新建表空间
SQL>create tablespace jixiaoDB logging datafile '/u01/jixiao/datafile/jixiao.dbf' size 100m autoextend on next 
50m maxsize 200m extent management local;

-- 新建用户
SQL>create user jixiao identified by jixiao default tablespace jixiaoDB;

-- 用户授权
SQL>grant create session to jixiao;
    grant create any table to jixiao;
    grant connect,resource,jixiaoDB to jixiao;
    grant create view to jixiao;

--退出
SQL>Quit

--查看数据库
ps -ef | grep ora

--启动监听器
lsnrctl start

--停止监听器
lsnrctl stop