From bunyamink@havelsan.com.tr Mon, 14 May 2001 00:47:30 -0700
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Date: Mon, 14 May 2001 00:47:30 -0700
Subject: Re: DATABASE COMPARE SCRIPT
Message-ID: <F001.00302523.20010513234525@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: When to go for ORACLE NAMES Server




<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@nlfs.com" 
  title=SRAJENDRAN@nlfs.com>SRAJENDRAN@nlfs.com 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@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.