List user objects.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Sat, 04 Mar 2017 23:23:47 +0200
changeset 2112 86ec943e6823
parent 2111 f780f1b08e12
child 2113 6c7691230622
List user objects.
oracle.rst
--- a/oracle.rst	Sat Mar 04 19:54:58 2017 +0200
+++ b/oracle.rst	Sat Mar 04 23:23:47 2017 +0200
@@ -92,6 +92,11 @@
 
   select distinct TABLESPACE_NAME from USER_TABLES;
 
+List user objects::
+
+  select OBJECT_NAME, OBJECT_TYPE from USER_OBJECTS
+    order by OBJECT_TYPE, OBJECT_NAME;
+
 List of current user permissions::
 
   select * from SESSION_PRIVS;
@@ -129,6 +134,31 @@
 
   show parameter user_dump_dest;
 
+Installing express edition
+==========================
+
+Disable APEX port
+-----------------
+
+Find APEX port in usage::
+
+  select dbms_xdb.GetHttpPort, dbms_xdb.GetFtpPort from dual;
+
+Disable APEX lisener (to free useful 8080 port) from ``system``::
+
+  execute dbms_xdb.SetHttpPort(0);
+
+or move to another port::
+
+  execute dbms_xdb.SetHttpPort(8090);
+
+http://stackoverflow.com/questions/165105/how-to-disable-oracle-xe-component-which-is-listening-on-8080
+  How to disable Oracle XE component which is listening on 8080?
+http://daust.blogspot.co.il/2006/01/xe-changing-default-http-port.html
+  XE: Changing the default http port.
+https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/
+  Stop Oracle XE from listening on port 8080.
+
 Profiling.
 ==========