Тёмный

SQL Developer New Connection to Oracle Express 

Stephen Frein
Подписаться 729
Просмотров 2,7 тыс.
50% 1

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@justaguy168
@justaguy168 2 года назад
This was a great video! It really helped fill in the missing pieces for getting started with SQL Developer. Two hints: SQL Developer seems to get confused when you ask it to create lowercase usernames. It worked better for me when I created an upper case username. Also, I found it easier to create the user in SQLPlus session. Here are my commands: CREATE USER "JOEDATA" IDENTIFIED BY "mypasswd" DEFAULT TABLESPACE "USERS"; ALTER USER "JOEDATA" QUOTA UNLIMITED ON "USERS"; GRANT "DBA" TO "JOEDATA"; COMMIT; Hope this helps.
@luisbarros
@luisbarros 4 года назад
I have this error: ORA-65096: invalid common user or role name in oracle when creating a user
@stephenfrein
@stephenfrein 4 года назад
From Oracle 12c onward, you need new “magic words” to create a user. Run this - alter session set "_ORACLE_SCRIPT"=true; - then create your user.
@luisbarros
@luisbarros 4 года назад
@@stephenfrein Thanks Stephen, in a sqlplus session or how I do it in sql dev?
Далее
How to Use VS Code to Run SQL on a Database
15:06
Просмотров 288 тыс.
Part 5. Roblox trend☠️
00:13
Просмотров 2,7 млн
Query Tuning with tkprof
14:57
Просмотров 59 тыс.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
DBeaver Tutorial - How to Use DBeaver (SQL Editor)
15:50