Oracle RENAME Statement
RENAME Syntax For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as: RENAME old_name TO new_name; There're only… Read More »Oracle RENAME Statement
Table
How to Resolve ORA-02030: can only select from fixed tables/views
ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… Read More »How to Resolve ORA-02030: can only select from fixed tables/views
Segments vs Schema Objects
Segments vs Schema Objects Not only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions… Read More »Segments vs Schema Objects