creation db 1
Enter user-name: sys as sysdba
Enter password:creation db 1
Enter user-name: sys as sysdba
Enter password:creation db 1
Enter user-name: sys as sysdba
Enter password:
SQL> SHOW con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> ALTER SESSION SET CONTAINER = pdborcl;
Session altered.
SQL> SHOW con_name;
CON_NAME
------------------------------
PDBORCL
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> CREATE USER OT IDENTIFIED BY Orcl1234;
User created.
SQL> GRANT CONNECT, RESOURCE, DBA TO OT;
Grant succeeded.
SQL> CONNECT ot@pdborcl
Enter password:
Connected.
SQL>@path_to_sql_file
SQL>@c:\dbsample\ot_schema.sql
SQL> SELECT table_name FROM user_tables ORDER BY table_name;
SQL>@c:\dbsample\ot_data.sql
SQL> SELECT COUNT(*) FROM contacts;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
