Oracle Tips

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;
/

SELECT dt.file_name, dt.tablespace_name,
 to_char(dt.bytes / 1024, '99999990.000') file_kbytes,
 to_char(t.bytes_cached / 1024, '99999990.000') used_kbytes,
 to_char(t.bytes_cached / dt.bytes * 100, '990.00') || '%' capacity
FROM sys.dba_temp_files dt, v$temp_extent_pool t, v$tempfile v 
WHERE t.file_id(+)= dt.file_id AND dt.file_id = v.file#;


トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: Tue, 12 Oct 2021 01:05:22 JST (421d)