| why should i offline the tablespace? [message #538678] |
Sun, 08 January 2012 21:49  |
 |
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
|
Member |
|
|
Hi ,all:
when i restore the tablespace ,why should i offline the tablespace first?if i restore the tablespace without offlining,what will happen?
|
|
|
|
|
|
| Re: why should i offline the tablespace? [message #538694 is a reply to message #538678] |
Mon, 09 January 2012 01:32  |
 |
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:why should i offline the tablespace first?
This is juts a prerequisite Oracle asks, no need to think about it:
Database Backup and Recovery Reference
RESTORE page
Restrictions and Usage Notes section:
Quote:To restore datafiles to their current location, the database must be started, mounted, or open with the tablespaces or datafiles to be restored offline.
Quote:if i restore the tablespace without offlining,what will happen?
Just try it!
Regards
Michel
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
