1.0.6.0 - Production on Sun Sep 16 13:01:11 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Real Application Clusters, OLAP,
Data Mining and Real Application Testing options
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------- --- --- --- ---
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
5 UNDOTBS2 YES NO YES
Chapter 16: Managing Large Databases 597
7 UNDOTBS3 YES NO YES
9 RMAN YES NO YES
11 XPORT_DW YES NO YES
10 rows selected.
SQL> alter tablespace xport_dw read write;
Tablespace altered.
SQL>
Note that you must change the tablespace from READ ONLY back to READ WRITE; when a
tablespace is transported to another database, by default the copy of the tablespace is online but
read-only. You also need to change the source tablespace back to READ WRITE after the
completion of the tablespace transport if you made it read-only during a non-RMAN tablespace
transport operation.
This page intentionally left blank
CHAPTER
17
Managing Distributed
Databases
599
600 Oracle Database 11g DBA Handbook
n a distributed environment, databases on separate servers (hosts) may be accessed
during a single transaction or query. Each server can be physically isolated without
being logically isolated from the other servers.
Pages:
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880