Home » RDBMS Server » Server Administration » Missing of data (oracle apps 11.5.10 ,erp type:opm)
Missing of data [message #308349] Mon, 24 March 2008 01:59 Go to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Dear mates,

We had a problem in our clone,some of our data related to formula details are missing.in the clone instance.what all are may be the reasons for missing of data.we are unable to query in som particular forms also.kindly help me out

regds
vizith
Re: Missing of data [message #308356 is a reply to message #308349] Mon, 24 March 2008 02:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

If you had data in it previously then someone has deleted it.
Re: Missing of data [message #308358 is a reply to message #308356] Mon, 24 March 2008 02:20 Go to previous messageGo to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Dear sir,

Is there any way to trace.and recover the data.

regds
vizith
Re: Missing of data [message #308362 is a reply to message #308349] Mon, 24 March 2008 02:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Insert the data that are missing.
Re: Missing of data [message #308363 is a reply to message #308362] Mon, 24 March 2008 02:32 Go to previous messageGo to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Can we check wat was last date tht ddl executed on tht table is there any way to trace wat happend actually
Re: Missing of data [message #308371 is a reply to message #308349] Mon, 24 March 2008 02:54 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Audit on or
Logminer minimum level on

dba_objects>last_ddl_time

Previous Topic: How to upgrade oracle10g R1 in solaris 5.9 x86?
Next Topic: Datafile Size
Goto Forum:
  


Current Time: Mon Dec 02 03:57:58 CST 2024