Showing posts with label Tables. Show all posts
Showing posts with label Tables. Show all posts
Wednesday, August 31, 2022

Rename table in postgreSQL: syntax

›
Rename a table: alter table myschema.mytable rename to mytable_old; Change ownership for a table: alter table myschema.mytable owner to ...
Tuesday, November 12, 2019

How to convert a non-partitioned table into a partitioned table in Oracle version 12.2 and onwards

›
With Oracle 12.2 and higher versions, it is really simple to convert a non-partitioned table to a partitioned table: you can now use the ...
Thursday, February 16, 2017

How to create a global temporary table

›
An example of a Global Temporary Table (GTT) would be: CREATE GLOBAL TEMPORARY TABLE INCOMING_DATA ( ROW_ID NUMBER(...
Monday, August 24, 2015

What does the DEFAULT DEGREE on tables actually mean?

›
The DOP (degree of parallelism) settings on a table has to do with the number of threads per instance for scanning the table (an integer), o...
Wednesday, February 12, 2014

ORA-39726: unsupported add/drop column operation on compressed tables when attempting to drop column on a (previously) compressed table

›
My customer had a partitioned table that was previously compressed with FOR ALL OPERATIONS options. One of the developers wanted to drop a ...
Tuesday, January 28, 2014

How to set a column to UNUSED

›
Setting a column to UNUSED can be a solution when you cannot or should not attempt to drop a column due to performance reasons. Syntax: ...
Friday, November 29, 2013

How to create a sequence and a trigger that will emulate "autonumber" in other RDBMS systems

›
If you have been working with other RDBMS systems, such as SQL Server from Microsoft, you may be used to a datatype called AUTONUMBER, which...
Wednesday, November 27, 2013

How does the 11gR2 feature "deferred segment creation" work?

›
Starting from 11gR2 onwards, Oracle introduced a feature called deferred segment creation . This means that Oracle will not need to create a...
Monday, November 18, 2013

How to use the APPEND hint to optimize INSERT statements

›
When using the APPEND hint, you are telling the optimizer to use direct-path INSERT. Serialized inserts: Simply specify the APPEND hint ...
2 comments:
Tuesday, October 22, 2013

How to make a table read only (11g only)

›
ALTER TABLE table_name READ ONLY; The command would make the table read-only even for its owner. To reverse the operation: ALTER TABLE...