Re: loading fixtures in Oracle gives IntegrityError because of AUTH_PERMISSION table

2010-04-21 Thread pablo platt
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

Re: loading fixtures in Oracle gives IntegrityError because of AUTH_PERMISSION table

2010-04-21 Thread Tom Evans
On Wed, Apr 21, 2010 at 7:24 PM, pablo platt 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-1: unique constraint (USER.SYS_C

Re: loading fixtures in Oracle gives IntegrityError because of AUTH_PERMISSION table

2010-04-21 Thread pablo platt
When I'm creating the fixtures without contenttypes and auth and loading the fixtures in Oracle I'm not getting an error but nothing is being loaded: python manage.py dumpdata --exclude=contenttypes --exclude=auth > fixture.json On Wed, Apr 21, 2010 at 9:24 PM, pablo platt wrote: > Hi > > I'm m

loading fixtures in Oracle gives IntegrityError because of AUTH_PERMISSION table

2010-04-21 Thread pablo platt
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-1: unique constraint (USER.SYS_C004253) select TABLE_NAME, COLUMN_NAME from user_cons_columns w