Database Administration (MOSC)

MOSC Banner

IMP Error

edited Mar 31, 2010 6:13PM in Database Administration (MOSC) 5 commentsAnswered ✓
 Hi,

Got this error message on Oracle 9i OS Window server 2003 when importing in to newly created table spaces.

IMP-00003: ORACLE error 1658 encountered

ORA-01658: unable to create INITIAL extent for segment in tablespace

 Below the script used to create tablespace.

ORA-01658: unable to create INITIAL extent for segment in tablespace

 Below the script used to create tablespace.

CREATE TABLESPACE "APP_DAT" DATAFILE

    'D:\ORACLE\ORADATA\GAL\APP_DAT01.DBF' SIZE 500M REUSE

    AUTOEXTEND

    ON NEXT  1024K MAXSIZE  5535M EXTENT MANAGEMENT LOCAL

    SEGMENT SPACE MANAGEMENT  AUTO;

Any help.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center