This content has been marked as final. Show 2 replies
What I have noticed is sometimes single quotes count and sometime they don't.
SHOW DATABASE 'XXXPRD2';
So getting the case matters too.
Welcome to DGMGRL, type "help" for information. Connected. DGMGRL> show database standby Object "standby" was not found DGMGRL> show database 'standby'; Object "standby" was not found DGMGRL> show database 'STANDBY'; Database - STANDBY Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: (unknown) Apply Lag: Real Time Query: OFF Instance(s): STANDBY
DGMGRL> SHOW DATABASE STANDBY; Object "standby" was not found DGMGRL>
Edited by: mseberg on Jan 18, 2013 2:21 PM
You are genius. It does work.
Don't know why Oracle likes to create this kind of scary.
Thank you so much.