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:\oracle\product\10.2.0\oradata\orcl\SIRM2.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;