{"id":1013,"date":"2012-08-15T15:41:31","date_gmt":"2012-08-15T07:41:31","guid":{"rendered":"http:\/\/rmohan.com\/?p=1013"},"modified":"2012-08-15T15:41:31","modified_gmt":"2012-08-15T07:41:31","slug":"oracle-schema-creation","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=1013","title":{"rendered":"Oracle Schema Creation"},"content":{"rendered":"<div>A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes.<\/div>\n<h3>\n$ sqlplus \/nolog<\/p>\n<p>SQL&gt; connect \/ as sysdba<br \/>\nConnected<\/p>\n<p>Creating a New Schema<br \/>\nSQL&gt; create user ctechz identified by ctehz11;<br \/>\nUser created<\/p>\n<p>Grant Permissions to user<br \/>\nSQL&gt; grant create session, create table, create trigger, create sequence, create procedure, create view to ctechz;<br \/>\nGrant succeeded<\/p>\n<p>Connecting to Schema<\/p>\n<p>SQL&gt; connect ctechz\/ctechz11;<\/h3>\n<div>Connected<\/div>\n<h3>\nGranting table space to the schema<br \/>\nSQL&gt; grant unlimited tablespace to ctechz;<br \/>\nGrant succeeded<\/h3>\n","protected":false},"excerpt":{"rendered":"<p>A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. $ sqlplus \/nolog<\/p>\n<p>SQL&gt; connect \/ as sysdba [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1013"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1013"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1013\/revisions"}],"predecessor-version":[{"id":1015,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1013\/revisions\/1015"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}