Tag: DBA blog

Oracle Java SE Critical Patch Released

Posted on by Osama Mustafa in News
“The June 2013 Oracle Java SE Critical Patch Update was released on June 18, 2013. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, a summary of the security vulnerabilities, and a pointer to obtain the latest releases and patches.”

June 2013 Oracle Java SE Critical Patch Update: Here

The next four scheduled dates for Oracle Java SE Critical Patch Updates are:
16 April 2013
18 June 2013
15 October 2013
14 January 2014

Thank you
Osama mustafa

DBMS_METADATA

Posted on by Osama Mustafa in Database
The DBMS_METADATA package provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object.

TableSpace

select dbms_metadata.get_ddl(‘TABLESPACE’,tablespace_name) from dba_tablespaces;

Get All Tablespace Script :

set head off echo off
select ‘select dbms_metadata.get_ddl(”TABLESPACE”,”’
  ||  tablespace_name || ”’) from dual;’ from dba_tablespaces


Table

 select dbms_metadata.get_ddl(‘TABLE’,’DEPT’,’SCOTT’) from dual;

User

SELECT dbms_metadata.get_ddl(‘USER’,’SCOTT’) FROM dual;

Role

SELECT DBMS_METADATA.GET_GRANTED_DDL(‘ROLE_GRANT’,’SCOTT’) from dual;
 SELECT DBMS_METADATA.GET_GRANTED_DDL(‘OBJECT_GRANT’,’SCOTT’) from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL(‘SYSTEM_GRANT’,’SCOTT’) from dual;
SELECT dbms_metadata.get_ddl(‘ROLE’,’RESOURCE’) from dual;

This is the Most common Usage for this package more information read Oracle Documentation
 
Thank you
Osama mustafa