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)
- Attempt To Increase a Tablespace throws error ORA-01516 [message #690071] Thu, 03 October 2024 07:15 Go to next message
wtolentino
Messages: 422
Registered: March 2005
Senior Member
I attempt to increase a tablespace datafile size on SQL*Plus with this command:
Code: [Select all] [Show/ hide]
alter database datafile '+DATA0001/prodDB/datafile/prd.dbf.00001' autoextend on next 1000m maxsize 3690204m;

and I get this error:
Code: [Select all] [Show/ hide]
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

- Re: Attempt To Increase a Tablespace throws error ORA-01516 [message #690072 is a reply to message #690071] Thu, 03 October 2024 07:55 Go to previous message
John Watson
Messages: 8974
Registered: January 2010
Location: Global Village
Senior Member
You do need to be connected to the container in which the datafile exists.

Report message to a moderator

Previous Topic: How to fix XDB
Next Topic: How to find server process/scripts thats locking an account
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 10 18:44:54 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.