-
alter tablespace temp begin backup;
Dear all,
Can't we copy the temp tablespace data file as a hotbackup mode?
SQL> alter tablespace temp begin backup;
alter tablespace temp begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
SQL>
I belive, it was working in oracle8i. Please help me why this is not working..
-
-
-
how about undo or rollback tablespaces? do we need to back it up too?
TEMP and UNDO are the two TS with large runaway size allocation in our
database.
-
UNDO/ROLLBACK definitely yes.
Jeff Hunter
-
oh my...do we need to shrink the undo to make the file smaller to backup?
-
eh? just backup whatever you have
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|