The new PL/SQL procedure REDEF_TABLE in Oracle 12c lets you redefine a table online in a single step. It can…
Tag table
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
— Make Table Read Only [sourcecode language=”sql”] alter table <table_name> read only; [/sourcecode] — Make Table Back to Read Write.…
Oracle allows the database to access a flat file as a table. You can have a flat file with a…
Query to find out size of the 10 Largest Tables sitting inside an Oracle database which is greater than 1GB…
Sometimes it is required to find the largest tables residing in your database. It helps to identify candidates for table…
SQL Query to check size of Table — Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in (‘TABLE1′,’TABLE2’);…
Do a “create table” as command without selecting any rows create table abc_new as select * from abc where 1=0;