Oracle???????????
???????????? ???????[ 2015/5/25 11:38:22 ] ?????????????
--Oracle?????????????
create tablespace new_taspace
--??????
DATAFILE 'D:NEWTABLESPACE.DBF' --??????????????????λ??
size 200M --????????С
autoextend on next 20MB MAXSIZE 400MB; --?????С????????????????20MB????400MB
--????????
create tablespace new_taspace1
--??????????????????λ??
DATAFILE 'D:NEWTABLESPACE1.DBF'
--????????С
SIZE 200M
--??????
Logging
extent management local
segment space management auto; --???????
--?????????????????????
drop tablespace new_taspace including contents and datafiles
--???????
create user orders
identified by 123456
default tablespace new_taspace; --???????????????
--???????????
grant connect??resource to orders
grant dba from orders
--???????????????
revoke dba from orders
--??????????????
grant select on tep to orders
--????????
create table book(
id number(11) primary key??
bookname varchar2(50) not null??
price number(11??2) not null??
storage number(11) not null
)
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11