Introduction and Demo of Oracle SQLcl and Data Pump

Sdílet
Vložit
  • čas přidán 12. 12. 2021
  • 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:
    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: 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
  • Věda a technologie

Komentáře • 4