| 'Read-only' Tablespace [message #61690] |
Tue, 18 May 2004 04:57  |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
Hi,
Can someone please tell me which v$ view contains whether a tablespace is read-only or not. I have tried the usual ones but cannot find the information I require.
Regards,
Ken.
|
|
|
|
| Re: 'Read-only' Tablespace [message #61691 is a reply to message #61690] |
Tue, 18 May 2004 05:03  |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
Ignore. It is the v$datafile view - join it to the v$tablespace.
Another question. In the v$tablespace view there is a column called 'INCLUDED_IN_DATABASE_BACKUP' which has values of YES and NO. How do I configure this column so I can omit certain read-only tablepsaces from my backup?
TIA,
Ken.
|
|
|
|
| Re: 'Read-only' Tablespace [message #61692 is a reply to message #61691] |
Tue, 18 May 2004 05:37 |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
'INCLUDED_IN_DATABASE_BACKUP' - Indicates whether the tablespace is included in full database backups using the BACKUP DATABASE RMAN command (YES) or not (NO). NO only if the CONFIGURE EXCLUDE RMAN command was used for this tablespace.
Ignore the above questions chaps. Have to find another way of doing it.
Ken
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
