[Oracle] 常用的Oracle doc命令(收藏)

net start oracleservicebinbo

lsnrctl start

net stop oracleservicebinbo

lsnrctl stop

SQL>select * from user_role_privs;

SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;

SQL>select username,default_tablespace from user_users;

conn as sysdba
sys
tsinghua
sqlplus “sys/tsinghua as sysdba”
conn sys/zl as sysdba

sql>create tablespace test datafile ‘d:\oracle\binbo.dbf' size 10m;

sql>create user 用户名 identified by 用户名;

sql>show user

show error

sql>alter user 用户名 account lock

sql>alter user 用户名 account unlock

sql>drop user zl;

sql>grant create table to 用户名;

sql>grant dba to 用户名;

sql>grant connect to 用户名

sql>grant unlinmited tablespace to 用户名;

sql>revoke dba from 用户名;

SQL>select * from user_tables;

SQL>select object_name,object_id from user_objects
where instr(object_name,'LOG')>0;

SQL>select object_name,created from user_objects where object_name=upper(‘&table_name');

SQL>select sum(bytes)/(1024*1024) as “size(M)” from user_segments
where segment_name=upper(‘&table_name');

SQL>select table_name,cache from user_tables where instr(cache,'Y')>0;

sql>alter tablespace test add datafile ‘d:\oracle\test1.dbf' size 10m;