topic Comparing structure of Oracle RDB database. in Operating System - OpenVMS

Comparing structure of Oracle RDB database.

nagadarshan — Fri, 03 Nov 2006 03:15:56 GMT

Hi All,

Is there way to compare one Oracle RDB database with another interms of.

1. Physical storage area.

2. System files.

Re: Comparing structure of Oracle RDB database.

Karl Rohwedder — Fri, 03 Nov 2006 04:40:28 GMT

You may use RMU/EXTRACT to create a SQL commandfile to recreate the database and compare them.
Or you may use RMU/DUMP and compare the outputs.

regards Kalle

Re: Comparing structure of Oracle RDB database.

Jean-François Piéronne — Fri, 03 Nov 2006 05:08:44 GMT

You can use
rmu/dump/header=area my_database

to extract physical storage area.

You can search the output for "Filename is" to return the area and snapshot filename, for example
pipe rmu/dump/hea=area mf_personnel | search sys$pipe: "Filename is"

You can also use the /output qualifier of rmu/dump to store in a file the result.

JF

Re: Comparing structure of Oracle RDB database.

nagadarshan — Tue, 07 Nov 2006 10:57:45 GMT

Hi All,

I have created a extract script with RMU/Extract command, but I get error while executing the script, as many of the views uses reserve words as column names like the example given below.

create view USER_CONS_COLUMNS
("OWNER",
CONSTRAINT_NAME,
TABLE_NAME,
COLUMN_NAME,
"POSITION") as
select
C1.OWNER,
C1.CONSTRAINT_NAME,
C1.TABLE_NAME,
C1.COLUMN_NAME,
C1.POSITION
from ALL_CONS_COLUMNS C1
where (C1."OWNER" = USER);

Is there any other way of specifying the reserved words as column names. As reserved words in double quotes may not work with Oracle rdb 7.0 version.

Regards,
Darshan