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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yadav, Shailesh
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
