Important Oracle Scripts for Database Administrators (Part-1)

In this artical i want to share some very useful scripts for Oracle Database Administrator.

Security Grants

grant select on 'TABLE NAME' to public with grant option;

select * from dba_tab_privs where TABLE_NAME = 'TABLE_NAME'

select * from dba_role_privs where granted_role = 'PORTMAN_TABLE'

Resizing A Data File

alter database datafile '/u04/oradata/wpk/temp01.dbf' resize 200m;

Show All Product Information

select * from product_component_version;


Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle

Create Tables in Oracle Database using TOAD