EXP-00068 tablespace TEMP is offline



create another temp tablespace

CREATE TEMPORARY TABLESPACE TEMP1  TEMP FILE '/UNDO/TEMP01_A.DBF' SIZE 1024M;

make it defualt

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp1;

drop old temp tablespace

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;


Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post