saltar al contenido principal
paste
bin
.ca
type · paste · share
⌘
K
Iniciar sesión
?
Cuenta
Más
▾
Docs
Familia
La familia bin
pastebin.ca
centro
Share text and code with expiry and privacy controls.
imagebin.ca
Upload and share images with direct links.
filebin.ca
Drop a file and get a shareable link.
notebin.ca
Write Markdown notes with durable links.
turl.ca
Short, reputation-checked links.
attn.ca
Notifications and alerts for your services.
voicebin.ca
Record and share short voice clips.
dnsbin.ca
Inspect DNS and debug records.
← volver a la publicación
›
Editar / bifurcar
Publicación sin título
#5aBSm5Atr6
public / public
nueva versión
anónimo
creado 5 days ago
Caduca en 2 days
7.8 KB
sintaxis:
text
Tus cambios crean una nueva publicación enlazada a esta — la original no se toca.
nueva versión
Tus cambios crean una nueva publicación enlazada a esta — la original no se toca.
Título (opcional)
Nombre de archivo
Sintaxis
text
text
bash
c
cpp
css
diff
dockerfile
go
html
ini
java
javascript
json
kotlin
lua
makefile
markdown
nginx
php
python
ruby
rust
shellscript
sql
swift
toml
typescript
xml
yaml
Visibilidad
Feed público
Acceso
public
Caduca
7 días
10 min
1 hora
1 día
7 días
30 días
90 días
personalizada…
Caducidad personalizada
Nota de cambio
(opcional)
Cualquiera puede encontrar esta publicación en el feed público. Elige Sin listar para compartirla solo por enlace.
Crear nueva versión
Cancelar
Pegar o escribir…
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 -------------------------------- --------- ------------------------------ ANONYMOUS LOCKED 04-NOV-25 SYSAUX APPQOSSYS LOCKED 04-NOV-25 SYSAUX AUDSYS LOCKED 04-NOV-25 SYSAUX USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ BAASSYS LOCKED 04-NOV-25 SYSAUX CTXSYS LOCKED 04-NOV-25 SYSAUX DBSFWUSER LOCKED 04-NOV-25 SYSAUX USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ DBSNMP LOCKED 04-NOV-25 SYSAUX DGPDB_INT LOCKED 04-NOV-25 USERS DIP LOCKED 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ DVF LOCKED 04-NOV-25 SYSAUX DVSYS LOCKED 04-NOV-25 SYSAUX GGSHAREDCAP LOCKED 04-NOV-25 SYSAUX USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ GGSYS LOCKED 04-NOV-25 SYSAUX GSMADMIN_INTERNAL LOCKED 04-NOV-25 SYSAUX GSMCATUSER LOCKED 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ GSMUSER LOCKED 04-NOV-25 USERS LBACSYS LOCKED 04-NOV-25 SYSTEM MDDATA LOCKED 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ MDSYS LOCKED 04-NOV-25 SYSAUX OJVMSYS LOCKED 04-NOV-25 USERS OLAPSYS LOCKED 04-NOV-25 SYSAUX USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ OUTLN LOCKED 04-NOV-25 SYSTEM PDBADMIN OPEN 17-NOV-26 USERS REMOTE_SCHEDULER_AGENT LOCKED 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ SYS OPEN 04-NOV-25 SYSTEM SYS$UMF LOCKED 04-NOV-25 USERS SYSBACKUP LOCKED 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ SYSDG LOCKED 04-NOV-25 USERS SYSKM LOCKED 04-NOV-25 USERS SYSRAC OPEN 04-NOV-25 USERS USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ SYSTEM OPEN 04-NOV-25 SYSTEM TUTELAR OPEN 17-NOV-26 USERS VECSYS LOCKED 04-NOV-25 SYSAUX USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ WMSYS LOCKED 04-NOV-25 SYSAUX XDB LOCKED 04-NOV-25 SYSAUX XS$NULL LOCKED 04-NOV-25 SYSTEM 36 rows selected. SQL> SELECT USERNAME, ACCOUNT_STATUS, CREATED, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME ='TUTELAR'; USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS CREATED DEFAULT_TABLESPACE -------------------------------- --------- ------------------------------ TUTELAR OPEN 17-NOV-26 USERS SQL> 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 -------------------------------- --------- ------------------------------ TUTELAR OPEN 17-NOV-26 USERS SQL> 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 selected SQL> 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.^C C:\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 2026 Version 23.26.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. ERROR: ORA-12262: Cannot connect to database. Could not resolve hostname 123@localhost in Easy Connect connection string 123@localhost:1521/FREEPDB1 Help: https://docs.oracle.com/error-help/db/ora-12262/ SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus Help: https://docs.oracle.com/error-help/db/sp2-0751/ C:\Users\itadmin>