select table_name from user_tables order by table_name;
desc <表名>;
select index_name from user_indexes order by index_name;
select TABLE_NAME || ' ' || index_name || ' ' || UNIQUENESS from user_indexes order by index_name;
select TABLE_NAME, INDEX_NAME, column_name from user_ind_columns where TABLE_NAME='<表名>';
select TABLE_NAME || ' ' || INDEX_NAME || ' ' || column_name from user_ind_columns order by TABLE_NAME, INDEX_NAME, column_name;
select username from user_users;
select * from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_NCHAR_CHARACTERSET';
exp "<username>/<password> file=exp01.dmp tables=(JOB, TOKUIDB, TOUR_JOHO)"
imp "<username>/<password> file=exp01.dmp tables=(JOB, TOKUIDB, TOUR_JOHO)"
SET SERVEROUTPUT ON SIZE 1000000;
set serveroutput on;
declare
cursor cu is select
from user_tab_columns
order by table_name, column_id;
begin
for cu_rec in cu loop
dbms_output.put_line(
);
end loop;
dbms_output.put_line ('===========================================================================');
end;
/
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
