Orcal数据库的开始创建

 

 

sqlplus /@course as sysdba;

show con_name;

 show pdbs;

sqlplus /@orcl as sysdba;中有可插入数据库

 

 

 alter session set container=orclpdb;

create user scott identified by tiger;

grant connect,resource,unlimited tablespace to scott;

 alter user scott default tablespace users;

alter user scott temporary tablespace temp;

 

sqlplus scott/tiger@localhost:1521/orclpdb

 

 

 

 

 

 

posted @ 2023-11-20 16:56  孙欣然  阅读(16)  评论(0)    收藏  举报