The schema is partitioned into smaller files by the schema object type such as tables, views, and so on. schema directory contains the source database schema translated to PostgreSQL.reports directory contains the generated Schema Analysis Report.The export directory has the following sub-directories and files: If you do not want to import in the default yugabyte database, specify the name of the target database name using the -target-db-name argument to the yb-voyager import commands. If the target database name is not provided, yb-voyager assumes the target database name to be yugabyte. The database name can be the same or different from the source database name. Create the target databaseĬreate the target database in your YugabyteDB cluster. Prepare your target YugabyteDB database cluster by creating a database, and a user for your cluster. -oracle-tns-alias (TNS (Transparent Network Substrate) alias configured to establish a secure connection with the server.).-oracle-db-sid (Oracle System Identifier you can use while exporting data from Oracle instances.).-source-db-schema (Schema name of the source database.).Note that you can use only one of the following arguments to connect to your Oracle instance: If you want yb-voyager to connect to the source database over SSL, refer to SSL Connectivity. owner || '."' ||R.object_name || '" to _reader_role' END LOOP END / GRANT SELECT_CATALOG_ROLE TO _reader_role GRANT SELECT ANY DICTIONARY TO _reader_role GRANT SELECT ON SYS.ARGUMENT$ TO _reader_role Ĭreate a user ybvoyager and grant CONNECT and _reader_role to the user:Įxec rdsadmin.rdsadmin_t_configuration( 'archivelog retention hours', 24) owner || '."' ||R.object_name || '" to _reader_role' END LOOP END / BEGIN FOR R IN ( SELECT owner, object_name FROM all_objects WHERE owner = UPPER( '') and object_type = 'TYPE') LOOP EXECUTE IMMEDIATE 'grant execute on ' ||R. owner || '."' ||R.object_name || '" to _reader_role' END LOOP END / BEGIN FOR R IN ( SELECT owner, object_name FROM all_objects WHERE owner = UPPER( '') and object_type = 'TABLE' MINUS SELECT owner, table_name from all_nested_tables where owner = UPPER( '')) LOOP EXECUTE IMMEDIATE 'grant select on ' ||R. Prepare your source database by creating a new database user, and provide it with READ access to all the resources which need to be migrated.ĬREATE ROLE _reader_role BEGIN FOR R IN ( SELECT owner, object_name FROM all_objects WHERE owner = UPPER( '') and object_type in ( 'VIEW', 'SEQUENCE', 'TABLE PARTITION', 'SYNONYM', 'MATERIALIZED VIEW')) LOOP EXECUTE IMMEDIATE 'grant select on ' ||R.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |