[GitHub] [airflow] potiuk commented on a change in pull request #11197: Add tips and tricks oracle shops page to production-deployment.rst

[GitBox <gi...@apache.org>]

potiuk commented on a change in pull request #11197:
URL: https://github.com/apache/airflow/pull/11197#discussion_r499022794



##########
File path: docs/howto/connection/oracle.rst
##########
@@ -85,3 +85,36 @@ Extra (optional)
     .. code-block:: bash
 
         export AIRFLOW_CONN_ORACLE_DEFAULT='oracle://oracle_user:XXXXXXXXXXXX@1.1.1.1:1521?encoding=UTF-8&nencoding=UTF-8&threaded=False&events=False&mode=sysdba&purity=new'
+
+
+Tips and Tricks for Oracle Shops
+================================
+
+Oracle users an SID to identify a unique database instance. Oracle also has an unusual definition of schema and user, wherein a schema set of objects owned by a user. Therefore, creating a connection through the Airflow web GUI can be confusing.
+
+To create a connection: 
+
+- Go to Admin => Connections => Create
+
+- Name your connection
+
+- Select connection type: Oracle
+
+- Enter your hostname in the following format: NameOrIP:PORT#/SID Example(s): 10.0.0.111:1521/orcl or weshouldhaveusedpostgres.ourdomain.com:1521/dev

Review comment:
       Yeah. Let's simplify and point there. It turned out that "move" = "delete" and point to the right place.




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org