Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Comparing structure of Oracle RDB database.

nagadarshan
Occasional Contributor

Comparing structure of Oracle RDB database.

Hi All,

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

1. Physical storage area.

2. System files.
3 REPLIES
Karl Rohwedder
Honored Contributor

Re: Comparing structure of Oracle RDB database.

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
Jean-François Piéronne
Trusted Contributor

Re: Comparing structure of Oracle RDB database.

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
nagadarshan
Occasional Contributor

Re: Comparing structure of Oracle RDB database.

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