Migration Mysql -> Oracle

Version imprimable

Bonjour

Je veux faire une migration d'une BDD mysql vers Oracle en utilisant SQL developer. le problème c'est que l'opération a échoué

Voici le contenue de MigrationLog.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<log>
<record>
  <date>2013-09-04T10:14:45</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>WARNING</level>
  <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
  <message>Error ocurred during capture: ORA-01400: cannot insert NULL into ("MED"."MD_PROJECTS"."ID")
</message>
  <key>Capture.EXCEPTION</key>
  <catalog>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</catalog>
  <param>ORA-01400: cannot insert NULL into ("MED"."MD_PROJECTS"."ID")
</param>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@38bd2ad0</param>
 
</record>
<record>
  <date>2013-09-04T10:14:45</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>SEVERE</level>
  <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>
  <message>ORA-01400: cannot insert NULL into ("MED"."MD_PROJECTS"."ID")
</message>
  <param>oracle.dbtools.metadata.persistence.PersistableObject.doInsert(PersistableObject.java:246)</param>
  <param>oracle.dbtools.metadata.persistence.PersistableObject.save(PersistableObject.java:180)</param>
  <param>oracle.dbtools.migration.workbench.core.BasicMigrationStorer.storeObject(BasicMigrationStorer.java:51)</param>
  <param>oracle.dbtools.migration.capture.CaptureWorker.storeConnection(CaptureWorker.java:647)</param>
  <param>oracle.dbtools.migration.capture.CaptureWorker.runCapture(CaptureWorker.java:253)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineClassicCapture(FullMigrateTask.java:761)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:513)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:292)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:205)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:159)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)</param>
  <param>java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:166)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:515)</param>
  <param>java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)</param>
  <param>java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:166)</param>
  <param>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)</param>
  <param>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)</param>
  <param>java.lang.Thread.run(Thread.java:722)</param>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@76ac557d</param>
  <exception>
    <message>oracle.dbtools.metadata.persistence.PersistenceException: ORA-01400: cannot insert NULL into ("MED"."MD_PROJECTS"."ID")
</message>
    <frame>
      <class>oracle.dbtools.metadata.persistence.PersistableObject</class>
      <line>246</line>
    </frame>
    <frame>
      <class>oracle.dbtools.metadata.persistence.PersistableObject</class>
      <line>180</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.BasicMigrationStorer</class>
      <line>51</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.capture.CaptureWorker</class>
      <line>647</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.capture.CaptureWorker</class>
      <line>253</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>761</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>513</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>292</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>205</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>159</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTask</class>
      <line>193</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask$Sync</class>
      <line>334</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>166</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask</class>
      <line>515</line>
    </frame>
    <frame>
      <class>java.util.concurrent.Executors$RunnableAdapter</class>
      <line>471</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask$Sync</class>
      <line>334</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>166</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor</class>
      <line>1110</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor$Worker</class>
      <line>603</line>
    </frame>
    <frame>
      <class>java.lang.Thread</class>
      <line>722</line>
    </frame>
  </exception>
 
</record>
<record>
  <date>2013-09-04T10:14:45</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>WARNING</level>
  <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
  <message>Capturing PROJECT zz: FAILED : Database Migration : FAILED</message>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@5b1f08ab</param>
 
</record>

Que dois-je faire ?
merci d'avance

04/09/2013, 11h17
al1_24
Toute l'information est là :
```
ORA-01400: cannot INSERT NULL INTO ("MED"."MD_PROJECTS"."ID")
```
Il semblerait que la colonne ID de la table MD_PROJECTS ait été déclarée avec une contrainte NOT NULL et que tu essayes pourtant d'y insérer une valeur non renseignée.
A toi de régler cette incohérence.
04/09/2013, 18h23
linux user
Citation:
Envoyé par al1_24

ORA-01400: cannot INSERT NULL INTO ("MED"."MD_PROJECTS"."ID")
oui, mais j'ai choisi l'option offline, lors de la designation de la base destination.
le probleme doit être au niveau de la base de migration puisque la base source est utilisée en mode consultation, et la base destination est un fichier
ce qu'est bizarre c'est la base (les tables ) sont crées par le logiciel lui-même
est-ce leur script de creation contient des problème ?
08/09/2013, 11h09
linux user

c'est réglé, apparament il y a avait un problème lors de creation des tables par le logiciel, donc j'ai suprimé tous les tables crées par ce dernier.

est-ce que le compte utilisé pour la base destination, doit être un compte administrateur ?
le compte que j'utilise possède les droits de create, insert, delete et update sur tous les tables.
Parce que a chaque fois il m'affiche que l'opération s'est déroule correctement, mais je ne trouve rien dans la base concérnée
voici le rapport générer

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
Creating User Emulation ...
 
Error starting at line 3 in command:
CREATE USER Emulation IDENTIFIED BY Emulation DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
Error at Command Line:3 Column:37
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.
 
Error starting at line 4 in command:
GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW,  CREATE SYNONYM,CREATE PUBLIC SYNONYM  TO Emulation
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.
Creating User dest ...
 
Error starting at line 7 in command:
CREATE USER dest IDENTIFIED BY dest DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
Error at Command Line:7 Column:35
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.
 
Error starting at line 8 in command:
GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM TO dest
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.
 
Error starting at line 9 in command:
connect dest/dest
Error report:
Connection Failed
Commit

apparamment ca ne se passe pas bien, voir l'erreur ci dessous:
Code:

1 2 3 4 5 CREATE USER Emulation IDENTIFIED BY Emulation DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP Error at Command Line:3 COLUMN:37 Error report: SQL Error: ORA-01031: insufficient privileges
Il semblerai que l'utilisateur que tu utilise n'as pas le droit de créer des utilisateurs!

17/09/2013, 20h43
linux user
Citation:
Envoyé par IndianaAngus

apparamment ca ne se passe pas bien, voir l'erreur ci dessous:

Code:

1 2 3 4 5 CREATE USER Emulation IDENTIFIED BY Emulation DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP Error at Command Line:3 COLUMN:37 Error report: SQL Error: ORA-01031: insufficient privileges

Il semblerai que l'utilisateur que tu utilise n'as pas le droit de créer des utilisateurs!
j'utilise le compte pour transferer les données seulement. alors pour quoi créer un nouveau utilisateur ?
mais je pense tu as raison. je dois lui ajouter le droit de créer les utilisateurs
merci pour ton aide