数据库 1. 创建临时表空间 create temporary tablespace sacadataviz_temp tempfile 'sacadataviz_datafile01.dbf' size 100m autoextend on next 100m maxsize 4096M extent management local; 2. 创建数据表空间 create tablespace sacadataviz datafile 'sacadataviz_datafile02.dbf' size 100M autoextend on next 100M maxsize 4096M extent management local; 3.创建用户并制定临时表空间和默认表空间 create user sacadataviz identified by sacadataviz default tablespace sacadataviz temporary tablespace sacadataviz_temp; 4.给用户授予权限 grant resource,connect,dba to sacadataviz; grant select any table,execute any procedure,create any procedure,create any snapshot,on commit refresh,create any table to sacadataviz;