set heading off;
set echo off;
Set pages 999;
set long 90000;
spool ddl_list.sql
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;
select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;
spool off;
dbms_metadata
Random Posts
Blog Archive
ORACLE DBA
Search This Blog
Blog Archive
-
▼
2011
(101)
-
▼
July
(79)
- oracle RAC Commands
- 10g ORACLE
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- To monitor job progress[RMAN]
- systemstate and hang analyse
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- UNIX raw filesystem commands for dba
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- ENQUEUE LOCK:
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- The Archiver hung alerts
- How to register database with RMAN recovery catalog
- Thirupal_Boreddy_oracle_DBA: Procedure to relocate...
- dbms_metadata
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- set date format
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- Static Parameter
- HSMP cluster commands:
- HSMP cluster commands:
- systemstate and hang analyse
- OMS Commands
- Thirupal_Boreddy_oracle_DBA: OMS Commands
- crs commands
- crs commands
- crs commands
- Process for clearing down archivelogs via Rman
- Thiru: Process for clearing down archivelogs via Rman
- Converting to archive log mode in RAC
- Thiru: Converting to archive log mode in RAC
- Steps for VIP Relocation
- Thiru: Converting to archive log mode in RAC
- Add space in RAC DB TABLESPACES:
- Thiru: Process for clearing down archivelogs via Rman
- Chang Archive log destination
- Thiru: Chang Archive log destination
- Manual Archive Backup
- Thiru: Manual Archive Backup
- Thiru: To monitor job progress[RMAN]
- Thiru: Thirupal_Boreddy_oracle_DBA: ENQUEUE LOCK:
- Thiru: Chang Archive log destination
- RMAN Checks
- Thiru: RMAN Checks
- ASM – basic things to look for
- Thiru: RMAN Checks
- Killing a Hanging CRSD Daemon;
- Thiru: ASM – basic things to look for
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Thiru: Useful CRS Commands
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Operating System Commands
- Thiru: Useful CRS Commands
- Tracing a SQL session
- Check cluster name
- The Archiver hung alerts
- Log file locations in RAC
- Thiru: Tracing a SQL session
- System state dump and Hanganalyze
- Thiru: The Archiver hung alerts
- RAC - Healthchecking the Startup of Oracle for a g...
- Thiru: Log file locations in RAC
- RAC - Stopping everything Oracle-related for a giv...
- Thiru: Procedure to relocate services in RAC nodes
- Enabling Archive Logs in a RAC Environment
- Adding a new vote disk
- Thiru: Enabling Archive Logs in a RAC Environment
- Export of table Partition
- Flashback setup in RAC
- Voting Disk
- Post database creation CRS Health check
- RAC Troubleshooting
- Change the parameters for RAC database
- Compressed Export and Import
- Adding the space to tablespace
- Change db_recovery_file_dest_size
- Restarting SSH broker in the event of a hang
- Thiru: Thirupal_Boreddy_oracle_DBA: oracle RAC Com...
-
▼
July
(79)
Thirupal Boreddy. Powered by Blogger.
My Blog List
Followers
Lorem 1
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Lorem 4
Tagged with: dbms_metadata
About Oracle DBA World
WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
Subscribe to:
Post Comments (Atom)
QUERY FOR CPU USAGE
select a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...
No comments