Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

order table by time, no date column

user12952237Aug 24 2015 — edited Aug 26 2015

hello,

i have a table in oracle 11.2 without date column.

the table size is about 350Gb, it contains blob data.

the table has no primary key, no foreign key. only one unique index.

all columns are update by application, there is no sequence.

is there any way to sort rows by time, because i want to delete older data.


SQL> describe owner.table_name

Name     Type         Nullable Default Comments

-------- ------------ -------- ------- --------

CLMN1    VARCHAR2(9)           '000'           

CLMN2    VARCHAR2(6)           ' '             

CLMN3    VARCHAR2(96)          ' '             

CLMN4    NUMBER(10)            0               

CLMN5    VARCHAR2(30)          ' '             

CLMN6    NUMBER(5)             0               

CLMN7    BLOB         Y         

         

BR Flag
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2015
Added on Aug 24 2015
#general-database-discussions, #order, #time
17 comments
2,108 views