Home » RDBMS Server » Backup & Recovery » export and import
export and import [message #165510] Thu, 30 March 2006 13:45 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
Is there a way, where I can look and say, when was last export done on this database or import done on this database.

Thanks
Toshi
Re: export and import [message #165565 is a reply to message #165510] Thu, 30 March 2006 23:08 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
There is no log in the database. But you can check the exp/imp logs if they are exists.

Alex zeng |Skype me: hans9zeng
Re: export and import [message #165598 is a reply to message #165565] Fri, 31 March 2006 00:52 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
if you are running through cron, you can find it in systemwide log file.otherwise there is noway to find, exp is just a selection process done by some external utility

Thanks
Madhu
Re: export and import [message #165659 is a reply to message #165510] Fri, 31 March 2006 05:23 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi,

If you are doing incremental exports then you can see the last time.


Select * from dba_exp_files;


Rgds
SALIH KM
Cool
Re: export and import [message #165883 is a reply to message #165510] Mon, 03 April 2006 03:27 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
You can check the date on the dat.emp file.

I put a date in the script that runs the emp.
Solaris:
dmpdate.txt < date
then check dmpdate.txt
Previous Topic: problem on starting database
Next Topic: Tablespaces in a different location
Goto Forum:
  


Current Time: Sun Nov 24 10:36:20 CST 2024