Hi All,

for the first time, i'm using multiple databases.  specifically, i
have 'my' data in a MySQL db (set as 'default') but also need to get
some extra info from a proprietary system with it's own Oracle DB, for
this i got a user/password with read/only privileges (only SELECT and
friends).  Of course, when i want to run the tests, i get an "error
creating the test database: ORA-01031: insufficient privileges"
message.

i guess any of these (in decreasing order of preference) would be a
solution, but i don't know how to do any of them.  (well, maybe the
last one could be done via some creative use of
development/test/deployment patching)

1: use the 'real' db.  since the user is read/only, i can't mess it
up.  i can't install test fixtures either, but there's lots of old
records that are static enough for my tests.

2: create both test DBs in the MySQL server.  of course, the SQL
semantics aren't the same; but i'm using _very_ simple queries to get
that foreign data.

3: create the test DB in another oracle server.  i guess that's the
simplest advice, but also the one i hope to avoid.

any advices?


-- 
Javier

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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.

Reply via email to