Oracle数据库实验一(用户登陆以及数据库创建)

最新推荐文章于 2024-07-25 22:07:48 发布

请你打开电视看看

最新推荐文章于 2024-07-25 22:07:48 发布

阅读量278

点赞数

分类专栏： Oracle 文章标签： Oracle

本文链接：https://blog.csdn.net/qq_44407005/article/details/108795373

版权

Oracle 专栏收录该内容

4 篇文章 0 订阅

订阅专栏


SQL*Plus: Release 11.2.0.1.0 Production on 星期一 9月 21 17:11:36 2020

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

请输入用户名:  system@study
输入口令:

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> create tablespace orcltbsl_210 datafile 'D:\oracle\orcltbs1_210.dbf' size 8m;

表空间已创建。

SQL>  select file_name, tablespace_name, bytes/1024/1024 AS MB from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\USERS01.DBF
USERS                                   5

D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\UNDOTBS01.DBF
UNDOTBS1                               90

D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\SYSAUX01.DBF
SYSAUX                                510


FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\SYSTEM01.DBF
SYSTEM                                680

D:\ORACLE\ORCLTBS1_210.DBF
ORCLTBSL_210                            8


SQL> create tablespace userbs_210 datafile 'D:\oracle\userbs1_210.dbf' size 4m autoextend on next 1m maxsize unlimited,'D:\oracle\userbs2_210.dbf'size 8m autoextend on next 1m maxsize 100m;

表空间已创建。

SQL>  select file_name, tablespace_name, bytes/1024/1024 AS MB from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\USERS01.DBF
USERS                                   5

D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\UNDOTBS01.DBF
UNDOTBS1                               90

D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\SYSAUX01.DBF
SYSAUX                                510


FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\SYSTEM01.DBF
SYSTEM                                680

D:\ORACLE\ORCLTBS1_210.DBF
ORCLTBSL_210                            8

D:\ORACLE\USERBS1_210.DBF
USERBS_210                              4


FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\ORACLE\USERBS2_210.DBF
USERBS_210                              8


已选择7行。


SQL> create temporary tablespace temptbs_210 tempfile 'D:\oracle\temptbs_210.dbf' size 4m autoextend on next 1m maxsize unlimited extent management local uniform size 512K;

表空间已创建。

SQL>  select file_name, tablespace_name, bytes/1024/1024 AS MB from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                        MB
------------------------------ ----------
D:\CHORME_DOWNLOAD\ORACAL11G\APP\LIANG\ORADATA\STUDY\TEMP01.DBF
TEMP                                   29

D:\ORACLE\TEMPTBS_210.DBF
TEMPTBS_210                             4