| 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: Import date
Unfortunately last_ddl_time doesn't seem to be updated by doing an import.
This was on Metalink... Any other ideas how I can see the last date an
import was done????
"Unfortunatly, development does not document what statements effect the LAST_DDL_TIME, in testing, I found that truncate and analyze do not change the value of this column. You are right, create/alter index rebuild does make the change. Grant/revoke and any alter table which changes the structure (such as adding a column) changes it. However, I noticed that an 'alter table' which just changes storage parameters does not."
>From: Suzy Vordos <lvordos_at_datsit.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Import date
>Date: Wed, 08 Nov 2000 11:10:31 -0800
>
>
>Look at last_ddl_time in dba_objects.
>
>Fred Smith wrote:
> >
> > Hi,
> > I am wondering if anyone knows how to find out the date of the last
>import
> > into my 8.1.5 database? A user was dropped and re-imported and I need
>to
> > know when this occurred.
> >
> > Thanks,
> > -FS
> >
> > (I am Windows NT SP6)
> >
>_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Fred Smith
> > INET: fred_fred_1_at_hotmail.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Suzy Vordos
> INET: lvordos_at_datsit.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).
Share information about yourself, create your own public profile at Received on Wed Nov 08 2000 - 15:00:28 CST
 |
 |