Home » SQL & PL/SQL » SQL & PL/SQL » Where did it go
Where did it go [message #195845] Mon, 02 October 2006 15:10 Go to next message
wilsonml1
Messages: 1
Registered: October 2006
Junior Member

Used SQLPlus on for this statement
SQL> alter database backup controlfile to trace;

This is suppose to create a text file backup of the control file. Where does it write it out to?

Thanks!
Re: Where did it go [message #195880 is a reply to message #195845] Mon, 02 October 2006 20:58 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
not sure, check your udump parameter.
Re: Where did it go [message #196041 is a reply to message #195845] Tue, 03 October 2006 15:46 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member

1 select value from v$parameter
2* where name = 'user_dump_dest'


VALUE
-----------------------------------------
?/trc/

Where the ? means Oracle_home
Previous Topic: Why do I need a Declare for this?
Next Topic: missing right parenthesis
Goto Forum:
  


Current Time: Sun Dec 11 02:30:03 CST 2016

Total time taken to generate the page: 0.26900 seconds