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!

Cut down Table data

678298Jun 8 2011 — edited Jun 9 2011

Hi

I got one requirement to cut down one Table having 4 years worth of data. Requirement want to export only 6 month of data of same table to another database.

The problem with this table is that.. This table is not having any "date" column_name or Data_type.

Table structure is as ..

"CLICK_ID" NUMBER,
"MEMBER_ID" NUMBER,
"LINK_ID" NUMBER,
"CLICK_TIMESTAMP" NUMBER,
"REMOTE_HOST" VARCHAR2(255 CHAR),
"USER_AGENT" VARCHAR2(255 CHAR),
"FAMILY" NUMBER,
"AGENT" NUMBER,
"TYPE" NUMBER,
"COMBINED" NUMBER,
"BUILDMODE" NUMBER,

Please guide me how can I cutdown this table to only 6 months of data.

I am on Oracle 10g.

Let me know if you need more information.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2011

Added on Jun 8 2011

#general-database-discussions

4 comments

270 views