|
-
yes then we need to create a tablespace with larger size.
for this use: (if ur old temporay tablespace was locally managed tablespace) then follow
1. create temporary tablespace temp01
tempfile 'c:\temo1.tmp' size 100m
The extent management clause is optional for temporary tablespaces because all temporary tablespaces are created with locally managed extents of a uniform size
2. alter database default temporary tablespace temp01
3. Make old temporary tablespace offline or u can delete it.
~KD.DBA~
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
|