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-32812: subscriber string does not exist

1 Answers  


RMAN-06170: no controlfile copy found with offline range recid string stamp string datafile string

1 Answers  


IMG-00512: multiple incompatible scaling parameters found

1 Answers  


PLS-00124: name of exception expected for first arg in exception_init pragma

1 Answers  


TNS-04022: %s parameter string set to string.

1 Answers  






ORA-17612: Failed to discover Oracle Disk Manager library, return value string

1 Answers  


TNS-12555: TNS:permission denied

2 Answers  


ORA-01241: an external cache has died

1 Answers  


ORA-16137: No terminal recovery is required

1 Answers  


PLS-00907: cannot load library unit string (referenced by string)

1 Answers  


ORA-29290: invalid offset specified for seek

1 Answers  


RMAN-11006: WARNING: test recovery results: string

1 Answers  


Categories