Notes for Users Migrating from Other Oracle Databases

Describes information that is useful when you are migrating from other Oracle 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 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 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 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 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 Database Real Application Security
  Oracle 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 Database to meet existing and emerging demands of applications developed for the Internet.
• Oracle LogMiner
  LogMiner, which is part of Oracle 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.