| khubeb |
Posted: Jul 11, 2008 07:29:57 AM |
Total Post: 112
Joined: Apr, 2007
|
WHAT IS DIFF B/W :
SQL>ALTER DATABASE BACKUP CONTROL FILE;
AND
SQL>ALTER DATABASE BACKUP CONTROL FILE TO TRACE;
|
|
|
 Avnish |
| Posted: Jul 11, 2008 08:02:56 AM |  |
|
Total Post: 154
Joined: Dec, 2007
|
Hi
SQL>ALTER DATABASE BACKUP CONTROL FILE;
Answer : This statement is use for backing up an Control file.
SQL>ALTER DATABASE BACKUP CONTROL FILE TO TRACE;
Answer : This statement generates a new SQL script that may be used to re-create the controlfile.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Mohammed Taj |
| Posted: Jul 12, 2008 10:03:43 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
first one create BINARY controlfile
second one create ASCII TEXT controlfile.
|
|
|
|
|
| positive |
| Posted: Jul 13, 2008 01:05:38 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
