Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TEMPFILE creation Error

499760Jan 27 2008 — edited Jan 27 2008
Dear Friends,

I have some doubts as follows.

If repeatedly some one uses the following wrong code to add space to temp tablespace.
what is going to happen?like , can it corrupt the tempfile?

ALTER TABLESPACE "TEMP" ADD DATAFILE '<filepath>/<tempfilename>' SIZE 10G


Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2008
Added on Jan 27 2008
#general-database-discussions
6 comments
875 views