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
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?

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
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: 1648
Registered: December 2004
Senior Member

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


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

Current Time: Thu Jul 20 15:47:07 CDT 2017

Total time taken to generate the page: 0.24799 seconds