passer au contenu principal
paste
bin
.ca
type · paste · share
⌘
K
Se connecter
?
Compte
Plus
▾
Docs
Famille
La famille bin
pastebin.ca
pôle
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.
← retour au collage
›
Modifier / dupliquer
Collage sans titre
#5aBSm5Atr6
public / public
nouvelle version
anonyme
créé 5 days ago
Expire dans 2 days
7.8 KB
syntaxe:
text
Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.
nouvelle version
Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.
Titre (facultatif)
Nom de fichier
Syntaxe
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
Visibilité
Fil public
Accès
public
Expire
7 jours
10 min
1 heure
1 jour
7 jours
30 jours
90 jours
personnalisé…
Expiration personnalisée
Note de changement
(facultatif)
Tout le monde peut trouver ce collage dans le fil public. Choisissez Non répertorié pour le partager uniquement par lien.
Créer une nouvelle version
Annuler
Collez ou tapez…
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>