I am creating temporary/permanent tablespace on Oracle. As I am going to create an application that is transactional there will be traffic. I bumped into concept called tablespace in oracle. What kind practial things should I consider while creating tablespace? Should I create temporary table or should I use default temp tablespace? Are there any resource that I can study except theory?
I have though to create tablespace as:
CREATE TEMPORARY TABLESPACE OPTIMADATA_TEMP TEMPFILE '/opt/app/oracle/oradata/orcl/test01.dbf' SIZE 1024M reuse autoextend on, '/opt/app/oracle/oradata/orcl/test02.dbf' SIZE 1024M reuse autoextend on extent management local;
Do I create multiple files or Single file is sufficient?
CREATE TABLESPACE OPTIMADATA DATAFILE '/opt/app/oracle/oradata/orcl/test.dbf' size 2000M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL;
Do I always do Autoextend on ??