-
Notifications
You must be signed in to change notification settings - Fork 3
/
creating_new_schema.txt
65 lines (53 loc) · 1.53 KB
/
creating_new_schema.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<<<<<<< HEAD
>>> RUN SQL PLUS:
USERNAME : SYSTEM
PASSWORD: *****
>>> RUN FOLLOWING COMMANDS:
CREATE TABLESPACE INNOCITY_TABSPACE
DATAFILE 'innocity_tabspace.dat'
SIZE 10M AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE INNOCITY_TABSPACE_TEMP
TEMPFILE 'innocity_tabspace_temp.dat'
SIZE 5M AUTOEXTEND ON;
>> CREATE NEW USER:
CREATE USER INNOCITY
IDENTIFIED BY 2108
DEFAULT TABLESPACE INNOCITY_TABSPACE
TEMPORARY TABLESPACE INNOCITY_TABPACE_TEMP;
>> GRANT PRIVILEGES TO USER:
GRANT CONNECT,RESOURCE,DBA TO INNOCITY;
GRANT CREATE SESSION TO INNOCITY;
GRANT CREATE TABLE TO INNOCITY;
GRANT UNLIMITED TABLESPACE TO INNOCITY;
>> START NAVICAT
>> CREATE NEW ORACLE CONNECTION ( USERNAME: INNOCITY PASSWORD:2108)
>> GO TO THE INNOCITY SCHEMA
>> CREATE TABLES
>> DONE!
=======
>>> RUN SQL PLUS:
USERNAME : SYSTEM
PASSWORD: *****
>>> RUN FOLLOWING COMMANDS:
CREATE TABLESPACE INNOCITY_TABSPACE
DATAFILE 'innocity_tabspace.dat'
SIZE 10M AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE INNOCITY_TABSPACE_TEMP
TEMPFILE 'innocity_tabspace_temp.dat'
SIZE 5M AUTOEXTEND ON;
>> CREATE NEW USER:
CREATE USER INNOCITY
IDENTIFIED BY 2108
DEFAULT TABLESPACE INNOCITY_TABSPACE
TEMPORARY TABLESPACE INNOCITY_TABPACE_TEMP;
>> GRANT PRIVILEGES TO USER:
GRANT CONNECT,RESOURCE,DBA TO INNOCITY;
GRANT CREATE SESSION TO INNOCITY;
GRANT CREATE TABLE TO INNOCITY;
GRANT UNLIMITED TABLESPACE TO INNOCITY;
>> START NAVICAT
>> CREATE NEW ORACLE CONNECTION ( USERNAME: INNOCITY PASSWORD:2108)
>> GO TO THE INNOCITY SCHEMA
>> CREATE TABLES
>> DONE!
>>>>>>> 85c0794067bd5d7ca08872e606aa75c3bb8e4d2a