如何创建Oracle数据库的表空间和用户啊?

2024-12-31 21:06:26
推荐回答(1个)
回答1:

如何创建Oracle数据库的表空间和用户啊?
创建表空间(带参数):
CREATE Tablespace zfmi logging datafile 'D:oracleoradatazfmizfmi.dbf'
size 100m
autoextend on next 32m
maxsize 2048m extent
management local;

创建临时表空间(带参数):
CREATE Temporary tablespace zfmi_temp tempfile 'D:oracleoradatazfmizfmi_temp.dbf'
size 100m
autoextend on next 32m
maxsize 2048m extent
management local;