Public feed #5aBSm5Atr6

text paste

public text v1 · immutable
Raw Edit
·published 2026-11-17 13:00 UTC
rendered paste body
SQL> ALTER SESSION SET CONTAINER = FREEPDB1;Session altered.SQL> SHOW USER;USER is "SYS"SQL> SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS ORDER BY USERNAME;USERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------ANONYMOUSLOCKED                           04-NOV-25 SYSAUXAPPQOSSYSLOCKED                           04-NOV-25 SYSAUXAUDSYSLOCKED                           04-NOV-25 SYSAUXUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------BAASSYSLOCKED                           04-NOV-25 SYSAUXCTXSYSLOCKED                           04-NOV-25 SYSAUXDBSFWUSERLOCKED                           04-NOV-25 SYSAUXUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------DBSNMPLOCKED                           04-NOV-25 SYSAUXDGPDB_INTLOCKED                           04-NOV-25 USERSDIPLOCKED                           04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------DVFLOCKED                           04-NOV-25 SYSAUXDVSYSLOCKED                           04-NOV-25 SYSAUXGGSHAREDCAPLOCKED                           04-NOV-25 SYSAUXUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------GGSYSLOCKED                           04-NOV-25 SYSAUXGSMADMIN_INTERNALLOCKED                           04-NOV-25 SYSAUXGSMCATUSERLOCKED                           04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------GSMUSERLOCKED                           04-NOV-25 USERSLBACSYSLOCKED                           04-NOV-25 SYSTEMMDDATALOCKED                           04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------MDSYSLOCKED                           04-NOV-25 SYSAUXOJVMSYSLOCKED                           04-NOV-25 USERSOLAPSYSLOCKED                           04-NOV-25 SYSAUXUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------OUTLNLOCKED                           04-NOV-25 SYSTEMPDBADMINOPEN                             17-NOV-26 USERSREMOTE_SCHEDULER_AGENTLOCKED                           04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------SYSOPEN                             04-NOV-25 SYSTEMSYS$UMFLOCKED                           04-NOV-25 USERSSYSBACKUPLOCKED                           04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------SYSDGLOCKED                           04-NOV-25 USERSSYSKMLOCKED                           04-NOV-25 USERSSYSRACOPEN                             04-NOV-25 USERSUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------SYSTEMOPEN                             04-NOV-25 SYSTEMTUTELAROPEN                             17-NOV-26 USERSVECSYSLOCKED                           04-NOV-25 SYSAUXUSERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------WMSYSLOCKED                           04-NOV-25 SYSAUXXDBLOCKED                           04-NOV-25 SYSAUXXS$NULLLOCKED                           04-NOV-25 SYSTEM36 rows selected.SQL> SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME ='TUTELAR';USERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------TUTELAROPEN                             17-NOV-26 USERSSQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVILEGE  2  SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME ='TUTELAR';SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME ='TUTELAR'*ERROR at line 2:ORA-03048: SQL reserved word 'SELECT' is not syntactically valid following'...FROM DBA_SYS_PRIVILEGE'Help: https://docs.oracle.com/error-help/db/ora-03048/SQL> SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME ='TUTELAR';USERNAME--------------------------------------------------------------------------------ACCOUNT_STATUS                   CREATED   DEFAULT_TABLESPACE-------------------------------- --------- ------------------------------TUTELAROPEN                             17-NOV-26 USERSSQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='TUTELAR' ORDER BY PRIVILEGE  2  SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='TUTELAR' ORDER BY PRIVILEGE;SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='TUTELAR' ORDER BY PRIVILEGE*ERROR at line 2:ORA-03048: SQL reserved word 'SELECT' is not syntactically valid following'...='TUTELAR' ORDER BY PRIVILEGE'Help: https://docs.oracle.com/error-help/db/ora-03048/SQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='TUTELAR' ORDER BY PRIVILEGE;no rows selectedSQL> sqlplus -L "TUTELAR/tutelar@123@localhost:1521/FREEPDB1" "@C:\Users\itadmin\Downloads\lea-oracle-app\db_schema\lea.sql"SP2-0734: unknown command beginning "sqlplus -L..." - rest of line ignored.Help: https://docs.oracle.com/error-help/db/sp2-0734/SQL> SP2-0042: unknown command "s" - rest of line ignored.Help: https://docs.oracle.com/error-help/db/sp2-0042/SQL> SP2-0042: unknown command "s" - rest of line ignored.^CC:\Users\itadmin>C:\Users\itadmin>C:\Users\itadmin>sqlplus -L "TUTELAR/tutelar@123@localhost:1521/FREEPDB1" "@C:\Users\itadmin\Downloads\lea-oracle-app\db_schema\lea.sql"SQL*Plus: Release 23.26.0.0.0 - Production on Tue Nov 17 18:29:40 2026Version 23.26.0.0.0Copyright (c) 1982, 2025, Oracle.  All rights reserved.ERROR:ORA-12262: Cannot connect to database. Could not resolve hostname 123@localhostin Easy Connect connection string 123@localhost:1521/FREEPDB1Help: https://docs.oracle.com/error-help/db/ora-12262/SP2-0751: Unable to connect to Oracle.  Exiting SQL*PlusHelp: https://docs.oracle.com/error-help/db/sp2-0751/C:\Users\itadmin>