SnowConvert: Object References Report¶

Where can I find it?¶

The object references report can be found in a folder named “reports”, in the output folder of your conversion. The name of the file itself starts with “ObjectReferences” so it can easily be located.

The format of the file is .CSV.

What information does it contain?¶

The object references report contains the following information about all the references found while converting:

Oracle Database Links as object references¶

To get the information such as database name, schema name, or object name of database link references, we need to know how the database link was defined. Database links contain the most relevant information in the connection string used in its definition. E.g.

 CREATE DATABASE LINK remote_hr_db
CONNECT TO hr_user
IDENTIFIED BY hr_password
USING 'RemoteDB';

SELECT * FROM hr.employees@remote_hr_db;

 CREATE DATABASE LINK remote_hr_db1
CONNECT TO hr_user
IDENTIFIED BY hr_password
USING 'RemoteDB.MySchema';

SELECT * FROM employees@remote_hr_db1;

 CREATE DATABASE LINK remote_hr_db2
CONNECT TO hr_user
IDENTIFIED BY hr_password
USING '(DESCRIPTION=(
          ADDRESS=
          (PROTOCOL=TCP)
          (HOST=10.48.195.17)
          (PORT=1521))
      (CONNECT_DATA=(SID=MyDB)))';

SELECT * FROM employees@remote_hr_db2;

Relation Type¶

The relation type represents how a caller code unit is related to an object reference. SnowConvert is able to identify the following kinds of relations:

• FOREIGN KEY

• INSERT

• DELETE

• UPDATE

• CALL

• EXECUTE

• SYNONYM

• ALTER

• DROP

• MERGE

• TRUNCATE

• LOCK

• INDEX

• TABLE COLUMN

• GRANT

• REVOKE

• SELECT

  • COLUMN

  • FROM

  • WHERE

  • HAVING

  • GROUP BY

  • JOIN

  • ORDER BY

 CREATE TABLE TABLE2
(
  COL1 VARCHAR(50) NOT NULL,
  COL2 INT NOT NULL
);

CREATE OR REPLACE PROCEDURE Procedure01 (param1 NUMBER)
IS
BEGIN
    UPDATE TABLE2
    SET COL1 = 'Anderson'
    WHERE COL2 = param1;
END;

 CREATE TABLE TABLE1
(
  COL1 INT
);

CREATE TABLE TABLE2 
(
  COL1 INT,
  CONSTRAINT FK_COL1 FOREIGN KEY (COL1)
    REFERENCES TABLE1(COL1)
);

 CREATE TABLE TABLE1
(
  COL1 INT
);

CREATE VIEW VIEW1 
AS
SELECT * FROM TABLE1;

 CREATE FUNCTION FUNCTION1(PARAM1 INT) 
RETURN NUMBER 
IS
BEGIN  
  RETURN(PARAM1 + 1); 
END;

CREATE VIEW VIEW1
AS
SELECT FUNCTION1(*) FROM TABLE1;