select * from user_users;
create tablespace ycm logging datafile 'D:\oracleData\ycm.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create temporary tablespace ycm_temp tempfile 'D:\oracleData\ycm_temp.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create user ycm identified by motorXMD312 default tablespace ycm temporary tablespace ycm_temp;
create tablespace ycm logging datafile 'D:\oracleData\ycm.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create temporary tablespace ycm_temp tempfile 'D:\oracleData\ycm_temp.dbf' size 50m autoextend on next 50m maxsize 1024m extent management local;
create user ycm identified by motorXMD312 default tablespace ycm temporary tablespace ycm_temp;
本文介绍了使用SQL语句从用户表中选择所有记录的方法,并详细展示了如何在Oracle数据库中创建表空间及临时表空间的过程。

2923

被折叠的 条评论
为什么被折叠?



