oracle create tablespace

发布时间：2020-12-12 13:45:54 所属栏目：百科来源：网络整理

导读：ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; ? sqlplus shybt/ [email?protected] :1521/orcl ? Create user test identified by 12345678 ? create tablespace SIRM2 datafile ‘D:oracleproduct10.2.0oradataorclSIRM2.dbf‘ size 1

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

sqlplus shybt/[email?protected]:1521/orcl

Create user test identified by 12345678

create tablespace SIRM2
datafile ‘D:oracleproduct10.2.0oradataorclSIRM2.dbf‘ size 1024M --存储地址初始大小1G

ALTER TABLESPACE AAAAA
ADD DATAFILE ‘D:/ora/datafile/users.ora‘ SIZE 500M
AUTOEXTEND ON
NEXT 50M
MAXSIZE 2000M;

alter database datafile ‘/u01/app/oracle/oradata/orcl/sec_d01.dbf‘ autoextend on;

create tablespace sq01 datafile ‘d:sq01.bdf‘ size 5m ; --创建表空间alter database datafile ‘d:sq01.bdf‘ autoextend on next 20m maxsize 100m;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!