Oracle establishes tablespaces and users

To establish the tablespace and the user's steps:

2. User
4. Create:Create user username identified by "password";
6. Authorization:Grant create session to user name;
8. Grant create table to user name;
10. Grant create tablespace to user name;
12. Grant Create view to user name;

Steps to establish a tablespace and User: User creation: Create user username identified by "password"; authorization: Grant create session to username;            Grant CREATE table to  user name;            Grant create tablespace to  user name;            Grant CREATE view to  user name;

 

2. establishes a tablespace (typically a table space and an index space of n stored data):   
3. create tablespace  table space name   
4. datafile < Span class= "string" >   path (to build the path first) \***.dbf   '  size *m  
5. tempfile  '   Path \***.dbf  '  size *m  
6. autoextend on   --auto-grow   
7. --there are also some commands to define the size, see the need for   
8.  default storage (  
9.  initial  100k,  
10.  NEXT&NBSP;100K,&NBSP;&NBSP;

Tablespace establishes table space (typically a table space with n stored data and an index space): Create tablespace tablespace name datafile ' path (to build the path first) \***.dbf  ' size *mtempfile ' path \***.dbf ' Size *mautoextend  on-auto-grow-there are also some defined-size commands to see the default storage (initial 100K, next 100k,);

 

1. Example: creating a table space
2. Create Tablespace Demospace
3. DataFile ' e:/oracle_tablespaces/demospace_tbspace.dbf '
4. Size 1500M
5. Autoextend on next 5M maxsize 3000M;
6. Delete Table space
7. Drop tablespace demospace including contents and datafiles

Example: Creating table spaces Create tablespace demospace datafile ' e:/oracle_tablespaces/demospace_tbspace.dbf ' size 1500M autoextend on Next 5M maxsize 3000M; Delete table space drop tablespace demospace including contents and datafiles

1. User Rights
2. To grant a user permission to use the tablespace:
3. Alter user username quota Unlimited on table space;
4. or alter user username quota *m on table space;

User Rights grant users permission to use tablespace: Alter user username quota unlimited on table space, or alter user username quota *m on table space;

Complete Example:

2. --Table space
4. CREATE tablespace SDT
6. DataFile ' F:\tablespace\demo ' size 800M
8. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
10. --Index Table space
12. CREATE tablespace Sdt_index
14. DataFile ' F:\tablespace\demo ' size 512M
16. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
20. --2. Build Users
22. Create User demo identified by demo
24. Default Tablespace demo;
28. --3. Empowering
30. Grant Connect,resource to demo;
32. Grant create any sequence to demo;
34. Grant create any table to demo;
36. Grant Delete any table to demo;
38. Grant insert any table to demo;
40. Grant select any table to demo;
42. Grant Unlimited tablespace to demo;
44. Grant execute any procedure to demo;
46. Grant update any table to demo;
48. Grant Create any view to demo;

--Table space Create tablespace sdtdatafile ' F:\tablespace\demo ' size 800M         EXTENT MANAGEMENT LOCAL SEGMENT space MANAGEMENT AU to; --Index tablespace create tablespace sdt_indexdatafile ' F:\tablespace\demo ' size 512M                  EXTENT MANAGEMENT LOCAL SEGMENT Space MANAGEMENT AUTO;     --2. Create user demo identified by demo default Tablespace demo; --3. Empowering Grant Connect,resource to demo;grant create any sequence to demo;grant create any table to demo;grant delete any tab Le to demo;grant Insert no table to demo;grant Select any table to Demo;grant unlimited tablespace to Demo;grant execute Any procedure to demo;grant update any table to demo;grant create any view to demo;

 

1. --Import and export commands
2. IP Export mode: Exp demo/[email protected]:1521/orcl file=f:/f.dmp full=y
3. Exp Demo/[email protected] file=f:/f.dmp full=y
4. Imp demo/[email protected] file=f:/f.dmp full=y ignore=y

Oracle establishes tablespaces and users