--创建用户( 用户名his_user,密码his)
create user his_user identified by his;
--用户授权
grant connect, resource, dba to his_user;
--查询所有用户
select * from all_users;
--查看所有表
select * from all_tables;
--创建同义词(同义词HISTABLE)
CREATE OR REPLACE PUBLIC SYNONYM HISTABLE FOR HIS_USER.HISTABLE;
--授权
grant all on HISTABLE to HIS_USER;
--创建DBLink
create public database link dblink名称 connect to 连接用户名 identified by 连接用户名密码 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )';
--取第一行记录
SELECT * FROM (SELECT * FROM 表名) T WHERE rownum = 1;
--生成32位的唯一编码
SELECT SYS_GUID() FROM DUAL;
--打印
DBMS_OUTPUT.put_line('123');
--以收缩表段的方式 清理表空间
alert table table_name enable row movement; alert table table_name shrink space;
--重建索引(将所有状态为无效的索引进行重建)
select index_name from all_indexes where table_name = 'table_name' and status <> ‘valid’; 使用游标遍历index_name,执行 alert index index_name rebuild;
--修改表名
ALTER TABLE 原表名 RENAME 新表名;