創(chuàng)建數(shù)據(jù)庫(kù)

CREATE TABLESPACE MyDataBase LOGGING DATAFILE 'D:\Oracle\database\MyDataBase.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL

創(chuàng)建數(shù)據(jù)庫(kù)臨時(shí)文件

create temporary TABLESPACE MyDataBase_temp tempfile 'D:\Oracle\database\MyDataBase_temp.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL

創(chuàng)建用戶與上述兩個(gè)文件形成映射關(guān)系

CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE MyDataBase TEMPORARY TABLESPACE MyDataBase_temp;

添加用戶權(quán)限

grant connect,resource,dba to username;
grant create session to username;

刪除數(shù)據(jù)庫(kù)

conn sys/dwh as sysdba;

drop tablespace MyDataBase including contents and datafiles;

drop tablespace MyDataBase_temp including contents and datafiles;

刪除用戶

drop user username cascade; //通過(guò)級(jí)聯(lián)的方式刪除數(shù)據(jù)

用ODBC鏈接

是datasource=ip+"/"+實(shí)例名