Oracle Tips

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