| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: RE: Urgent Select statement SOS
Boy have you got that right. If we're talking about a couple of hundred rows, most likely on one log file, then yeah logminer may help. But on the other hand if we're talking about a few thousand rows over a several log files!!!!!! Sheesh, what a pile of work that would be!!
Dick Goulet
____________________Reply Separator____________________ Author: "Yadav; Shailesh" <NDASY3_at_labor.state.ny.us> Date: 7/19/2001 9:44 AM
Dick,
I guess i didn't understand the question right. I think you are right and before digging into the logminer it has to be seen how long a period of inserts are we talking about.
Shailesh
-----Original Message-----
Sent: Thursday, July 19, 2001 9:18 AM
To: Yadav; Shailesh; Multiple recipients of list ORACLE-L
That is dependent on their being a date of last posting or similar column in
the
table. If not then it depends. Assuming the table is inserted into ONLY
and
there have been NO deletes, then a simple 'select * from <table_name>' will
extract the data in the order that it was most likely inserted, though that
is
NOT guaranteed. If on the other hand there have been any deletes against
the
table, your totally stuck. There is no data that I know of in the data
dictionary that records when a row was inserted into a table. Possibly, but
again no guarantee, logminer may be of assistance, if you've got the right
version of Oracle.
Dick Goulet
____________________Reply Separator____________________ Author: "Yadav; Shailesh" <NDASY3_at_labor.state.ny.us> Date: 7/19/2001 5:56 AM
Sinardy,
Try something like this...
INSERT INTO table_name (SELECT column_name FROM (SELECT column_name FROM table_name ORDER BY time))
HTH
Shailesh
-----Original Message-----
Sent: Thursday, July 19, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Do you guys know how to
select column
order by time of insert into table.
Thank you,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: sinardyxing_at_bcsis.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jul 19 2001 - 09:08:17 CDT
 |
 |