<FONT
face=Arial>****************************************************************
-- DATATYPE.sql
--
- To check datatype consistency between two environments
--
--
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM all_tab_columns -- first environment
WHERE owner = '&OWNER'
MINUS
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM all_tab_columns@&my_db_link -- second environment
WHERE owner = '&OWNER2'
order by table_name, column_name;
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:SRAJENDRAN_at_nlfs.com"
title=SRAJENDRAN_at_nlfs.com>SRAJENDRAN_at_nlfs.com
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Saturday, May 12, 2001 12:20
AM
Subject: DATABASE COMPARE SCRIPT
I am
trying to find out the schema differences between two databases.
Differences like Column size,column datatype,column data length,
indexes,tables,constraints etc.
If
anyone has a script or know where I can get one that will accomplish this,
please let me know.
<SPAN
class=052231820-11052001>Thank
you.
Received on Mon May 14 2001 - 02:47:30 CDT
