Home / Questions / 525748
Accepted
Wiska
Asked: 2022-09-03 23:47:11 +0800 CST 2022-09-03 23:47:11 +0800 CST

No tablespace: ORA-32771: cannot add file to bigfile tablespace

  • 772

Apparently I just ran out of space in my tablespace and I don't know how to increase its size, I tried the following command:

ALTER TABLESPACE SANDRA ADD DATAFILE '/u01/oradata/userdata03.dbf' SIZE 3000M;

and I get:

ORA-32771: cannot add file to bigfile tablespace

I don't know what else to try. If someone could tell me what to do I would appreciate it.

plsql

1 Answers

  1. Best Answer

    What I did to solve this problem was to go to the DBA option , open the TABLESPACE, click on the Edit option and then in Edit Tablespace assign a new size, in my case 2G, in addition to activating the automatic extension.

    • 0