SELECT TABLEDEF(‘ACL’,‘USER_TEST’);
desc USER_TEST
select dbms_metadata.get_ddl(‘TABLE’,‘TABLE_NAME’,‘TABLE_OWNER’) from dual;
select dbms_metadata.get_ddl(‘INDEX’,‘INDEX_NAME’,‘INDEX_OWNER’) from dual;
select dbms_metadata.get_ddl(‘VIEW’,‘VIEW_NAME’,‘VIEW_OWNER’) from dual;
select dbms_metadata.get_ddl(‘PROCEDURE’,‘PROCEDURE_NAME’,‘PROCEDURE_OWNER’) from dual;
select dbms_metadata.get_ddl(‘FUNCTION’,‘FUNCTION_NAME’,‘FUNCTION_OWNER’) from dual;
导出库:
./dexp DGAXO/‘“test@123456”’@ip:5236 SCHEMAS=ACL_PROD FILE=ACL_PROD.dmp LOG=uc_prod.log DIRECTORY=/home/app/kingo/
导出表:
./dexp AC/‘“test@123456”’@ip:5236 TABLES=USER_TEST FILE=dgaxoa_prod.dmp LOG=uc_prod.log DIRECTORY=/home/app/kingo/
查看当前模式名:
SELECT SF_GET_SCHEMA_NAME_BY_ID(CURRENT_SCHID);
或
select sys_context(‘USERENV’,‘CURRENT_SCHEMA’);
修改当前模式名:
ALTER SESSIONS SET CURRENT_SCHEMA=模式名; 或者 set schema 模式名;
模式拥有的对象:
select from dba_objects where owner=‘模式名’;
表具体信息:
select from dba_tables where owner=‘X模式’;
列具体信息:
select * from dba_tab_columns where owner=‘XXX’ AND TABLE_NAME=‘XXX’;