Some of the doc. says that I do not need to recreate the control file/or copy/remove the physical file to the Standby database, if I create/drop a new tablespace on the Primary...
...but in other places, it says that I do need to take some manual steps in the Standby database !
This is part of 9i Doc:
"You need to refresh the standby database control file whenever you:
-Rename a datafile
-Delete a datafile
-Create a temporary tablespace
-Drop a tablespace..."
So, in my testing, I was successfully able to create/drop tablespaces on Primary without doing anything on the Standby...and walah...the datafiles are created/removed on the Standby.
Since the Doc. talks about taking many manual steps on Standby, but does not mention that it needs to be done only if
STANDBY_FILE_MANAGEMENT is not set to AUTO, I thought I should run it past some gurus.