| Backup of Tablespaces [message #319102] |
Fri, 09 May 2008 01:32  |
myana.srinivas1
Messages: 8
Registered: April 2008
Location: India |
Junior Member |
|
|
Hi all,
I have 50 tablespaces in my database.
Now, i am planning to take backup of all these tablespaces using a single statement(not using scripts).
I wanna know if that is possible.. if yes, please let me know
|
|
|
| Re: Backup of Tablespaces [message #319108 is a reply to message #319102 ] |
Fri, 09 May 2008 01:46  |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
It is not possible.
By the way, a single statement IS a script as soon as you put it in a file.
Regards
Michel
|
|
|
|
| Re: Backup of Tablespaces [message #319273 is a reply to message #319102 ] |
Fri, 09 May 2008 09:44 |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Actually it is possible to say:
backup tablespace 'tbs1','tbs2','tbs3'...;
Regards
Michel
|
|
|
| Re: Backup of Tablespaces [message #319279 is a reply to message #319273 ] |
Fri, 09 May 2008 10:04 |
 |
ebrian
Messages: 2016
Registered: April 2006 |
Senior Member |
|
|
|
Sure, but why ? Just a rhetorical question, these crazy requirements are impossible to comprehend.
|
|
|
]
Members
Search
Help
Register
Login
Home
