Activity overview
Latest activity by gahuja
Schema Comparison HTML reports too big
Hi
I' doing schema compairson and sending the report and deployment script in scheduled jobs to the developers,but the size of few HTML reports is going even to 120MB,even after zipping the size is...
e..g
CREATE TABLE staging.rg_temp_318261722_1 (
cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL,
processing_location VARCHAR2(3 BYTE) NOT NULL,
trial_balance_id NUMBER(25) NOT NULL,
freq_ind CHAR,
"ADJ_DATE" DATE,
source_ref VARCHAR2(56 BYTE),
native_currency VARCHAR2(3 BYTE),
expiry_date DATE,
key_pos_17 CHAR DEFAULT '_',
key_pos_18 CHAR DEFAULT '_',
CREATE TABLE control.d_trade_bkp (
cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL,
processing_location VARCHAR2(3 BYTE) NOT NULL,
trial_balance_id NUMBER(25) NOT NULL,
freq_ind CHAR,
IN botht he cases the dataype of run_id is integer which gets converted to NUMBER(*,0)
Need to know why tool is doing this / comments
e..g
CREATE TABLE staging.rg_temp_318261722_1 (
cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL,
processing_location VARCHAR2(3 BYTE) NOT NULL,
trial_balance_id NUMBER(25) NOT NULL,
freq_ind CH...
Hi Richard
when is the next version expected to release?
Thanks
Gagan / comments
Hi Richard
when is the next version expected to release?
Thanks
Gagan
Hi Richard
may be you are talking of the stage when we deploy the script we get the deployment warnings
but I would like to have only the warnings without deploring the script so that i can work on the warnings before hand even before trying to deploy the script
is it possible to have the warnings before deploying
Thanks
Gagan / comments
Hi Richard
may be you are talking of the stage when we deploy the script we get the deployment warnings
but I would like to have only the warnings without deploring the script so that i can work on...
Possible to put "prompt" in deployment script
is it possible to put prompt option in deployment script so that we can get output messages for all the objects getting created on the screen
in create table some columne names in double quotes why?
Hello
I noticed some of the below named column names in create table command in deployment script are being shown in double quotesOWNER,MODEL,SUPPORT
Would like to confirm is it just because they a...
Integer datatype shown as number(*,0) in deploymnt script ?
In the deployment script we have noticed everywhere where there is integer datatype,it is getting converted as number(*,0), , ofcourse on deployment again the number(*,) gets converted into intege...
comapring grants:Does it compares both system and object pri
comapring grants:Does it compares both system level and object level grants
In one of the schema compairson deployment scripts I see "GRANT FLASHBACK ON X TO Y" ,would like to know does the schema ...
How the sequencing of object creation is take care ?
Hi Richard
question is regarding the sequence of object creation while deploying the diff script
e.g if during deployment script view is getting created based on any table or index is created on ba...
How to get Warning Report with Command line interface?
Hi I'm using below command for oracle schema comparison"C:Program FilesRed GateSchema Compare for Oracle 3sco32" -source star_ro_user/STAR_RO_USER@qnyb3r70{WEB} -target star_ro_user/STAR_RO_USER@DN...