OraFAQ Forum: Server Administration » Attempt To Increase a Tablespace throws error ORA-01516

Home » RDBMS Server » Server Administration » Attempt To Increase a Tablespace throws error ORA-01516 (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Attempt To Increase a Tablespace throws error ORA-01516 [message #690071]

Thu, 03 October 2024 07:15

wtolentino
Messages: 415
Registered: March 2005

Senior Member

I attempt to increase a tablespace datafile size on SQL*Plus with this command:

alter database datafile '+DATA0001/prodDB/datafile/prd.dbf.00001' autoextend on next 1000m maxsize 3690204m;

and I get this error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA0001/prodDB/datafile/prd.dbf.00001" in the current container

Note: not the actual datafilename.

However it works when I use a tool like DBartisan or SQLdeveloper on the same database. I think I had to include some additional command to get into the current container. Please advise.

Thank you.

Report message to a moderator