{"id":128,"date":"2019-07-09T09:29:08","date_gmt":"2019-07-09T08:29:08","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=128"},"modified":"2026-04-16T17:07:40","modified_gmt":"2026-04-16T16:07:40","slug":"oracle","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/","title":{"rendered":"Oracle"},"content":{"rendered":"\n<p>The Obiwan Oracle database server is available for student use.<\/p>\n\n\n\n<p>The Obiwan server has a separate password from your main University login account, we recommend having using a different password for Obiwan than you do for your main University account.<\/p>\n\n\n\n<p>Please note that the Obiwan server is only available to students who are based at the Maritime Greenwich Campus &#8211; students at partner colleges \/ external centres should speak to the staff at their centre for details on the database server they should be using.<\/p>\n\n\n\n<p>If you do not have a Oracle database or need to get your Oracle password reset you will need to visit the support counter near lab KW116 or email&nbsp;<a href=\"mailto:cms-support@gre.ac.uk\">cms-support@gre.ac.uk<\/a>.<\/p>\n\n\n\n<p>How do I?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/logging-into-oracle-for-the-first-time\/\">Login to Oracle for the first time<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/creating-tables-in-oracle\/\">Configure SQL Developer<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/access-oracle-servers-using-sql-developer\/\">Create tables<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/creating-functions-and-procedures-in-oracle\/\">Functions and Procedures<\/a><\/li>\n\n\n\n\n\n\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/recovering-dropped-tables-and-managing-the-recycle-bin\/\">Recover dropped tables and managing the recycle bin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/creating-a-user-dsn\/\">Create a User DSN<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/connecting-oracle-to-sql-server\/\">Link Oracle to SQL Server<\/a><\/li>\n<\/ul>\n\n\n\n<p>Official Oracle documentation<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/index.htm\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle 12c Database<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Obiwan Oracle database server is available for student use. The Obiwan server has a separate password from your main University login account, we recommend having using a different password for Obiwan than you do &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":43,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-128","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":3,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/128\/revisions"}],"predecessor-version":[{"id":2504,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/128\/revisions\/2504"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}