Link to home
Start Free TrialLog in
Avatar of walkerdba
walkerdba

asked on

view control file

I cannot see the controfile

.ctl is not viewable

It is not in readable format
The purpose is to run the controlfile script
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Oracle control files are binary.  You should NEVER try to edit one.

What are you trying to do?
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you use the above code, it's a pain to track down the correct trace file.

You can simplify it by providing the path.

For example in Unix:
ALTER DATABASE backup controlfile to trace '/tmp/myfile.txt';
Avatar of walkerdba

ASKER

yes