This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Aug 29, 2012 6:34 AM by wkobargs Go to original post RSS
  • 15. Re: Sybase to Oracle migration
    wkobargs Journeyer
    Currently Being Moderated
    What privileges are needed for Oracle_Db user.
    That is well described in the online help. Read the chapter "Creating a Database User for the Migration Repository".
    I was able to create a captured and converted model but both had the sybase code.
    That is documented as well:

    Creating and Customizing the Converted Model

    After you capture a third-party database, the next step is to convert it, creating the converted model. The converted model is a representation of the structure of the destination database. SQL Developer creates the converted model using the information from the captured model.

    By default, all procedures, functions, triggers, and views are copied to the converted model during translation and translated to Oracle PL/SQL. However, if translation fails for any of the objects, those objects appear in the converted model but their original SQL code remains unchanged. Objects that remain in their original SQL code will not be used when the generation scripts are created. Therefore, to have any such objects migrated, you must either fix the problem in the original SQL code before generating the script or edit the generated script to replace the original SQL code with valid PL/SQL code.

    Wolfgang
  • 16. Re: Sybase to Oracle migration
    84959 Explorer
    Currently Being Moderated
    I suggest you spend some time reading up on migration process using SQL Developer. There is lot of material on OTN and elsewhere.
    Here is a link I think will be very useful to users who are new to SQL Develoepr: http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

    Hope you will find it useful.
  • 17. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    Can you give me link for online migration?

    In offline migration do we have to make changes in sybase SYB15_OFFLINE_CAPTURE
    and SYB15_BCP_SCRIPT.
  • 18. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    From captured model i tried to generate the converted model.My tables are getting are getting converted to oracle.For eg. i had some columns with datatype money in sybase and now the are in number format in converted model.But all the procedure and views are in sybase code in converted model.
    Why is this so?

    Can u give me link for online migration of sybase to oracle

    Edited by: Rahul_India on Aug 29, 2012 1:22 AM
  • 19. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    I am getting these errors
    Failed to remove converted model: Closed Connection     29-AUG-12-09:02:50     
    Failed To Convert View cd_program_list_v  > Demand.dbo.cd_program_list_v:String index out of range: 0     29-AUG-12-08:58:31     Convert
    Failed To Convert View cd_prod_type_v  > Demand.dbo.cd_prod_type_v:String index out of range: 0     29-AUG-12-08:55:51     Convert
    Failed To Convert View cd_prod_grp_v  > Demand.dbo.cd_prod_grp_v:String index out of range: 0     29-AUG-12-08:54:50     Convert
    Failed To Convert View cd_material_type_v  > Demand.dbo.cd_material_type_v:String index out of range: 0     29-AUG-12-08:53:50     Convert
    Failed To Convert View cd_market_seg_v  > Demand.dbo.cd_market_seg_v:String index out of range: 0     29-AUG-12-08:52:37     Convert
    Failed To Convert View cd_grade_v  > Demand.dbo.cd_grade_v:String index out of range: 0     29-AUG-12-08:48:53     Convert
    Failed To Convert View cd_discipline_v  > Demand.dbo.cd_discipline_v:String index out of range: 0     29-AUG-12-08:45:16     Convert
    Failed To Convert View cd_category_v  > Demand.dbo.cd_category_v:String index out of range: 0     29-AUG-12-08:37:54     Convert
    Failed To Convert View cd_bus_area_v  > Demand.dbo.cd_bus_area_v:String index out of range: 0     29-AUG-12-08:33:28     Convert
    Failed To Convert View map_state_region_v  > Demand.dbo.map_state_region_v:String index out of range: 0     29-AUG-12-08:16:44     Convert
    Failed To Convert View cd_region_v  > Demand.dbo.cd_region_v:String index out of range: 0     29-AUG-12-08:16:20     Convert
    Multiple Limitations for View sox_support_user_priv_short     29-AUG-12-08:06:35     
    Failed To Convert View cd_translation_indicator_v  > Demand.dbo.cd_translation_indicator_v:String index out of range: 0     29-AUG-12-08:00:11     Convert
    Multiple Limitations for View sox_support_user_priv_long     29-AUG-12-07:59:03     
    Default Values Transformed: The following column default values have been transformed during conversion     29-AUG-12-07:50:20     
    Following objects have had name changes applied     29-AUG-12-07:43:34     
    Index 'pk_wk_catalog_product_t' on table 'wk_catalog_product_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:21     
    Index 'togo_fcst_pk' on table 'togo_fcst_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:21     
    Index 'pk_vera_matcodeb_t' on table 'vera_matcodeb_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:13     
    Index 'title_count_t_pk' on table 'title_count_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'tmp_flpe_budget_fcst_pk' on table 'tmp_flpe_budget_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'wk_invalid_disc_busarea_pk' on table 'tmp_invalid_products_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'PK_new_sales_fcst' on table 'new_sales_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'pk_prod_type_rel_t' on table 'prod_type_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'pk_wk_fcstlist_t' on table 'wk_fcstlist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'pk_wk_catalog_file_t' on table 'wk_catalog_file_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'pk_wk_catalog_isbns_t' on table 'wk_catalog_isbns_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:12     
    Index 'pk_category2_t' on table 'category2_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:11     
    Index 'pk_wk_openstates_t' on table 'wk_openstates_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_prod_rel_tmp' on table 'prod_rel_t_tmp' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'tmp_flanc_budget_fcst_pk' on table 'tmp_flanc_budget_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_tmp_pe_units_t' on table 'tmp_pe_units_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_tmp_cat2_repair_t' on table 'tmp_cat2_repair_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_wk_forecast_access_t' on table 'wk_forecast_access_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'setup_pgm__20592064362' on table 'setup_pgm_chg_audit_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_isbn_sales_hist_t' on table 'isbn_sales_hist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_wk_isbn_revenue_t' on table 'wk_isbn_revenue_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:03     
    Index 'pk_wk_program_t' on table 'wk_program_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:42:02     
    Index 'pk_tmp_fcst_prod_repair_t' on table 'tmp_fcst_prod_repair_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'budget_dollars_isbn_pk' on table 'budget_dollars_isbn' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_user_import_setup_pgt_t' on table 'user_import_setup_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_menuitems_access_t' on table 'menuitems_access_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_sales_class_desc_t' on table 'sales_class_desc_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'PK_upps_extract_hist' on table 'upps_extract_hist' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_wk_setup_cat1pgmlist_t' on table 'wk_setup_cat1pgmlist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_product_t' on table 'product_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_res_prod_hist_t' on table 'res_prod_hist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:54     
    Index 'pk_profit_prod_type_pct_t' on table 'profit_center_prod_type_pct_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:53     
    Index 'pk_fcst_key_t' on table 'fcst_key_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_sales_class_map_t' on table 'sales_class_map_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_contract_price_t' on table 'contract_price_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_exclude_type_load_t' on table 'exclude_type_load_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_fcst_change_log' on table 'copyforecast_log_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_fcst_prod_t' on table 'fcst_prod_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_wk_setup_peanc_pe_t' on table 'wk_setup_peanc_pe_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_wk_missing_isbns_vera' on table 'wk_missing_isbns_vera' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_program_new' on table 'program_new' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'pk_fcst_change_log' on table 'tmp_copyfailed_log' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:44     
    Index 'budget_active_pk' on table 'budget_active_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:36     
    Index 'pk_bk_prod_rel_t' on table 'bk_prod_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'PK_phased_sales_fcst' on table 'phased_sales_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'pk_res_rates_t' on table 'res_rates_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'pk_sales_usage_hist_t' on table 'sales_usage_hist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'pk_prod_rel_t' on table 'prod_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'PK_phased_samples_fcst' on table 'phased_samples_fcst_hist' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'pk_wk_tmprollup_t' on table 'wk_tmprollup_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'disp_bus_area_map_pk' on table 'disp_bus_area_map_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'budget_audit_pk' on table 'budget_audit_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:35     
    Index 'PK_upps_extract' on table 'upps_extract' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:29     
    Index 'PK_new_samples_fcst' on table 'new_samples_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'pk_category4_t' on table 'category4_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'pk_load_budget_forecast_pct_t' on table 'load_budget_forecast_pct_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'wk_modifie_18122015062' on table 'wk_modified_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'pk_suspense_product_t' on table 'suspense_product_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'PK_curr_sales_fcst' on table 'curr_sales_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:28     
    Index 'pk_setup_pgm_chg_t' on table 'setup_pgm_chg_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:25     
    Index 'PK_phased_frees_fcst' on table 'phased_frees_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:25     
    Index 'PK_fcst_audit_trail' on table 'fcst_audit_trail' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:25     
    Index 'PK_new_frees_fcst' on table 'new_frees_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:17     
    Index 'PK_curr_frees_fcst' on table 'curr_frees_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_dfs_stat_t' on table 'dfs_stat_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_fcst_total_t' on table 'fcst_total_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_tmp_res_prod_repair_t' on table 'tmp_res_prod_repair_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_wk_catalog_prod_type_rel_t' on table 'wk_catalog_prod_type_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'prod_type_pk' on table 'prod_type_default_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'PK_curr_samples_mthly_fcst' on table 'curr_samples_mthly_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_system_messages_t' on table 'system_messages_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:16     
    Index 'pk_pgt_t' on table 'pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:15     
    Index 'pk_program_t' on table 'program_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_tmp_res_prod_t' on table 'tmp_res_prod_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_forecast_access_t' on table 'forecast_access_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_pgt_new' on table 'pgt_new' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_b_pgt_t' on table 'b_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_vera_peanc_t' on table 'vera_peanc_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'PK_new_cons_fcst' on table 'new_cons_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'pk_tmp_stateregion_t' on table 'tmp_stateregion_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:07     
    Index 'budget_active_pk' on table 'cur_budget_active_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:06     
    Index 'pk_wk_fcst_inventory_t' on table 'wk_fcst_inventory_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:41:05     
    Index 'pk_wk_subject_t' on table 'wk_subject_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:56     
    Index 'pk_menuitems_access_tvk' on table 'menuitems_access_tvk' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_wk_setup_category_t' on table 'setup_category_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_new_prod_type_t' on table 'new_prod_type_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_vera_matcodea_t' on table 'vera_matcodea_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_wk_recalc_t' on table 'wk_recalc_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_wk_catalog_insert_t' on table 'wk_catalog_insert_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_wk_prod_rel_t' on table 'wk_prod_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_sales_class_pct_t' on table 'sales_class_pct_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:55     
    Index 'pk_fcst_cal_t' on table 'fcst_cal_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:54     
    Index 'PK_auto_cmpy' on table 'auto_cmpy' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_code_tables_t' on table 'code_tables_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_fcst_change_log' on table 'fcst_change_log' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_wk_dops_isbn_snapshot_rpt_t' on table 'wk_dops_isbn_snapshot_rpt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_fcst_t' on table 'fcst_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_tmp_bill_fcst_t' on table 'tmp_bill_fcst_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_setup_peanc_t' on table 'setup_peanc_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_setup_pgt_t' on table 'setup_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'PK_suspended_isbns' on table 'suspended_isbns' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:46     
    Index 'pk_helptext' on table 'helptext_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:45     
    Index 'pk_tmp_prod_t' on table 'tmp_prod_type_rel_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'pk_tmp_sales_yr_t' on table 'tmp_sales_yr_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'pk_tmp_rel_pe_units_t' on table 'tmp_rel_pe_units_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'PK_sfs_mthly_samples' on table 'sfs_mthly_samples' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'pk_profit_center_map_t' on table 'profit_center_map_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'pk_wk_catalog_peanc_t' on table 'wk_catalog_peanc_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:40     
    Index 'pk_inflation_t' on table 'inflation_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:39     
    Index 'pk_wk_fcst_prod_t' on table 'wk_fcst_prod_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:37     
    Index 'pk_sales_class_pct_t' on table 'profit_center_pct_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:36     
    Index 'pk_category2_chg_t' on table 'category2_chg_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:35     
    Index 'wk_pe_anc__21461066862' on table 'wk_pe_anc_relations_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_wk_setup_pgt_t' on table 'wk_setup_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'PK_phased_samples_fcst' on table 'phased_samples_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_pgt_t_vera' on table 'pgt_t_vera' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_task_access_t' on table 'task_access_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_wk_isbn_t' on table 'wk_isbn_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_load_budget_forecast_val_t' on table 'load_budget_forecast_val_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'wk_pe_units_t' on table 'wk_pe_units_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'tmp_flpe_rebudget_fcst_pk' on table 'tmp_flpe_rebudget_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:27     
    Index 'pk_st_ind_t' on table 'st_ind_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:26     
    Index 'PK_fcst_audit_trail_mthly' on table 'fcst_audit_trail_mthly' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'pk_menuitems_t' on table 'menuitems_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'PK_curr_samples_fcst' on table 'curr_samples_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'PK_monthly_phasing_curve' on table 'monthly_phasing_curve' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'pk_pgt_fix_t' on table 'pgt_fix_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'pk_tmp_deletefcst_t' on table 'tmp_deletefcst_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'pk_tmp_bad_discipline_products' on table 'tmp_bad_discipline_products_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'pk_tmp_contract_price_t' on table 'tmp_contract_price_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'PK_phased_sales_fcst_hist' on table 'phased_sales_fcst_hist' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:18     
    Index 'PK_curr_cons_fcst' on table 'curr_cons_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:17     
    Index 'pk_wk_setup_cat2pgmlist_t' on table 'wk_setup_cat2pgmlist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_wk_terry_t' on table 'wk_terry_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_rpr_addnewpe_t' on table 'rpr_addnewpe_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'PK_fcst_audit_trail_hist' on table 'fcst_audit_trail_hist' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_fcst_prod_hist_t' on table 'fcst_prod_hist_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_setup_pgt_t_t' on table 'setup_pgt_t_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'PK_new_samples_mthly_fcst' on table 'new_samples_mthly_fcst' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_res_prod_t' on table 'res_prod_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_load_budget_forecast_pgt_t' on table 'load_budget_forecast_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_new_user_t' on table 'new_user_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:40:08     
    Index 'pk_new_ancillary_isbn_t' on table 'new_ancillary_isbn_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_user_bk_t' on table 'user_bk_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_new_user_role_t' on table 'new_user_role_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_depo_shipments_t' on table 'depo_shipments_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_product_new' on table 'product_new' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_wk_isbnfactorsreport_t' on table 'wk_isbnfactorsreport_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_menuitems_tvk' on table 'menuitems_tvk' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_mdr_enroll_t' on table 'mdr_enroll_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_sales_class_prod_type_pct_t' on table 'sales_class_prod_type_pct_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_wk_catalog_peanc_pe_t' on table 'wk_catalog_peanc_pe_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:59     
    Index 'pk_ddpgm' on table 'dops_disc_prod_grp_mapping_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:58     
    Index 'pk_wk_pgt_t' on table 'wk_pgt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_state_t' on table 'state_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'exclude_ty_12633435652' on table 'exclude_type_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_contract__07102001161225001' on table 'contract_price_dups_vak' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'PK_phased_frees_fcst_hist' on table 'phased_frees_fcst_hist' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_vera_matcodefix_t' on table 'vera_matcodefix_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_wk_dops_isbn_rpt_t' on table 'wk_dops_isbn_rpt_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_tmp_pgmfcstreport_t' on table 'tmp_pgmfcstreport_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_wk_edit_direct' on table 'wk_edit_direct' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Index 'pk_tmp_isbnfcstreport_t' on table 'tmp_isbnfcstreport_t' has been dropped as it is a duplicate of a constraint     29-AUG-12-07:39:48     
    Catalog Demand, Schema dbo coalesced to single schema dbo_Demand     29-AUG-12-07:39:48     
  • 20. Re: Sybase to Oracle migration
    wkobargs Journeyer
    Currently Being Moderated
    Can you give me link for online migration?
    I believe that you do not read what we recommend to read. Click on the link that pnauduri gave you. Scroll down to "3. Using the Migration Wizard". That explains that the wizard guides you through an offline as well as through an online migration. There is no "link for online migration".

    About the error with the view conversion:

    You may try to increase the memory assigned to SQL Developer.
    To do so, edit the file sqldeveloper.bat located in your sqldeveloper\sqldeveloper\bin directory and increase the values associated to the
    parameters -Xmx and -Xms . For example, have a try with -Xmx1024M and -Xms512M

    But that problem might also be caused by using an old version. So it is time now that you tell us the versions that you are using. So please let us know the versions of:

    SQL Developer
    Oracle RDBMS (your target DB)
    Sybase (your source DB)

    Regards
    Wolfgang
  • 21. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    I have read it many time
  • 22. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    SQL Developer :1.5.4
    Oracle RDBMS (your target DB):11g
    Sybase (your source DB): 12
  • 23. Re: Sybase to Oracle migration
    wkobargs Journeyer
    Currently Being Moderated
    SQL Developer :1.5.4
    Oh dear! That one is ancient. I strongly suggest to go to http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html and download version 3.2. Continuing to use 1.5.4 makes no sense at all.

    Wolfgang
  • 24. Re: Sybase to Oracle migration
    Rahul_India Journeyer
    Currently Being Moderated
    I just did bro
    But why ?Wont my previous version work for migration?
  • 25. Re: Sybase to Oracle migration
    wkobargs Journeyer
    Currently Being Moderated
    The reason?

    1. SQL Developer 1.5.4 uses an old version of the Oracle JDBC driver. I forgot which one. There were many fixes in the JDBC driver in the version that is used in 3.2. And the message "String index out of range" smells like a Java issue.

    2. Many bug fixes in SQL Developer. Look e.g. at this one:

    CREATE PROC proc1 @param1 VARCHAR
    AS
    DECLARE @var1 VARCHAR
    SELECT 0 /* THIS IS FOR THE LOOP FUNCTION THAT CALLS THIS SP */
    SELECT @NROWSPROCESSED = 0,@NTOTALROWS = 0

    You won't be able to migrate the Sybase procedure above, because it contains embedded comments. That was a bug in SQL Developer, fixed in version 3.0.

    That's just one example of a fixed bug, I am sure if I would search for more then I would find more.

    Aren't that enough reasons to forget about 1.5.4 ?

    Wolfgang
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points