Notes for Users Migrating from Other Oracle AI Databases

Describes information that is useful when you are migrating from other Oracle AI Databases to Oracle Autonomous AI Database.

• Initialization Parameters Autonomous AI Database configures database initialization parameters automatically when you provision a database. You do not need to set any initialization parameters to start using your service. But, you can modify some parameters if you need to.

• SQL Commands

  Autonomous AI Database allows most of the SQL commands available in Oracle AI Database. To ensure the security and the performance of Autonomous AI Database, some SQL commands are restricted.

• Data Types Autonomous AI Database allows most of the data types available in Oracle AI Database. To ensure the security and the performance of Autonomous AI Database, some data types are restricted.

• PL/SQL Package Notes for Autonomous AI Database Notes for Oracle AI Database PL/SQL packages in Autonomous AI Database.

• ADMIN User Roles and Privileges

  In Autonomous AI Database the predefined administrative user is ADMIN and this account has privileges to manage users and to manage the database.

• Oracle XML DB Describes Autonomous AI Database support for Oracle XML DB features. To ensure the security and the performance of your Autonomous AI Database, some Oracle XML DB features are restricted.

• Oracle Text Describes Autonomous AI Database support for Oracle Text features. To ensure the security and the performance of your Autonomous AI Database, some Oracle Text features are restricted.

• Oracle Flashback

  Oracle Flashback Technology is a group of Oracle AI Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

• Oracle AI Database Real Application Security

  Oracle AI Database Real Application Security is a database authorization model that: supports declarative security policies, enables end-to-end security for multitier applications, provides an integrated solution to secure database and application resources, and advances the security architecture of Oracle AI Database to meet existing and emerging demands of applications developed for the Internet.

• Oracle LogMiner

  LogMiner, which is part of Oracle AI Database, enables you to query online and archived redo log files through a SQL interface. Redo log files contain information about the history of activity on a database.

• Choose a Character Set for Autonomous AI Database When you provision a database, depending on the workload type, you can select a database character set and a national character set.

• Query for Client Errors

  You can query for database client errors using v$client_errors to search for alert log related error data.

• Manage Roles and Privileges when Migrating to Autonomous AI Database

  Describes how roles and privileges are managed when migrating to Autonomous AI Database, including details on unsupported roles, privilege conversion, and automated handling during migration.