½«Êý¾Ý¿âµÄSQL½Å±¾Îļþµ¼Èëµ½oracleÖÐ

#1. Ê×ÏÈÒÔ¹ÜÀíÔ±µÄÉí·ÝµÇ¼µ½oracleϵͳÖÐ
cmd;
sqlplus sys/sys as sysdba;
#2.´´½¨Óû§test,ÃÜÂëΪtest
create user test identified by test;
#3.´´½¨±í¿Õ¼ä,ÔÚDÅÌϽ¨Á¢50mµÄ±í¿Õ¼ädata_dbf
create tablespace ts_tablespace datefile 'D:\data_dbf' size 50m;
#4.ΪÓû§·ÖÅä±í¿Õ¼ä
alter user test default tablespace ts_tablespace to test;
#5.¸øÓû§ÊÚȨ
grant create session, create table, create view, unlimited tablespace to test;
#6.ÒÔtest/testµÇ¼
conn test/test;
#7.µ¼ÈëSQLÓï¾ä,µ¼Èë´´½¨ºÃµÄ±í
@D:\test.sql
#8.²éѯ±í½á¹¹
select * from tab;