Create a tablespace in Oracle

1--Create temporary tablespace
2 Create TemporaryTablespace data_temp
3Tempfile'D: \ Oracle \ oraudata \ data_temp.dbf'
4Size 2000 m
5AutoextendOn
6 Next500 m
7Extent management local;
8
9 --Create a data package Space
10 CreateTablespace data_data
11Logging
12Datafile'D: \ oracle \ oraudata \ data_data.dbf'
13Size 2000 m
14AutoextendOn
15 Next500 m
16Extent management local;
17
18
19 --Create a user and specify a tablespace
20
21 Create UserDbadmin identifiedByDbpass
22 DefaultTablespace data_data
23 TemporaryTablespace data_temp;
24
25 --Delete USER commands
26 --Drop user dbadmin cascade
27
28 --Grant permissions to users
29 GrantConnect, resourceToDbadmin
30
31 --Withdrawal
32 --Revoke connect, resource from dbadmin