1. 安装oracle后,要用netbeans链接,需要下载jdbc驱动。
2. 创建一个用户后,需要授权,不然登录失败:
CREATE USER test IDENTIFIED BY passwd ;
grant create session to test;
创建表空间:
CREATE TABLESPACE snyj_data
LOGGING
DATAFILE 'D:\oracle\oradata\orcl\snyj_data01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
//alter database default tablespace snyj_data;
alter user snyj default tablespace users;
//alter user snyj quota 50M on users;
select username, default_tablespace defspace from dba_users where username='snyj';
/××
create temporary tablespace temp_1 tempfile 'E:\temp_1.dbf' size 20M autoextend on;//在E盘创建20M的表空间
create tablespace ts_1 datafile 'E:\ts_1.dbf' size 20M autoextend on; create user user1 identified by 111111 default tablespace ts_1 temporary tablespace temp_1; grant dba to user1;
×/
3. 登录
conn test/passwd
4. 对用户授权创建表,才能创建表,创建表之前,还需要对用户指定表空间:
grant create table to test; //授权创建表
alter user test quota 15m on system; //在SYSTEM表空间中,给用户TEST分配15M的使用空间
grant unlimited tablespace to test;
create table exam2 (student_id int, paper_id int);//创建表
5. 自动增加字段
create sequence test1;
create or replace trigger test2 before insert on test
for each row
begin
select test1.nextval into :new.id from dual;
end;
insert into test(name)values('aaa');