id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
12529	manage.py syncdb doesn't check tables by using mangled names with Oracle backend	Jani Tiainen	Mariusz Felisiak	"With Oracle syncdb doesn't use mangled names when comparing tablenames to ones existing in database thus trying to create tables that already exists. This leads to

{{{
Creating table ssp_service_category_translation
Traceback (most recent call last):
  File ""./manage.py"", line 19, in <module>
    execute_manager(settings)
  File ""../../django-trunk/django/core/management/__init__.py"", line 439, in execute_manager
    utility.execute()
  File ""../../django-trunk/django/core/management/__init__.py"", line 380, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""../../django-trunk/django/core/management/base.py"", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File ""../../django-trunk/django/core/management/base.py"", line 222, in execute
    output = self.handle(*args, **options)
  File ""../../django-trunk/django/core/management/base.py"", line 351, in handle
    return self.handle_noargs(**options)
  File ""../../django-trunk/django/core/management/commands/syncdb.py"", line 91, in handle_noargs
    cursor.execute(statement)
  File ""../../django-trunk/django/db/backends/util.py"", line 19, in execute
    return self.cursor.execute(sql, params)
  File ""../../django-trunk/django/db/backends/oracle/base.py"", line 487, in execute
    raise e
cx_Oracle.DatabaseError: ORA-00955: name is already used by an existing object
}}}

Root cause for this is using connection.introspection.table_name_converter() in syncdb main loop which in case of oracle returns just lowercase name and not properly mangled name that would match existing table in database.
"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	syncdb oracle inspectdb		Accepted	1	0	0	0	0	0