Oracle Database 19c Now Available on LiveSQL

 

LiveSQL is a free-to-use Cloud service that provides a platform for developers and DBAs to develop, test and share SQL and PL/SQL scripts, tutorials and best practices. 

It’s the ideal platform to easily learn about existing features (e.g. approx functions, polymorphic table functions, private temporary tables, etc.), and the latest features and enhancements in Oracle Database 19c (e.g. JSON enhancements, etc.).

For the latest Oracle Database 19c availability on other platforms, check out Document ID 742060.1 on My Oracle Support (login required),

 for the Oracle Database Release Schedule which covers both on-premises and in Oracle Cloud (including Autonomous Database Cloud Services) availability.

you can refer to 

https://blogs.oracle.com/database/oracle-database-19c-now-available-on-livesql-v2

19c administration for enabling flashback on

check if archive destination has enough space

sqlplus "/as sysdba"

SQL> alter system set db_recovery_file_dest_size=10G scope=both sid=’*’;

System altered.

SQL> alter system set db_recovery_file_dest=’+DATA_01’ scope=both sid=’*’;

System altered.

SQL> alter database flashback on;

Database altered.

restart the database;

SQL> select log_mode,flashback_on from v$database;

LOG_MODE FLASHBACK_ON

———— ——————

ARCHIVELOG YES

Best wishes