ORA-32772: BIGFILE is invalid option for this type of tablespace



ORA-32772: BIGFILE is invalid option for this type of tablespace..

Answer / guest

Cause: An attempt was made to create a bigfile tablespace
that is dictionary managed or locally managed with manual
segment-space management.

Action: Either change the tablespace type to locally managed
with automatic segment-space management, or create a
SMALLFILE tablespace instead.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12404: invalid privilege string: string

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


ORA-32339: cannot alter materialized view with the PMOP

1 Answers  


RMAN-06017: initialization of parser failed

1 Answers  


TNS-00013: INTCTL: error while performing NS disconnect command

1 Answers  






ORA-13002: specified level is out of range

1 Answers  


ORA-16552: An error occurred when generating the CLIENT OPERATION table.

1 Answers  


VID-00702: unable to initialize video processing environment

1 Answers  


ORA-15050: disk "string" contains string error(s)

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


ORA-24098: invalid value string for string

1 Answers  


LPX-00005: ~1s buffer overflow, maximum size is ~2u bytes

1 Answers  


Categories