SQL> create tablespace tbs_1 DATAFILE '/u03/oradata/tbs_01.dbf' size 5M;
Tablespace created.
SQL> alter tablespace tbs_1 add datafile '/u03/oradata/tbs_02.dbf' size 1G;
Tablespace altered.
SQL> > create user zyj identified by zyj default tablespace tbs_1;
SP2-0734: unknown command beginning "> create u..." - rest of line ignored.
SQL> create user zyj identified by zyj default tablespace tbs_1;
User created.
SQL> grant dba to zyj;
Grant succeeded.
SQL> select file_id,file_name from dba_data_files where tablespace_name='TBS_1';
FILE_ID FILE_NAME
---------- ------------------------------
19 /u03/oradata/tbs_01.dbf
20 /u03/oradata/tbs_02.dbf
SQL> select owner,segment_name from dba_Extents where file_id=19;
no rows selected
SQL> select owner,segment_name from dba_Extents where file_id=20;
no rows selected
SQL> conn zyj/zyj
Connected.
SQL> create table test as
alter database create datafile as
最新推荐文章于 2021-04-15 19:25:41 发布
本文演示了如何使用SQL命令在Oracle数据库中创建表空间、添加数据文件、创建用户并分配权限,以及如何处理数据文件的离线、删除和重新创建。特别地,展示了在数据文件损坏无备份但有归档日志时,如何利用`ALTER DATABASE CREATE DATAFILE`进行数据恢复。
摘要由CSDN通过智能技术生成