sequence dans un insert all?!

bonjour tout le monde,

voila j'ai une requete a faire qui consiste a transférer des données d'une base non-relationelle a une relationelle en une seule requete. j'ai donc utilisé un insert all et des sequences pour les identifiants comme il est demandé.

ma requete est :

Code:

---

1 2 3 4 5 6 7 8 9

INSERT ALL INTO t_abonnemnts (abonnemnt_id, titre, reduction_pct, reduction_we_pct, prix)   INTO t_wagons (wagon_id, classe_pct, classe, nbr_place)   SELECT seq_t_abonnemnts.nextval, titre, reduction_pct, reduction_we_pct, prix, seq_t_wagons.nextval, classe_pct, classe, nbr_place   FROM olvoyage_table; --la table non-relationelle

---

l'erreur retournée est "ORA-02287 : le numero de sequence non autorsié ici"

pourriez vous m'aidez s'il vous plait merci beacoup, :D

Restrictions on Multitable Inserts Multitable inserts are subject to the following restrictions:

Citation:

---

You can perform multitable inserts only on tables, not on views or materialized views.

You cannot perform a multitable insert into a remote table.

You cannot specify a table collection expression when performing a multitable insert.

In a multitable insert, all of the insert_into_clauses cannot combine to specify more than 999 target columns.

Multitable inserts are not parallelized if any target table is index organized or if any target table has a bitmap index defined on it.

Plan stability is not supported for multitable insert statements.

The subquery of the multitable insert statement cannot use a sequence.

---