cmd에서 계정 생성 및 권한

12 버전

app admin oradata orcl 대충 이주소 순으로 찾아들어가서 dbf있는곳

CREATE TABLESPACE banana DATAFILE 'C:\app\admin\oradata\orcl\banana.dbf' SIZE 100M AUTOEXTEND ON NEXT 5M;

create user c##jwh identified by 1 default tablespace banana temporary tablespace temp;

grant dba, connect, resource to c##jwh;

Drop table banana;

purge recyclebin;

 

Create TABLE banana(

  id varchar(10),

  pw number,

  name varchar(10),

  age number

);

Drop table banana; purge recyclebin; Create TABLE banana( name varchar(10), age number, home varchar(10), salary number );