On Wed, Apr 21, 2010 at 7:24 PM, pablo platt <pablo.pl...@gmail.com> wrote: > Hi > > I'm migrating a django1.1 project from MySQL to Oracle xe. > I've created fixtures in MySQL and I'm trying to load them to Oracle. > When Trying to load the fixtures I'm getting: > IntegrityError: ORA-00001: unique constraint (USER.SYS_C004253) > > select TABLE_NAME, COLUMN_NAME from user_cons_columns where CONSTRAINT_NAME > = 'SYS_C004253' > gives me: > TABLE_NAME > -------------------------------------------------------------------------------- > COLUMN_NAME > -------------------------------------------------------------------------------- > AUTH_PERMISSION > CONTENT_TYPE_ID > > AUTH_PERMISSION > CODENAME > > Any idea what can I do to fix it? >
Did you do this: create a fixture of all data in all tables in your db switch settings.py to connect to oracle run syncdb try to import your fixture ? I think the problem is that you have dumped all your data, including content types. Django creates this automatically from your models when you run syncdb, so it is attempting to place the information back in. Try truncating every table in your oracle db, and then re-importing your fixture. Cheers Tom -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
