Timothy Shields
asked on
What is Minimum size for Temporary tablespaces or temp files.
I am getting an error message ORA-03214' when trying to create
a temporary table space. Is there a set minimum or is is based on database setup?
a temporary table space. Is there a set minimum or is is based on database setup?
ASKER
Before going on to the size again. Let me ask you this.
If I already have a Tablespace called Temp created when I created the database
would I need to create a new temporary tablespace for the users?
If I already have a Tablespace called Temp created when I created the database
would I need to create a new temporary tablespace for the users?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It is thanks.
For me the size of 2m works fines. is there any reason why you need to create temp ts of so small size...
SQL> create temporary tablespace temp00 tempfile '/tmp/temp00.001' size 2m;
This worked fine.