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-01549: tablespace not empty, use INCLUDING CONTENTS option

1 Answers  


TNS-03501: OK

1 Answers  


TNS-04010: Command cannot be issued before the ADMINISTER command.

1 Answers  


IMP-00067: Could not convert to server character set's handle

1 Answers  


NCR-04010: NCRR: Unable to contact Oracle Names Server

1 Answers  






LSX-00010: extra element(s) at end of "~S"

1 Answers  


ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)

1 Answers  


ORA-09969: scurls: unable to close lock file

1 Answers  


RMAN-06290: Report of database schema

1 Answers  


ORA-14615: List value 'string' specified twice in subpartitions 'string', 'string'

1 Answers  


ORA-00363: log is not the archived version

1 Answers  


ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition

1 Answers  


Categories