Database Administration (MOSC)

MOSC Banner

import fails on pdb when invoking it using local user

I am importing data to a pdb using a local user, however when importing I get error pluggable database is in read only mode.

From root container it shows READ WRITE and even when set container I get open mode read write.

DB Version ; Version 23.26.3.0.0

However when connected as a local user :

09:44:21 > select name, open_mode, restricted from v$pdbs;

NAME                                               OPEN_MODE  RES
-------------------------------------------------- ---------- ---
HALA                                         READ ONLY  NO

Elapsed: 00:00:00.05
09:45:05

As sys user: 

 09:35:29 SELECT con_id, name, open_mode, restricted from v$pdbs;

   CON_ID NAME                                               OPEN_MODE  RES
---------- -------------------------------------------------- ---------- ---
        3 HALA                                            READ WRITE NO

Elapsed: 00:00:00.01

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center