{"id":861,"date":"2021-08-15T04:57:00","date_gmt":"2021-08-14T20:57:00","guid":{"rendered":"http:\/\/www.langmanezhuang.com\/index.php\/2021\/08\/15\/oracle%e6%95%b0%e6%8d%ae%e6%b7%bb%e5%8a%a0%e7%94%a8%e6%88%b7%ef%bc%88dba%e8%a7%92%e8%89%b2%ef%bc%89%e5%92%8c%e8%a1%a8%e7%a9%ba%e9%97%b4\/"},"modified":"2021-08-15T04:57:00","modified_gmt":"2021-08-14T20:57:00","slug":"oracle%e6%95%b0%e6%8d%ae%e6%b7%bb%e5%8a%a0%e7%94%a8%e6%88%b7%ef%bc%88dba%e8%a7%92%e8%89%b2%ef%bc%89%e5%92%8c%e8%a1%a8%e7%a9%ba%e9%97%b4","status":"publish","type":"post","link":"http:\/\/blog.langmanezhuang.com\/index.php\/2021\/08\/15\/oracle%e6%95%b0%e6%8d%ae%e6%b7%bb%e5%8a%a0%e7%94%a8%e6%88%b7%ef%bc%88dba%e8%a7%92%e8%89%b2%ef%bc%89%e5%92%8c%e8%a1%a8%e7%a9%ba%e9%97%b4\/","title":{"rendered":"Oracle\u6570\u636e\u6dfb\u52a0\u7528\u6237\uff08dba\u89d2\u8272\uff09\u548c\u8868\u7a7a\u95f4"},"content":{"rendered":"<div class=\"cnblogs_Highlighter\">\n<pre class=\"brush:sql;gutter:true;\">1.\u9996\u5148\uff0c\u521b\u5efa\uff08\u65b0\uff09\u7528\u6237\uff1a\n    create user username identified by password;\n    username\uff1a\u65b0\u7528\u6237\u540d\u7684\u7528\u6237\u540d\n    password: \u65b0\u7528\u6237\u7684\u5bc6\u7801\n\u4e5f\u53ef\u4ee5\u4e0d\u521b\u5efa\u65b0\u7528\u6237\uff0c\u800c\u4ecd\u7136\u7528\u4ee5\u524d\u7684\u7528\u6237\uff0c\u5982\uff1a\u7ee7\u7eed\u5229\u7528scott\u7528\u6237\n\n2.\u521b\u5efa\u8868\u7a7a\u95f4\uff1a\n    create tablespace tablespacename datafile 'd:data.dbf' size xxxm;\n    tablespacename\uff1a\u8868\u7a7a\u95f4\u7684\u540d\u5b57\n    d:data.dbf'\uff1a\u8868\u7a7a\u95f4\u7684\u5b58\u50a8\u4f4d\u7f6e\n    xxx\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\uff0cm\u5355\u4f4d\u4e3a\u5146(M)\n3.\u5c06\u7a7a\u95f4\u5206\u914d\u7ed9\u7528\u6237\uff1a\n   alert user username default tablespace tablespacename;\n   \u5c06\u540d\u5b57\u4e3atablespacename\u7684\u8868\u7a7a\u95f4\u5206\u914d\u7ed9username \n\n4.\u7ed9\u7528\u6237\u6388\u6743\uff1a\n   grant create session,create table,unlimited tablespace to username;\n\n5.\u7136\u540e\u518d\u4ee5\u697c\u4e3b\u81ea\u5df1\u521b\u5efa\u7684\u7528\u6237\u767b\u5f55\uff0c\u767b\u5f55\u4e4b\u540e\u521b\u5efa\u8868\u5373\u53ef\u3002\nconn username\/password;6.\u67e5\u770b\u670d\u52a1\u540denv |grep SID&nbsp;7.\u6388\u4e88dba\u6743\u9650grant dba to username7.\u4f7f\u7528\u4e0a\u9762\u7684\u7528\u6237\u540d\u3001\u5bc6\u7801\u3001sid\u767b\u5f55plsql\n\n\n\u6bcf\u6b65\u6267\u884c\u7684sql\uff1a\uff08sjzx\u662f\u6570\u636e\u5e93\u540d\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u3001\u8868\u7a7a\u95f4\u540d\uff09\n\uff081\uff09create user sjzx identified by sjzx\n\uff082\uff09create tablespace sjzx datafile 'D:dbapporadataorclsjzx.dbf' \n        size 100m \n        autoextend on next 32m maxsize 2048m\n\n\uff083\uff09alter user sjzx default tablespace sjzx\n\n\uff084\uff09grant create session,create table,unlimited tablespace to sjzx\n\n \n\n1.\u521b\u5efa\u7528\u6237\ncreate user user_name identified by \"user_password\"\ndefault tablespace tbs_name\ntemporary tablespace temp profile DEFAULT;\n\n2.\u6388\u6743\ngrant connect to user_name;\ngrant create indextype to user_name;\ngrant create job to user_name;\ngrant create materialized view to user_name;\ngrant create procedure to user_name;\ngrant create public synonym to user_name;\ngrant create sequence to user_name;\ngrant create session to user_name;\ngrant create table to user_name;\ngrant create trigger to user_name;\ngrant create type to user_name;\ngrant create view to user_name;\ngrant unlimited tablespace to user_name;\nalter user user_name quota unlimited on tbs_name;\n<\/pre>\n<\/div>\n<p>\u3000\u3000\u5728oracle\u547d\u4ee4\u884c\u4e2d\uff0c\u67e5\u770boracle\u8868\u7a7a\u95f4\u6570\u636e\u6587\u4ef6\u4f4d\u7f6e<\/p>\n<div class=\"cnblogs_Highlighter\">\n<pre class=\"brush:sql;gutter:true;\">select t1.name,t2.name   from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;\n<\/pre>\n<\/div>\n<p>\u3000<img decoding=\"async\" src=\"http:\/\/cdn.langmanezhuang.com\/blog\/20221126\/123-543925-20210815131125648-258977641.png\" alt=\"\" loading=\"lazy\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u9996\u5148\uff0c\u521b\u5efa\uff08\u65b0\uff09\u7528\u6237\uff1a create user username identified by passwo &hellip; <a href=\"http:\/\/blog.langmanezhuang.com\/index.php\/2021\/08\/15\/oracle%e6%95%b0%e6%8d%ae%e6%b7%bb%e5%8a%a0%e7%94%a8%e6%88%b7%ef%bc%88dba%e8%a7%92%e8%89%b2%ef%bc%89%e5%92%8c%e8%a1%a8%e7%a9%ba%e9%97%b4\/\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">Oracle\u6570\u636e\u6dfb\u52a0\u7528\u6237\uff08dba\u89d2\u8272\uff09\u548c\u8868\u7a7a\u95f4<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/861"}],"collection":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/comments?post=861"}],"version-history":[{"count":0,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/861\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/media?parent=861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/categories?post=861"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/tags?post=861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}