Recovery of Temporary tablespaces
From: Bilal Nabi <bilal_at_stglabs.8m.com>
Date: 25 Jan 2002 20:54:12 -0800
Message-ID: <7b4a461a.0201252054.6dd79bb0_at_posting.google.com>
Date: 25 Jan 2002 20:54:12 -0800
Message-ID: <7b4a461a.0201252054.6dd79bb0_at_posting.google.com>
You really dont have to worry much about the recovery of temporary
tablespaces. You can drop the old temporary tablespace and make a new
one. After that give the command :
Alter user user_name default tablespace def_tablespace_name
temporary tablespace temp_tablespace_name; after you connect as DBA.
This is the recommended method. Received on Sat Jan 26 2002 - 05:54:12 CET