Oracle Tips
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
]
開始行:
*Oracle Tips [#cde14293]
#contents
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 || ' ' || UNIQUEN...
select TABLE_NAME, INDEX_NAME, column_name from user_ind...
select TABLE_NAME || ' ' || INDEX_NAME || ' ' || column_...
select username from user_users;
select * from NLS_DATABASE_PARAMETERS where PARAMETER = ...
exp "<username>/<password> file=exp01.dmp tables=(JOB, T...
imp "<username>/<password> file=exp01.dmp tables=(JOB, T...
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_kby...
to_char(t.bytes_cached / dt.bytes * 100, '990.00') || '...
FROM sys.dba_temp_files dt, v$temp_extent_pool t, v$temp...
WHERE t.file_id(+)= dt.file_id AND dt.file_id = v.file#;
終了行:
*Oracle Tips [#cde14293]
#contents
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 || ' ' || UNIQUEN...
select TABLE_NAME, INDEX_NAME, column_name from user_ind...
select TABLE_NAME || ' ' || INDEX_NAME || ' ' || column_...
select username from user_users;
select * from NLS_DATABASE_PARAMETERS where PARAMETER = ...
exp "<username>/<password> file=exp01.dmp tables=(JOB, T...
imp "<username>/<password> file=exp01.dmp tables=(JOB, T...
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_kby...
to_char(t.bytes_cached / dt.bytes * 100, '990.00') || '...
FROM sys.dba_temp_files dt, v$temp_extent_pool t, v$temp...
WHERE t.file_id(+)= dt.file_id AND dt.file_id = v.file#;
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
