Oracle [ Size by Partitions ] How do I know if an object is partitioned or not?
SELECT * FROM dba_tab_partitions WHERE table_name = '<table_name>';
SELECT * FROM dba_in…Read More
Oracle Rman Show Backups
select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
ro…Read More
ORACLE / RMAN - Statusset pages 120
set lines 120
column MEDIA format a10
column STATUS format a10
column OPERACAO format a10
select operation as "OPERACAO",
object_type a…Read More
0 comentários:
Post a Comment