SQL> conn c##scott/tiger;
Connected.
SQL> show user;
USER is « C##SCOTT »
SQL> @oracle.sql
Building demonstration tables. Please wait.
Demonstration table build is complete.
1 – Créer un utilisateur scott :
create user c##scott IDENTIFIED by tiger;
grant dba to c##scott;
grant connect to c##scott;
2- Télécharger oracle.zip
3- Se connecter au schéma c##scott et lancer oracle.sql
SQL> conn c##scott/tiger;
Connected.
SQL> show user;
USER is « C##SCOTT »
SQL> @oracle.sql
Building demonstration tables. Please wait.
Demonstration table build is complete.
1 – Créer un utilisateur scott :
Josselin Joly