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-03002: operator not implemented

1 Answers  


RMAN-06214: %-15s string

1 Answers  


ORA-12554: TNS:current operation is still in progress

1 Answers  


TNS-03511: Used parameter files: string

1 Answers  


PLS-00171: duplicate dedicated AGENT specification in subprogram expression

1 Answers  






ORA-02822: Invalid block offset

1 Answers  


ORA-28553: pass-through SQL: invalid bind-variable position

1 Answers  


NNC-00424: invalid address "string"

1 Answers  


ORA-27411: An empty string is not a valid repeat interval.

1 Answers  


ORA-22861: invalid user-defined type

1 Answers  


RMAN-06210: List of Mismatched objects

1 Answers  


ORA-06319: IPA: Remote maximum number of users exceeded

1 Answers  


Categories