Welcome to the home of one of Cincinnati's premier professional organizations, the Greater Cincinnati Oracle User Group (GCOUG). ABOUT US...

Sponsor GCOUG

DOWNLOAD SPONSORSHIP BROCHURE

Big Thanks to our Meeting Sponsors!

Oracle

Rolta-AdvizeX

 

Vendor Sponsors Links

 

Ensure that a devoted audience of Oracle users sees your products via website advertising on the homepage of www.gcoug.org. This highly visible promotional vehicle enables your message to achieve a solid ROI for your campaign. Lean more by downloading the sponsorship brochure above.

Upcoming Meeting

JOIN US AT A GCOUG MEETING

APEX and TOAD!

Thursday, September 6th 2018, 8:30-3:00:

                                             GREATER CINCINNATI ORACLE USERS GROUP

                                                                 September 6th, 2018

                                                                        Location: 

                                                                     Chase Tower

                                                                8044 Montgomery Road

                                                                  Cincinnati, OH 45236

 

* What is Oracle Application Express, also called APEX? Is it Free? How can I use it in my environment? What does it look like inside? With the Release of Oracle 18c, what is new in APEX?

Please welcome Joel Kallman who will present and discuss these topics on September 6th.
 

BIO:
Joel Kallman is a Senior Director of Software Development at Oracle and manages the development and product management of Application Express (APEX). Joel has been at Oracle since 1996 and with his VP Mike Hichwa, created APEX in 1999. His passion is to make customers extraordinarily successful with the Oracle Database, PL/SQL and APEX.

* TOAD, a graphical user interface to develop and manage Oracle Databases. Haven’t heard of it? What can it do? Come and learn all about the current version of TOAD and all the interesting things it can do while connected to an Oracle Database.

Please also welcome Jeffery Surretsky who will present this topic.

BIO:

Jeffrey Surretsky has been working at Quest since 2000 as a Sales Engineer focusing on a wide variety of solutions including Foglight, SharePlex and the TOAD Family of Products. Before working at Quest, he was a DBA for various organizations spanning a diverse range of industries. With over 30 years of experience in Information Technology, Jeffrey has a bachelor’s Degree in Computer Science and an MBA in Management of Information Systems.

* Please also welcome Susan Wong who will present: Database Migration to Cloud with zero downtime

Abstract:

Cloud adoption for enterprise databases is in full swing.  Whether it is production databases supporting mission critical applications or for High availability or Disaster recovery, the Cloud is on nearly every enterprise roadmap. Organizations are presented with options when it comes to cloud platform vendors like Azure, AWS, Google, etc., but have business dependencies on high performance, tight security and near zero downtimes during and after migration. If you are planning on migrating your on-premises production database to the cloud, keeping test or development environments refreshed and in sync this session is for you.

In this session you will learn:

-          Key trends driving the cloud adoption

-          Top considerations for a DBA before moving databases to the cloud

-          Architecture that supports on prem/cloud/hybrid databases for HA or DR using Quest SharePlex

 

Meeting Agenda

08:30a - 09:00a                Meeting Registration/Check-in

09:00a - 10:00a                Low Code Development with APEX – What is it?

10:00a – 10:10a               Break

10:10a – 11:10a               New Features in APEX 18.1

11:10p – 11:20p               Break

11:20p – 12:20p               Intro Hands-on Exercise with APEX (bring your laptop!)

12:20p – 01:00p               Lunch

01:00p – 02:00p               TOAD and working demo - Jeff Surretsky

02:00p - 02:10p                Break

02:10p - 03:10p                Database Migration to Cloud with zero downtime - Susan Wong

03:10p – 03:30p               Q&A, Announcements, Gift Drawing

 

Registration has changed. 

You now create an account on our website and then register for your meeting.

 

DIRECTIONS TO CHASE TOWER.

From Greater Cincinnati/Northern Kentucky Airport:

As you are leaving the airport, follow the signs to East I-275.

Merge onto I-75 North via Exit 84 toward Cincinnati.

Stay on I-75 crossing over the Ohio River into Ohio.

Take I-71 North RIGHT AFTER the bridge.

Continue I-71 North to exit 12.

Turn right onto Montgomery Road.

Stay in far-right lane.

Turn right onto Hosbrook Road.

First road on right is entrance to tower, follow the signs to parking.

Parking is underneath the building.  Park in the west tower if possible. Then take elevation to Lobby level.

Turning right (away from the main desk), follow along the hallway until you see Skips Express Café on the left. Cross the café and you will see the “large” conference room.

From Dayton, OH:

Take I-75 South to East I-275.

Take the I-71 South to Cincinnati ramp.

Take I-71 South to Montgomery Road, Exit 12.

Turn left onto Montgomery Road.

Stay in far-right lane.

Turn right onto Hosbrook Road.

Parking is underneath the building.  Park in the west tower if possible. Then take elevation to Lobby level.

Turning right (away from the main desk), follow along the hallway until you see Skips Express Café on the left. Cross the café and you will see the “large” conference room.

From Columbus, OH:

Take I-71 South to Montgomery Road, Exit 12.

Turn left onto Montgomery Road.

Stay in far-right lane.

Turn right onto Hosbrook Road.

Parking is underneath the building.  Park in the west tower if possible. Then take elevation to Lobby level.

Turning right (away from the main desk), follow along the hallway until you see Skips Express Café on the left. Cross the café and you will see the “large” conference room.

Click here for more info...

From the Blog

Ask Tom

  • IN (vs) EXISTS and NOT IN (vs) NOT EXISTS

    Hi Tom, Can you pls explain the diff between IN and EXISTS and NOT IN and NOT EXISTS. Because I have read that EXISTS will work better than IN and NOT EXISTS will work better than NOT IN (read this is Oracle server tunning). Regard...

  • ORA-12560: TNS:protocol adapter error

    i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating ORA-12560: TNS:protocol adapter error what should i do? please help.. ...

  • Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors

  • How to connect SQLPlus without tnsnames.ora

    Hi I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my tnsnames.ora POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(H...

  • How To FULL DB EXPORT/IMPORT

    Hello Tom, How to do a Full DB exp and Import. I do say exp systemmanager@xyz FULL=Y FILE=FULL.DMP Then If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc. 1) Please...

ONT Security Alerts