GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery

 Print  |  
Question:  Table Export

Answer: How we you identify if a table was exported in its life time?


March 03, 2009 05:21:56 #1
 rajesh_rd   Member Since: March 2009    Total Comments: 2 

RE: Table Export
 

Refer cumulative or an incremental backup (export )
we have a parameter (RECORD) & the default parameter is yes & is to track the incremental backup of a table 
so those backup (export) information will get update in the following sys tables
SYS.INCEXP, SYS.INCFIL,SYS.INCVID

desc SYS.INCVID
 EXPID

desc SYS.INCEXP
 OWNER#
 NAME
 TYPE#
 CTIME
 ITIME
 EXPID


desc SYS.INCFIL

EXPID
EXPTYPE
EXPFILE
EXPDATE
EXPUSER


i have not checked any thing after an export from these tables try it out and let others also know about this


Regards

Rajesh RD

     

 

Back To Question