[email protected]> CREATE TABLE Siebel. s_org_ext_201707101650 as SELECT * from Siebel. S_org_ext where 1=2;
CREATE TABLE Siebel. s_org_ext_201707101650 as SELECT * from Siebel. S_org_ext where 1=2
*
ERROR at line 1:
Ora-00997:illegal Use of LONG datatype
The original table has a long field that cannot be copied directly from the CREATE table as, and a second table with the same structure is built according to the original table script.
Then use To_lob to convert
INSERT into s_org_ext_201707101655 (row_id, created, created_by, LAST_UPD, last_upd_by, Dcking_num, Modification_num, conflict_id, par_row_id, ACCNT_FLG, ACTIVE_FLG, BUYING_GROUP_FLG, bu_id, CG_DEDN_AUTH_FLG, CG_SVP_A_LOCK_FLG, Cg_svp_ LOCK_FLG, CG_SVP_SKIP_FLG, CL_SITE_FLG, CONTRACT_VIS_FLG, COURT_PAY_FLG, DISA_CLEANSE_FLG, EVT_LOC_FLG, External_host _FLG, FCST_ORG_FLG, FUND_ELIG_FLG, GOOD_STANDING_FLG, INCL_FLG, INT_ORG_FLG, name, ONDEMAND_SYNC_FLG, PLAN_GROUP_FLG, PROSPECT_FLG, PRTNR_FLG, PRTNR_PUBLISH_FLG, RPLCD_WTH_CMPT_FLG, SKIP_PO_CRDCHK_FLG, AGENCY_FLG, BRANCH_FLG, Briefing_ Layout, CLIENT_FLG, Enterprise_flag, FACILITY_FLG, INVSTR_FLG, lang_id, PR_REP_DNRM_FLG, PR_REP_MANL_FLG, Pr_rep_sys_ FLG, Agency_inactive_dt, Asgn_dt, ASGN_USR_EXCLD_FLG, Asset_amt, Atm_count, Avail_credit_amt, BILL_PBLSHR_FLG, Bo_ Ordqry_end_dt, Bo_ordqry_start_dt, Cg_cons_end_offset, Cg_cons_strtoffset, Cg_prmo_end_offset, Cg_ship_end_offset, Cg_ship_strtoffset, Cg_svp_upper_lock, Chnl_annl_sales, Chnl_qtr_saLes, Chnl_sales_growth, Close_dt, CMPT_FLG, Credit_days, Credit_score, CUR_YR_BK, CUR_YR_BL, Cust_end_dt, Cust_since_dt , DB_LAST_UPD, Dedup_dataclnsd_dt, Dedup_key_upd_dt, Dedup_last_mtch_dt, DISA_ALL_MAILS_FLG, Division_count, Eai_sync _dt, Emp_count, Evt_hotel_std_rt, Exch_dt, FUL_CENTER_FLG, GSA_FLG, Hard_to_reach, Hist_sls_exch_dt, Hist_sls_vol, Hshldhd_age, Hshld_inc, Hshld_kidage, Hshld_kids, Hshld_size, Last_call_dt, Last_mgr_revw_dt, Latitude, longitude, misc _FLG, Num_hshlds, Num_of_beds, Num_regs, Ori_ts, PARTNER_FLG, Po_crdchk_thrsh, Po_crdchk_thrsh_dt, Po_pay_exch_dt, Po_ PAY_FLG, Po_pay_max_amt, PRI_YR_BK, PRI_YR_BL, PROCED_FLG, Prtnrshp_start_dt, Prtnr_sales_rank, Ptntl_sls_exch_dt, Ptntl_sls_vol, REFERENCE_CUST_FLG, Reference_start_dt, sales_emp_cnt, service_emp_cnt, SRV_PROVDR_FLG, Stat_chg_dt, Store_size, SUPPRESS_SHARE_FLG, SUPRESS_CALL_FLG, TAX_EXEMPT_FLG, Trgt_impl_dt, Visit_frequency, WEEKLY_ACV, Aba_ Number, accnt_pr_cmpt_id, ACCNT_TYPE_CD, Adl_status, Agency_indicatoR, Agency_nibrs_ind, aia_integ1_id, aia_integ_id, Alias_name, Alt_email_addr, ALT_EMAIL_LOC_CD, Ans_srvc_ph_num, APPROVAL_STATUS_CD, Asgn_ph_ac, ASGN_PH_CC, Bank_code, BASE_CURCY_CD, BO_CUST_GRP_CD, BRANCH_TYPE_CD, Call_frequency, Cc_txnproc_ac_num, cc_txnproc_vndr_id, Cg_prmo_strt_day, Cg_svp_status, Channel_type, Cmpny_name, CORE_CITY_CD, Corp_ Cmpny_name, Corp_stock_symbol, Country_division, Country_region, Country_template, covered_by, Creator_login, Cross_ Street, curr_pri_lst_id, curr_rate_lst_id, cur_srv_addr_id, CUR_YR_BK_CURCY_CD, CUR_YR_BL_CURCY_CD, CUST_STAT_CD, db_ LAST_UPD_SRC, Dedup_token, Dept_num, Desc_text, DFLT_SHIP_PRIO_CD, DIST_CHANNEL_CD, Division, DIVN_CD, Divn_terr_hier_ ID, DIVN_TYPE_CD, dom_ult_duns_num, Duns_num, Eai_error_text, EAI_EXPRT_STAT_CD, Email_addr, EMAIL_LOC_CD, EVT_LOC_CD, exec_spnsr_pstn_id, EXPERTISE_CD, fbi_field_off_id, fin_resp_con_id, frd_owner_emp_id, FRGHT_TERMS_CD, Frght_terms_ Info, Furi_cmpny_name, General_ledger, Glblult_duns_num, GRWTH_STRTGy_desc, HIST_SLS_CURCY_CD, HSHLDHD_GEN_CD, HSHLDHD_OCC_CD, HSHLD_ETHN_CD, HSHLD_LOC_CD, Img_src_path, Impl_desc, Impl _STAGE_CD, integration_id, Judicial_district, last_revw_mgr_id, Legal_form_cd, loc, Location_level, LOY_PARTNER_CD, Main_email_addr, Main_fax_ph_num, Main_ph_num, Manager_name, MARKET_CLASS_CD, MARKET_TYPE_CD, master_ou_id, Name_1, OD _last_upd_by, ORI_CD, Ou_num, Ou_num_1, OU_TYPE_CD, OWNERSHIP_TYPE_CD, par_bu_id, par_divn_id, Par_duns_num, par_ou_id, Password, payment_term_id, PAY_TYPE_CD, POPULATION_GRP_CD, PO_PAY_CURCY_CD, PREF_CARR_PRIO_CD, PREF_COMM_METH_CD, PREF_SHIP_CARR_CD, PRIVACY_CD, PRI_GRP_CD, PRI_YR_BK_CURCY_CD, PRI_YR_BL_CURCY_CD, PROD_DIST_CD, PRTNR_CERT_CD, Prtnr _CTGRY_CD, prtnr_org_int_id, PRTNR_TYPE_CD, pr_addr_id, pr_addr_per_id, pr_agree_id, pr_bill_prfl_id, pr_bl_addr_id, pr_bl_ou_id, pr_bl_per_id, pr_competitor_id, pr_con_id, pr_co_mstr_id, pr_crdt_area_id, pr_discnt_id, Pr_eai_sls_area _id, pr_emp_rel_id, pr_emp_terr_id, pr_fulfl_invloc_id, Pr_geo_ID, pr_implsvc_vndr_id, pr_indust_id, pr_labor_rate_id, pr_logo_id, pr_med_proc_id, pr_mgr_postn_id, pr_mkt_seg_id, PR _org_pay_prfl_id, pr_org_trgt_mkt_id, pr_ou_type_id, pr_pay_ou_id, pr_phone_id, pr_postn_id, pr_prfl_id, Pr_pri_lst_ ID, pr_prod_id, pr_prod_ln_id, pr_prtnr_ou_id, pr_prtnr_prog_id, pr_prtnr_tier_id, pr_prtnr_type_id, Pr_ptshp_mktseg_ ID, Pr_rep_asgn_type, pr_security_id, pr_ship_addr_id, pr_ship_ou_id, pr_ship_per_id, pr_situ_id, pr_specialty_id, Pr_ spec_id, pr_spl_rate_lst_id, pr_srv_agree_id, pr_svc_postn_id, pr_syn_id, pr_territory_id, pr_terr_id, pr_vehicle_id, PTNTL_SLS_CURCY_CD, rating, Region, region_id, rel_id, Rel_name, REVENUE_CLASS_CD, Rlzd_roi_desc, route, Rte_to_mkt_ Desc, RULE_ATTRIB1, Rule_attrib2, SALES_ORG_CD, SLS_DIST_CD, Staff, STATE_ABBRE_CD, STATUS_CD, STAT_REASON_CD, Survey_ TYPE_CD, SVC_CVRG_STAT_CD, Tax_exempt_num, TAX_GROUP_CD, Tax_iden_num, tax_list_id, Thmbnl_imgsrc_path, Ticker_sym, Tlr_intg_msg, TLR_INTG_RET_CD, URL, Vat_regn_num, Visit_period, Wtr_swift_code, directions, X_apex_account_group, X_apex_account_group_two, X_apex_account_status, X_apex_company_ Model, X_apex_cut_account_type, X_apex_invoice_type, X_apex_pay_condition, X_apex_pay_method, X_apex_price_process, X_apex_sales_channel, X_apex_sales_group, X_apex_tax_type, x_apex_trade_condition
)
Select row_id, created, created_by, LAST_UPD, last_upd_by, Dcking_num, Modification_num, conflict_id, par_row_id, Accnt_ FLG, ACTIVE_FLG, BUYING_GROUP_FLG, bu_id, CG_DEDN_AUTH_FLG, CG_SVP_A_LOCK_FLG, CG_SVP_LOCK_FLG, CG_SVP_SKIP_FLG, Cl_ SITE_FLG, CONTRACT_VIS_FLG, COURT_PAY_FLG, DISA_CLEANSE_FLG, EVT_LOC_FLG, EXTERNAL_HOST_FLG, FCST_ORG_FLG, Fund_elig_ FLG, GOOD_STANDING_FLG, INCL_FLG, INT_ORG_FLG, name, ONDEMAND_SYNC_FLG, PLAN_GROUP_FLG, PROSPECT_FLG, PRTNR_FLG, Prtnr_ PUBLISH_FLG, RPLCD_WTH_CMPT_FLG, SKIP_PO_CRDCHK_FLG, AGENCY_FLG, BRANCH_FLG, Briefing_layout, CLIENT_FLG, Enterprise_ Flag, FACILITY_FLG, INVSTR_FLG, lang_id, PR_REP_DNRM_FLG, PR_REP_MANL_FLG, PR_REP_SYS_FLG, Agency_inactive_dt, Asgn_dt , ASGN_USR_EXCLD_FLG, Asset_amt, Atm_count, Avail_credit_amt, BILL_PBLSHR_FLG, Bo_ordqry_end_dt, Bo_ordqry_start_dt, Cg_cons_end_offset, Cg_cons_strtoffset, Cg_prmo_end_offset, Cg_ship_end_offset, Cg_ship_strtoffset, Cg_svp_upper_ Lock, Chnl_annl_sales, Chnl_qtr_sales, Chnl_sales_growth, close_dt, CMPT_FLG, Credit_days, Credit_score, CUR_YR_BK, CUR_YR_BL, Cust_end_dt, Cust_since_dt, DB_LAST_UPD, Dedup_ Dataclnsd_dt, Dedup_key_upd_dt, Dedup_last_mtch_dt, DISA_ALL_MAILS_FLG, Division_count, Eai_sync_dt, Emp_count, Evt_ Hotel_std_rt, Exch_dt, FUL_CENTER_FLG, GSA_FLG, Hard_to_reach, Hist_sls_exch_dt, Hist_sls_vol, Hshldhd_age, Hshld_inc, Hshld_kidage, Hshld_kids, Hshld_size, Last_call_dt, Last_mgr_revw_dt, latitude, longitude, MISC_FLG, Num_hshlds, num_of _beds, Num_regs, Ori_ts, PARTNER_FLG, Po_crdchk_thrsh, Po_crdchk_thrsh_dt, Po_pay_exch_dt, PO_PAY_FLG, Po_pay_max_amt, PRI_YR_BK, PRI_YR_BL, PROCED_FLG, Prtnrshp_start_dt, Prtnr_sales_rank, Ptntl_sls_exch_dt, Ptntl_sls_vol, Reference_ CUST_FLG, Reference_start_dt, sales_emp_cnt, service_emp_cnt, SRV_PROVDR_FLG, Stat_chg_dt, Store_size, Suppress_share _FLG, SUPRESS_CALL_FLG, TAX_EXEMPT_FLG, Trgt_impl_dt, Visit_frequency, WEEKLY_ACV, Aba_number, accnt_pr_cmpt_id, accnt _TYPE_CD, Adl_status, Agency_indicator, Agency_nibrs_ind, Aia_integ1_id, aia_integ_id, Alias_name, Alt_email_addr, ALT_EMAIL_LOC_CD, Ans_srvc_ph_num, APPROVAL_STATUS_CD, Asgn_ph_ac, ASGN_PH_CC, Bank_code, BASE_CURCY_CD, BO_CUST_GRP_CD, BRANCH_TYPE_CD, Call_frequency, Cc_txnproc_ac_num, CC_TXNPROC_ vndr_id, Cg_prmo_strt_day, Cg_svp_status, Channel_type, Cmpny_name, CORE_CITY_CD, Corp_cmpny_name, Corp_stock_symbol, Country_division, Country_region, Country_template, covered_by, Creator_login, Cross_street, curr_pri_lst_id, Curr_ rate_lst_id, cur_srv_addr_id, CUR_YR_BK_CURCY_CD, CUR_YR_BL_CURCY_CD, CUST_STAT_CD, DB_LAST_UPD_SRC, Dedup_token, Dept_num, Desc_text, DFLT_SHIP_PRIO_CD, DIST_CHANNEL_CD, Division, DIVN_CD, divn_terr_hier_id, DIVN_TYPE_CD, Dom_ult_ Duns_num, Duns_num, Eai_error_text, EAI_EXPRT_STAT_CD, Email_addr, EMAIL_LOC_CD, EVT_LOC_CD, exec_spnsr_pstn_id, EXPERTISE_CD, fbi_field_off_id, fin_resp_con_id, frd_owner_emp_id, FRGHT_TERMS_CD, Frght_terms_info, Furi_cmpny_name , General_ledger, Glblult_duns_num, Grwth_strtgy_desc, Hist_sls_curcy_cd, HSHLDHD_GEN_CD, HSHLDHD_OCC_CD, HSHLD_ETHN_CD, HSHLD_LOC_CD, Img_src_path, Impl_desc, IMPL_STAGE_CD, integration_id, Judicial_district, last_revw_mgr_id, Legal_form_cd, loc, Location_level, LOY_PARTNER_CD, Main_email_addr, main_fax_ph _num, Main_ph_num, Manager_name, MARKET_CLASS_CD, MARKET_TYPE_CD, master_ou_id, Name_1, od_last_upd_by, ORI_CD, Ou_num, Ou_num_1, OU_TYPE_CD, OWNERSHIP_TYPE_CD, par_bu_id, par_divn_id, Par_duns_num, par_ou_id, password, payment_term_id, PAY_TYPE_CD, POPULATION_GRP_CD, PO_PAY_CURCY_CD, PREF_CARR_PRIO_CD, PREF_COMM_METH_CD, PREF_SHIP_CARR_CD, PRIVACY_CD , PRI_GRP_CD, PRI_YR_BK_CURCY_CD, PRI_YR_BL_CURCY_CD, PROD_DIST_CD, PRTNR_CERT_CD, PRTNR_CTGRY_CD, prtnr_org_int_id, PRTNR_TYPE_CD, pr_addr_id, pr_addr_per_id, pr_agree_id, pr_bill_prfl_id, pr_bl_addr_id, pr_bl_ou_id, pr_bl_per_id, Pr_ competitor_id, pr_con_id, pr_co_mstr_id, pr_crdt_area_id, pr_discnt_id, pr_eai_sls_area_id, pr_emp_rel_id, Pr_emp_ terr_id, pr_fulfl_invloc_id, pr_geo_id, pr_implsvc_vndr_id, pr_indust_id, pr_labor_rate_id, pr_logo_id, pr_med_proc_id, pr_mgr_postn_id, pr_mkt_seg_id, pr_org_pay_prfl_id, Pr_org_ trgt_mkt_id, pr_ou_type_id, pr_pay_ou_id, pr_phone_id, pr_postn_id, pr_prfl_id, pr_pri_lst_id, pr_prod_id, Pr_prod_ln_ ID, pr_prtnr_ou_id, pr_prtnr_prog_id, pr_prtnr_tier_id, pr_prtnr_type_id, pr_ptshp_mktseg_id, Pr_rep_asgn_type, Pr_ security_id, pr_ship_addr_id, pr_ship_ou_id, pr_ship_per_id, pr_situ_id, pr_specialty_id, pr_spec_id, Pr_spl_rate_lst _id, pr_srv_agree_id, pr_svc_postn_id, pr_syn_id, pr_territory_id, pr_terr_id, pr_vehicle_id, PTNTL_SLS_CURCY_CD, Rating, Region, region_id, rel_id, Rel_name, REVENUE_CLASS_CD, Rlzd_roi_desc, Route, Rte_to_mkt_desc, rule_attrib1, rule _attrib2, SALES_ORG_CD, SLS_DIST_CD, Staff, STATE_ABBRE_CD, STATUS_CD, STAT_REASON_CD, SURVEY_TYPE_CD, Svc_cvrg_stat_ CD, Tax_exempt_num, TAX_GROUP_CD, Tax_iden_num, tax_list_id, Thmbnl_imgsrc_path, Ticker_sym, Tlr_intg_msg, Tlr_intg_ RET_CD, URL, vat_regn_num, Visit_period, Wtr_swift_code, To_lob (Directions), X_apex_account_group, X_apex_account_group_two, X_apex_account_status, X_apex_company_model, X_apex_cut_ Account_type, X_apex_invoice_type, X_apex_pay_condition, X_apex_pay_method, x_apex_price_process, X_apex_sales_ Channel, X_apex_sales_group, X_apex_tax_type, x_apex_trade_condition
From S_org_ext;
The oracle--table has a long type copy or derivative report ORA00990