Today I have struggled a problem while importing a dump file to oracle 9.2.0.7 database. The problem was about "ORA-01658: unable to create INITIAL extent for segment in tablespace". I investigated the problem and find a solution...
One tablespace was created with following command:
"CREATE TABLESPACE DATA BLOCKSIZE 8192
DATAFILE '/data07/oradata/pd02/data01.dbf' SIZE 10000M
AUTOEXTEND ON NEXT 25000M MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ONLINE PERMANENT NOLOGGING SEGMENT
SPACE MANAGEMENT AUTO;"
So, when tablespace needs a storage, it will try to allocate 25000M. When it could not allocate(for instance no space in device), it will cause above error.
Workaround may be creating manually datafiles with smaller sizes such as:
"ALTER TABLESPACE DATA
ADD DATAFILE '/data07/oradata/pd02/data02.dbf'
SIZE 3000M AUTOEXTEND ON;"
One tablespace was created with following command:
"CREATE TABLESPACE DATA BLOCKSIZE 8192
DATAFILE '/data07/oradata/pd02/data01.dbf' SIZE 10000M
AUTOEXTEND ON NEXT 25000M MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ONLINE PERMANENT NOLOGGING SEGMENT
SPACE MANAGEMENT AUTO;"
So, when tablespace needs a storage, it will try to allocate 25000M. When it could not allocate(for instance no space in device), it will cause above error.
Workaround may be creating manually datafiles with smaller sizes such as:
"ALTER TABLESPACE DATA
ADD DATAFILE '/data07/oradata/pd02/data02.dbf'
SIZE 3000M AUTOEXTEND ON;"
No comments:
Post a Comment