These may the global temporary tables
(check column TEMPORARY in dba_tables)
created by dbms_stats to generate histograms
for the underlying tables, and not cleaned up
properly
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st
"Roger Jackson" <rjackson1_at_hotkey.net.au> wrote in message
news:94614c11.0406200533.1a15024e_at_posting.google.com...
> Hi,
>
> I have noticed the following tables in our data dictionary.
>
> OWNER TABLE_NAME
> ------------------------------ ------------------------------
> SYS ORA_TEMP_1_DS_18925
> SYS ORA_TEMP_1_DS_20007
> SYS ORA_TEMP_1_DS_35301
>
> These are copies of application tables in our database.
> These tables do not contain any rows...
>
> Does anybody know what the purpose of these tables are and why they are
created?
>
> We are currently running Oracle 9.2.0.5 on HP-UX 11.11
>
> Thanks in advance for any suggestions.
>
> Regards,
>
> Roger.
Received on Sun Jun 20 2004 - 09:59:13 CDT
