Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard quite often from Exadata Sales rep "Drop the indexes on Exadata ; It is a magical unicorn and it will guarantee performance even without them" Well, 50 years of computer science begs to differ. This … Continue reading Drop those Indexes and see the Magical Unicorn of Exadata do it’s Magic !
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym. -- Create a Public Synonym for a Table -- CREATE OR REPLACE PUBLIC SYNONYM EASYNAME for EASYORADBA.TABLE00001 ; -- Drop a Public Synonym for a Table -- DROP PUBLIC SYNONYM EASYNAME ; -- … Continue reading Create or Drop Public Synonyms in Oracle
------------- Drop Database Manually Oracle --------------------- 1. First get the datafiles, control files and redo log files location Login to sqlplus as sysdba and execute below script : [sourcecode language="sql"] DECLARE TYPE string_arr IS TABLE OF VARCHAR2(1024); file_list string_arr; BEGIN SELECT t.file_path BULK COLLECT INTO file_list FROM (SELECT NAME file_path FROM V$DATAFILE UNION SELECT MEMBER … Continue reading Drop Database Manually Oracle