Following your advice I did the following: 1. dumpdata while connected to MySQL: python manage.py dumpdata > fixture.json 2. Created a new Oracle user with an empty schema and switch the db connection to Oracle (didn't do syncdb) 3. loaddata to Oracle with: python manage.py loaddata fixture.json
I don't get an error when using loaddata but when running the server and navigating to localhost:8000 I'm getting: ORA-00942: table or view does not exist Is it possible that Oracle doesn't create the tables when loading the fixtures without syncdb? On Wed, Apr 21, 2010 at 9:41 PM, Tom Evans <tevans...@googlemail.com> wrote: > 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<django-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- 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.
