Hi lists,
I am trying to put my tablespace into read only mode(This is to take the
transport tablespace export). When i typed
alter tablespace xyz read only;
it is just getting hung. Even after an hour the command is not being
executed.
There are no users accessing the objects in that
When read only tablespaces first came out, the database had to have no
transactions on it before you could to alter a tablespace to read only...
In recent releases, Oracle has improved this significantly... But, that
does not mean it is clean... If you issue a 'alter tablespace XXX read
only',