使用PLSQL新建oracle表空间和用户

忘是亡心i 2022-10-27 13:44 587阅读 0赞

1.  **用DBA角色登录**

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-9xw7anFE-1612419715419)(C:\\Users\\17391\\AppData\\Roaming\\Typora\\typora-user-images\\image-20210203144849444.png)\]][img-9xw7anFE-1612419715419_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203144849444.png]

1.  **新建表空间**  
    右键“new” --> “sql window” 打开sql窗口，执行以下sql  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlM21vcmU_size_16_color_FFFFFF_t_70]
    
    1）创建表空间
    
    CREATE TABLESPACE 表空间名 DATAFILE ‘C:\\app\\dev\\oradata\\orcl\\表空间名.DBF’ SIZE 1000M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITEDLOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
    
    2）创建临时表空间
    
    CREATE TEMPORARY TABLESPACE “临时表空间名” TEMPFILE ‘C:\\app\\dev\\oradata\\orcl\\临时表空间名.DBF’ SIZE 1000M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M ;
2.  **新建用户**
    
    1）右键选择"users" --> “new”

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-XWcYW529-1612419715424)(C:\\Users\\17391\\AppData\\Roaming\\Typora\\typora-user-images\\image-20210203145045175.png)\]][img-XWcYW529-1612419715424_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203145045175.png]

2） 填写基本用户信息

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-KGdvM17G-1612419715425)(C:\\Users\\17391\\AppData\\Roaming\\Typora\\typora-user-images\\image-20210203152901606.png)\]][img-KGdvM17G-1612419715425_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203152901606.png]

3） 授予权限

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ttviUIc5-1612419715427)(C:\\Users\\17391\\AppData\\Roaming\\Typora\\typora-user-images\\image-20210203153228597.png)\]][img-ttviUIc5-1612419715427_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203153228597.png]

1.  **用新建用户登录即可**

[img-9xw7anFE-1612419715419_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203144849444.png]: /images/20221024/bdb6b7678ed741afacf895e016c56bac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlM21vcmU_size_16_color_FFFFFF_t_70]: /images/20221024/2e1cafcb6eb14531af7f07e72aa9b111.png
[img-XWcYW529-1612419715424_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203145045175.png]: /images/20221024/4dd69e3aa7824db7bc60b480ad4bf199.png
[img-KGdvM17G-1612419715425_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203152901606.png]: /images/20221024/338edc7d31334e2080d7c5ab903efd00.png
[img-ttviUIc5-1612419715427_C_Users_17391_AppData_Roaming_Typora_typora-user-images_image-20210203153228597.png]: /images/20221024/79c9b95bdf0f44b08a986b18d8347c26.png