krovomi | Bonjour,
J'ai une question : Est-il possible de crée une table en prenant plusieurs champs de plusieurs tables, genre :
Code :
- CREATE TABLE tmp_export_profils_delta_port
- AS
- (
- SELECT tmp4.name_prefix,
- tmp4.cfa,
- tmp4.pin_number,
- tmp4.name_suffix,
- tmp4.dob,
- tmp4.verified_flag,
- tmp4.start_travel_date,
- tmp4.end_travel_date,
- tmp4.home_appart_code,
- tmp4.home_city_code,
- tmp4.pin_mailer_sent,
- tmp4.is_arranger_flag,
- tmp4.vendor_group,
- tmp4.vendor_code,
- tmp4.membership_number,
- tmp4.address_type_code,
- tmp4.first_address_line_desc,
- tmp4.second_address_line_desc,
- tmp4.state_province_code,
- tmp4.state_province_name,
- tmp4.country_name,
- tmp4.traveler_corp_discount_number,
- tmp4.vendor_discount_discgroup,
- tmp4.vendor_code1,
- tmp4.expiration_date1,
- tmp2.credit_card_vendor_code,
- tmp2.credit_card_description,
- tmp2.credit_card_number,
- tmp2.expiration_date,
- tmp2.preferred_hotel_guarantee_flag,
- tmp2.preferred_for_air_flag,
- tmp2.preferred_car_guarantee_flag,
- tmp3.personal_email,
- tmp3.alternate_email,
- tmp3.country,
- --tmp3.state_province_code,
- tmp3.state,
- tmp3.code_entite,
- tmp3.matricule,
- tmp3.matricule1,
- tmp3.secretaire,
- tmp1.BUS_TRAVELER_ROLLUP_TYPE_DESC,
- tmp1.ARRANGER_FIRST_NAME,
- tmp1.ARRANGER_LAST_NAME,
- tmp1.ARRANGER_PHONE,
- tmp1.ARRANGER_EMAIL,
- tmp1.RECEIVE_E_INVOICE_FLAG,
- tmp1.EMAIL_TYPE,
- tmp1.PRIVACY_OPTION_ACCEPTANCE_FLAG,
- tmp1.CLIENT_ORG_UNIT_ID
-
- from tmp_export_profils_portrait4 tmp4, tmp_export_profils_portrait3 tmp3, tmp_export_profils_portrait2 tmp2,
- tmp_export_profils_portrait tmp1);
- commit;
|
Mais là j'ai une erreur oracle => ORA-01652
ou alors dupliquer une table et faire un alter table du style :
Code :
- ALTER TABLE tmp_export_profils_delta_port
- ADD (select tmp3.personal_email FROM tmp_export_profils_portrait3);
|
Même si je sais que cette requête est fausse, mais c'est plus dans l'esprit.
Merci |
