inspectdb on different Oracle schemas

163 views
Skip to first unread message

Shekar Tippur

unread,
May 6, 2015, 3:42:38 AM5/6/15
to django...@googlegroups.com


Hello,

Is there a way to run inspactdb on different schemas?

I have around 3 schemas and when I run inspectdb, I get details from just 1 schema.

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.oracle',
'NAME': '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))', #the name for the entry in tnsnames.ora
'USER': 'auth',
'PASSWORD': 'ABCD',
}
}

I tried adding another section to this setup but I am not sure how to reference it.

- Shekar

Stephen J. Butler

unread,
May 6, 2015, 1:15:25 PM5/6/15
to django...@googlegroups.com
Yes, I've done this with a schema from a vendor app I wanted to read.

Define additional database aliases, one per schema, and then when
running inspectdb use the "--database" parameter with the alias name.
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/f8e84187-74eb-48d2-9c1d-da62cb1ffc45%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages