Introduction and Demo of Oracle SQLcl and Data Pump
A quick look at how you can create import and export jobs in Oracle SQLcl, using a very simple dp export or db import command. This is a new feature in version 21.4 of SQLcl.
Blog Post Announcement:
https://www.thatjeffsmith.com/archive...
We'll also how you can copy these export files automatically to the Oracle Object store such that your imports to the Oracle Cloud are as seamless as possible.
At the end we'll spend a few moments reviewing recent updates including single-sign-on to Autonomous Database with the ADMIN account from your Oracle Cloud console and review a recent SQL Developer Web feature: Charts and Dashboards.
Slides: https://speakerdeck.com/thatjeffsmith...
Fast Forward to see..
00:00:45 The Data Pump (dp) command
00:01:48 Default settings for an Export job
00:02:20 dp export
00:03:46 Data Pump parameters (dp help syntax)
00:05:39 Data Pump examples (db help examples)
00:06:45 Debugging or generating the DBMS_DATAPUMP code (dp -noexec)
00:08:49 Monitoring jobs, logs, downloading dmp files with SQL Developer Web
00:09:57 Capturing the database time zone version
00:12:01 Brian does a lift and shift, export on prem to import in Oracle Cloud Autonomous Database
00:19:01 Oracle Autonomous Database single-sign-on from OCI Console to ADMIN user in SQL Developer Web
00:19:30 Showing SQL Developer Web Charts & Dashboards
