StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4609188
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-01-05T21:07:07.793
FavoriteCount
0
LastActivityDate
2012-09-14T12:32:54.033
LastEditDate
2012-09-14T12:32:54.033
LastEditorUserId
1266303
OwnerUserId
564583
ParentId
2191780
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>Here is a sample of something I came up with for creating partitions using <code>SYSDATE</code> and an offset. I had to create replacement parameters with a string concatenated to the <code>SYSDATE</code>:</p> <pre><code>COLUMN temp_var new_value partition_name_01; SELECT 'TABLE_NAME_' || TO_CHAR(SYSDATE - 3, 'YYYYMMDD') AS temp_var FROM dual; COLUMN temp_var new_value partition_date_01; SELECT TO_CHAR(SYSDATE - 3, 'SYYYY-MM-DD') || ' 00:00:00' AS temp_var FROM dual; COLUMN temp_var new_value partition_name_02; SELECT 'TABLE_NAME_' || TO_CHAR(SYSDATE - 2, 'YYYYMMDD') AS temp_var FROM dual; COLUMN temp_var new_value partition_date_02; SELECT TO_CHAR(SYSDATE - 2, 'SYYYY-MM-DD') || ' 00:00:00' AS temp_var FROM dual; COLUMN temp_var new_value partition_name_03; SELECT 'TABLE_NAME_' || TO_CHAR(SYSDATE - 1, 'YYYYMMDD') AS temp_var FROM dual; COLUMN temp_var new_value partition_date_03; SELECT TO_CHAR(SYSDATE - 1, 'SYYYY-MM-DD') || ' 00:00:00' AS temp_var FROM dual; COLUMN temp_var new_value partition_name_04; SELECT 'TABLE_NAME_' || TO_CHAR(SYSDATE, 'YYYYMMDD') AS temp_var FROM dual; COLUMN temp_var new_value partition_date_04; SELECT TO_CHAR(SYSDATE, 'SYYYY-MM-DD') || ' 00:00:00' AS temp_var FROM dual; CREATE TABLE TABLE_NAME ( SEQ_NO NUMBER NOT NULL, INSERT_DATE DATE NOT NULL, FIRST_NAME VARCHAR2 (256 BYTE), LAST_NAME VARCHAR2 (256 BYTE), ID_NUM NUMBER, ID_STATUS NUMBER ) PARTITION BY RANGE (INSERT_DATE) SUBPARTITION BY LIST (ID_STATUS) SUBPARTITION TEMPLATE ( SUBPARTITION SP1 VALUES (0) TABLESPACE &tblspce, SUBPARTITION SP2 VALUES (1) TABLESPACE &tblspce, SUBPARTITION SP3 VALUES (2) TABLESPACE &tblspce) ( PARTITION &partition_name_01 VALUES LESS THAN (TO_DATE ('&partition_date_01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), PARTITION &partition_name_02 VALUES LESS THAN (TO_DATE ('&partition_date_02', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), PARTITION &partition_name_03 VALUES LESS THAN (TO_DATE ('&partition_date_03', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), sysdate PARTITION &partition_name_04 VALUES LESS THAN (TO_DATE ('&partition_date_04', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))) ENABLE ROW MOVEMENT; </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODynamic table partitioning in Oracle
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSicco
UserOwnerUserId
1. USJohn Fuller
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.