跳到主内容
paste
bin
.ca
type · paste · share
⌘
K
登录
?
账户
更多
▾
文档
系列
bin 系列
pastebin.ca
中心
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.
← 返回文本
›
编辑 / 分支
无标题文本
#5aBSm5Atr6
public / public
新版本
匿名
已创建 5 days ago
过期于 2 days
7.8 KB
语法:
text
你的更改会创建一个链接到此文本的新文本 — 原始文本不变。
新版本
你的更改会创建一个链接到此文本的新文本 — 原始文本不变。
标题(可选)
文件名
语法
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
可见性
公开动态
访问
public
过期
7 天
10 分钟
1 小时
1 天
7 天
30 天
90 天
自定义…
自定义过期
变更备注
(可选)
任何人都能在公开动态中找到此文本。选择“未列出”即可仅通过链接分享。
创建新版本
取消
粘贴或输入…
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>