I cannot list tablespaces or any further query under this database and I am unsure how I can fix this to export the schema and import it on Standard Edition (Oralce SE)
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Try running below command before running queries:
ALTER SESSION SET CONTAINER = YOURPDB12C;
Nicholas Seetaram
Hi Vinish, yes this is changing the session to utilize the Pluggable database, in this case, XEPDB1. However, that doesn't help the situation.
Vinish Kapoor
Google for ora-12954; the first 3 articles should be helpful for you.