Table Partitioning Schemes-Partitioning

There are currently nine methods by which you can partition tables in Oracle: •\ Range partitioning: You may specify ranges of data that should be stored together. For example, everything that has a timestamp within the month of Jan-2014 will be stored in partition 1, everything with a timestamp within Feb-2014 in partition 2, and
Read more

SecureFiles RETENTION-Datatypes

SecureFiles use RETENTION to control read consistency (just like BasicFiles). In the CREATE TABLE output of DBMS_METADATA for the SecureFiles LOB, there is no RETENTION clause. This is because the default RETENTION is set to AUTO, which instructs Oracle to retain undo long enough for read-consistent purposes. If you want to alter the default RETENTION
Read more

Internal LOBs-Datatypes

Starting with Oracle Database 11g, Oracle introduced a new underlying architecture for LOBs known as SecureFiles. The prior existing LOB architecture is known as BasicFiles. By default in 11g, when you create a LOB, it will be created as a BasicFiles LOB. Starting with Oracle 12c, when creating a LOB column in an ASSM-managed tablespace,
Read more

LOB Tablespace-Datatypes

The CREATE TABLE statement returned from DBMS_METADATA for both the SecureFiles and BasicFiles included the following:LOB (“TXT”) STORE AS … ( TABLESPACE “USERS” … The TABLESPACE specified here is the tablespace where the LOBSEGMENT and LOBINDEX will be stored, and this may be different from the tablespace where the table itself resides. That is, the
Read more

Range Partitioning-Partitioning

The first type we will look at is a range partitioned table. The following CREATE TABLE statement creates a range partitioned table using the column RANGE_KEY_COLUMN. All data with a RANGE_KEY_COLUMN strictly less than 01-JAN-2021 will be placed into the partition PART_1, and all data with a value strictly less than 01-JAN-2022 (and greater than
Read more
Copyright All right reserved
BACK TO TOP