Discussion:
Django Admin DB Error only when trying to delete an inserted record delete.
G Z
2014-07-16 21:14:35 UTC
Permalink
So I'm still running in to issues using a prexisting database, ive worked
out almost all of the issues except one.
You can now update, and add new records through the admin panel, but after
that you can't delete them.

The Models file was generated by djangos inspect Db. I'm not sure why but I
can't delete.

MODELS.PY

# This is an auto-generated Django model module.
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# * Remove `managed = False` lines if you wish to allow Django to create
and delete the table
# Feel free to rename the models, but don't rename db_table values or
field names.
#
# Also note: You'll have to insert the output of 'django-admin.py
sqlcustom [appname]'
# into your database.
from __future__ import unicode_literals
from django.db import models
from django.core.exceptions import ValidationError
from django.contrib.auth.models import User
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(unique=True, max_length=160, blank=True)
managed = False
db_table = 'auth_group'
id = models.IntegerField(primary_key=True, editable=False)
group = models.ForeignKey(AuthGroup)
permission = models.ForeignKey('AuthPermission')
managed = False
db_table = 'auth_group_permissions'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=100, blank=True)
content_type = models.ForeignKey('DjangoContentType')
codename = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'auth_permission'
id = models.IntegerField(primary_key=True, editable=False)
password = models.CharField(max_length=256, blank=True)
last_login = models.DateTimeField()
is_superuser = models.BooleanField()
username = models.CharField(unique=True, max_length=60, blank=True)
first_name = models.CharField(max_length=60, blank=True)
last_name = models.CharField(max_length=60, blank=True)
email = models.CharField(max_length=150, blank=True)
is_staff = models.BooleanField()
is_active = models.BooleanField()
date_joined = models.DateTimeField()
managed = False
db_table = 'auth_user'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
group = models.ForeignKey(AuthGroup)
managed = False
db_table = 'auth_user_groups'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
permission = models.ForeignKey(AuthPermission)
managed = False
db_table = 'auth_user_user_permissions'
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
sal = models.FloatField(blank=True, null=True)
comm = models.FloatField(blank=True, null=True)
managed = False
db_table = 'bonus'
cidr_allocation_id = models.BigIntegerField(primary_key=True,
editable=False)
cidr = models.CharField(max_length=40)
allocation_name = models.CharField(max_length=30)
allocation_date = models.DateField()
deallocation_date = models.DateField(blank=True, null=True)
allocation_source = models.CharField(max_length=30)
public_address = models.CharField(max_length=1)
managed = False
db_table = 'cidr_allocations'
raise ValidationError('Please enter a Y or N')
return self.allocation_name
customer_id = models.BigIntegerField(primary_key=True, editable=False)
customer_name = models.CharField(max_length=30)
inactive = models.CharField(max_length=1)
managed = False
db_table = 'customers'
return self.customer_name
raise ValidationError('Please enter a Y or N')
datacenter_id = models.BigIntegerField(primary_key=True,
editable=False)
vcenter = models.ForeignKey('Vcenters')
datacenter_mor = models.CharField(max_length=20)
datacenter_name = models.CharField(max_length=30)
managed = False
db_table = 'datacenters'
datastore_id = models.BigIntegerField(primary_key=True, editable=False)
datastore_mor = models.CharField(max_length=20)
storage_tier = models.ForeignKey('StorageTiers')
datastore_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
type = models.CharField(max_length=10)
managed = False
db_table = 'datastores'
deptno = models.IntegerField(blank=True, null=True)
dname = models.CharField(max_length=14, blank=True)
loc = models.CharField(max_length=13, blank=True)
managed = False
db_table = 'dept'
id = models.IntegerField(primary_key=True, editable=False)
action_time = models.DateTimeField()
user = models.ForeignKey(AuthUser)
content_type = models.ForeignKey('DjangoContentType', blank=True,
null=True)
object_id = models.TextField(blank=True)
object_repr = models.CharField(max_length=400, blank=True)
action_flag = models.IntegerField()
change_message = models.TextField(blank=True)
managed = False
db_table = 'django_admin_log'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=200, blank=True)
app_label = models.CharField(max_length=200, blank=True)
model = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'django_content_type'
session_key = models.CharField(primary_key=True, max_length=80)
session_data = models.TextField(blank=True)
expire_date = models.DateTimeField()
managed = False
db_table = 'django_session'
empno = models.IntegerField()
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
mgr = models.IntegerField(blank=True, null=True)
hiredate = models.DateField(blank=True, null=True)
sal = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
comm = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
deptno = models.IntegerField(blank=True, null=True)
managed = False
db_table = 'emp'
esxi_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license_type = models.CharField(max_length=40)
managed = False
db_table = 'esxi_licenses'
guest_os_id = models.FloatField(primary_key=True, editable=False)
guest_os = models.CharField(unique=True, max_length=60)
managed = False
db_table = 'guest_os'
host_id = models.BigIntegerField(primary_key=True, editable=False)
host_mor = models.CharField(unique=True, max_length=20)
esxi_license = models.ForeignKey(EsxiLicenses)
datacenter = models.ForeignKey(Datacenters)
host_ip_address = models.TextField(unique=True) # This field type is a
guess.
mfgr = models.CharField(max_length=40)
model = models.CharField(max_length=40)
cores = models.BigIntegerField()
core_ghz = models.DecimalField(max_digits=8, decimal_places=5)
processor_type = models.CharField(max_length=60)
memory_gb = models.DecimalField(max_digits=9, decimal_places=5)
managed = False
db_table = 'hosts'
vcenter_uuid = models.CharField(max_length=50)
vm_mor = models.CharField(max_length=20)
datastore_mor = models.CharField(max_length=20)
datetime = models.DateTimeField()
riops = models.FloatField()
wiops = models.FloatField()
managed = False
db_table = 'iops'
datetime = models.DateTimeField()
bytes_sent = models.BigIntegerField()
bytes_received = models.BigIntegerField()
ip_address = models.ForeignKey('IpAddresses')
load_sequence = models.BigIntegerField()
managed = False
db_table = 'ip_address_usage_histories'
ip_address_id = models.BigIntegerField(primary_key=True,
editable=False)
ip_address = models.TextField(unique=True, blank=True) # This field
type is a guess.
cidr_allocation = models.ForeignKey(CidrAllocations)
managed = False
db_table = 'ip_addresses'
id = models.IntegerField(primary_key=True, editable=False)
license = models.ForeignKey('Licenses')
vm_license = models.ForeignKey('VmLicenses')
managed = False
db_table = 'license_assignments'
license_authority_id = models.FloatField(primary_key=True,
editable=False)
licensing_authority = models.CharField(max_length=30)
managed = False
db_table = 'license_authorities'
return self.licensing_authority
license_id = models.FloatField(primary_key=True, editable=False)
license_authority_id = models.FloatField()
product = models.CharField(max_length=30)
managed = False
db_table = 'licenses'
return self.product
managed_entity_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=80)
managed_entity_mor = models.CharField(max_length=20)
vcenter = models.ForeignKey('Vcenters')
parent_mor = models.CharField(max_length=20, blank=True)
vm = models.ForeignKey('Vms', blank=True, null=True)
type = models.CharField(max_length=30)
managed = False
db_table = 'managed_entities'
nas_device_id = models.BigIntegerField(primary_key=True,
editable=False)
device_name = models.CharField(max_length=20)
ip_address = models.TextField() # This field type is a guess.
storage_tier = models.ForeignKey('StorageTiers')
managed = False
db_table = 'nas_devices'
return self.device_name
vm_nas_usage_history_id = models.BigIntegerField()
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device_id = models.BigIntegerField()
customer_id = models.BigIntegerField()
managed = False
db_table = 'nas_usage'
datetime = models.DateTimeField()
ip_address = models.CharField(max_length=39)
sbytes = models.FloatField()
rbytes = models.FloatField()
managed = False
db_table = 'netflows'
network_device = models.ForeignKey('NetworkDevices')
ip_address = models.ForeignKey(IpAddresses, unique=True)
managed = False
db_table = 'network_device_ip_addresses'
network_device = models.ForeignKey('NetworkDevices')
mac_address = models.CharField(max_length=17)
datacenter = models.ForeignKey(Datacenters)
managed = False
db_table = 'network_device_mac_addresses'
return self.mac_address
network_device_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=20)
management_ip_address = models.BinaryField() # This field type is a
guess.
snmp_version = models.BooleanField()
snmp_username = models.CharField(max_length=20)
snmp_security = models.CharField(max_length=12)
snmp_password = models.CharField(max_length=20)
arp_cache_oid = models.CharField(max_length=40)
snmp_priv_passphrase = models.CharField(max_length=20, blank=True)
snmp_auth_protocol = models.CharField(max_length=3, blank=True)
snmp_priv_protocol = models.CharField(max_length=3, blank=True)
managed = False
db_table = 'network_devices'
return self.name
snmp_security = set(['AuthPriv', 'NoAuthNoPriv', 'AuthNoPriv'])
auth_protocols = set(['MD5', 'SHA'])
priv_protocols = set(['AES', 'DES'])
raise ValidationError('Please enter a 1, 2 or 3')
raise ValidationError('Please enter AuthPriv, NoAuthNoPriv or
AuthNoPriv')
raise ValidationError('Please enter MD5 or SHA')
raise ValidationError('Please enter AES or DES')
id = models.IntegerField(primary_key=True, editable=False)
poll = models.ForeignKey('PollsPoll')
choice_text = models.CharField(max_length=400, blank=True)
votes = models.IntegerField()
managed = False
db_table = 'polls_choice'
id = models.IntegerField(primary_key=True, editable=False)
question = models.CharField(max_length=400, blank=True)
pub_date = models.DateTimeField()
managed = False
db_table = 'polls_poll'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser, unique=True)
website = models.CharField(max_length=400, blank=True)
picture = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'portal_userprofile'
id = models.IntegerField(primary_key=True, editable=False)
vm_license = models.ForeignKey('VmLicenses')
license = models.ForeignKey(Licenses)
managed = False
db_table = 'portal_vm_assignments'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'report_compute'
resource_pool_id = models.BigIntegerField(primary_key=True,
editable=False)
resource_pool_mor = models.CharField(unique=True, max_length=20)
resource_pool_name = models.CharField(max_length=30)
cpu_ghz_reservation = models.DecimalField(max_digits=8,
decimal_places=5, blank=True, null=True)
cpu_ghz_limit = models.DecimalField(max_digits=8, decimal_places=5,
blank=True, null=True)
cpu_reservation_expandable = models.CharField(max_length=1)
ram_gb_reservation = models.DecimalField(max_digits=9,
decimal_places=5, blank=True, null=True)
ram_gb_limit = models.DecimalField(max_digits=9, decimal_places=5,
blank=True, null=True)
ram_reservation_expandable = models.CharField(max_length=1)
cpu_unlimited = models.CharField(max_length=1)
ram_unlimited = models.CharField(max_length=1)
datacenter_id = models.BigIntegerField()
managed = False
db_table = 'resource_pools'
grade = models.FloatField(blank=True, null=True)
losal = models.FloatField(blank=True, null=True)
hisal = models.FloatField(blank=True, null=True)
managed = False
db_table = 'salgrade'
storage_tier_id = models.BigIntegerField(primary_key=True,
editable=False)
tier_name = models.CharField(max_length=20)
reserved_iops = models.BigIntegerField()
price_per_gb = models.DecimalField(max_digits=7, decimal_places=4,
blank=True, null=True)
managed = False
db_table = 'storage_tiers'
return self.tier_name
ip_address = models.CharField(max_length=17, blank=True)
gigabytes_sent = models.FloatField(blank=True, null=True)
gigabytes_received = models.FloatField(blank=True, null=True)
managed = False
db_table = 'unallocated_ips'
vcenter_id = models.BigIntegerField(primary_key=True, editable=False)
vcenter_ip_address = models.TextField() # This field type is a guess.
vcenter_uuid = models.CharField(max_length=50)
username = models.CharField(max_length=20)
password = models.CharField(max_length=20)
name = models.CharField(max_length=30)
managed = False
db_table = 'vcenters'
return self.name
vm_backup_storage_id = models.BigIntegerField(primary_key=True,
editable=False)
customer = models.ForeignKey(Customers)
datetime = models.DateField()
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_backup_storage'
vm_compute_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
power_state = models.BooleanField()
cpu_core_allocation = models.DecimalField(max_digits=8,
decimal_places=5)
cpu_ghz_reservation = models.DecimalField(max_digits=8,
decimal_places=5)
cpu_ghz_limit = models.DecimalField(max_digits=8, decimal_places=5)
ram_gb_allocation = models.DecimalField(max_digits=9, decimal_places=5)
ram_gb_reservation = models.DecimalField(max_digits=9,
decimal_places=5)
ram_gb_limit = models.DecimalField(max_digits=9, decimal_places=5)
datetime = models.DateTimeField()
host = models.ForeignKey(Hosts)
esxi_license = models.ForeignKey(EsxiLicenses)
resource_pool = models.ForeignKey(ResourcePools, blank=True, null=True)
fault_tolerance = models.CharField(max_length=1)
guest_os = models.ForeignKey(GuestOs)
managed = False
db_table = 'vm_compute_histories'
vm = models.ForeignKey('Vms')
datetime = models.DateField()
cpu_ghz_hours = models.DecimalField(max_digits=13, decimal_places=5)
ram_gb_hours = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_compute_usage_histories'
vm_group_id = models.BigIntegerField(primary_key=True, editable=False)
customer = models.ForeignKey(Customers)
vm_group_name = models.CharField(max_length=30)
managed = False
db_table = 'vm_groups'
return self.vm_group_name
vm_ip_address_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
ip_address = models.ForeignKey(IpAddresses)
allocation_date = models.DateTimeField()
deallocation_date = models.DateTimeField(blank=True, null=True)
managed = False
db_table = 'vm_ip_address_histories'
vm_license_history_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
vm = models.ForeignKey('Vms')
assignment_date = models.DateField()
deassignment_date = models.DateField(blank=True, null=True)
managed = False
db_table = 'vm_license_histories'
vm_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
#license = models.ManyToManyField(Licenses)
vm = models.ForeignKey('Vms')
managed = False
db_table = 'vm_licenses'
vm_mac_address_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
mac_address = models.CharField(max_length=20)
datetime = models.DateTimeField()
datacenter_id = models.BigIntegerField()
managed = False
db_table = 'vm_mac_addresses'
vm_nas_usage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device = models.ForeignKey(NasDevices)
customer = models.ForeignKey(Customers)
managed = False
db_table = 'vm_nas_usage_histories'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'vm_paths'
vm_storage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
datastore = models.ForeignKey(Datastores)
datetime = models.DateTimeField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_storage_histories'
vm_storage_perf_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datastore_id = models.BigIntegerField()
vm_id = models.BigIntegerField()
datetime = models.DateField()
average_reads_per_sec = models.FloatField()
average_writes_per_sec = models.FloatField()
max_read_requests = models.FloatField()
max_write_requests = models.FloatField()
sum_read_requests = models.FloatField()
sum_write_requests = models.FloatField()
managed = False
db_table = 'vm_storage_perf_histories'
vm_id = models.BigIntegerField(primary_key=True, editable=False)
vm_mor = models.CharField(max_length=20)
vm_name = models.CharField(max_length=4000)
vm_group = models.ForeignKey(VmGroups)
vm_display_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
vcd_managed = models.CharField(max_length=1)
managed = False
db_table = 'vms'
return self.vm_name
user = models.OneToOneField(User)
website = models.URLField(blank=True)
picture = models.ImageField(upload_to='profile_images', blank=True)
return self.user.username
* Whenever I try to delete and entry i made it gives me the following
error:*

Exception Type:DatabaseErrorException Value:

ORA-00942: table or view does not exist



Environment:


Request Method: GET
Request URL: http://127.0.0.1:8000/admin/portal/customers/121/delete/

Django Version: 1.6.5
Python Version: 2.7.5
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'portal')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware')


Traceback:
File "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py"
in get_response
112. response = wrapped_callback(request,
*callback_args, **callback_kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
wrapper
432. return self.admin_site.admin_view(view)(*args,
**kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/views/decorators/cache.py"
in _wrapped_view_func
52. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/sites.py"
in inner
198. return view(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapper
29. return bound_func(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
bound_func
25. return func(self, *args2, **kwargs2)
File "/usr/local/lib/python2.7/dist-packages/django/db/transaction.py" in
inner
371. return func(*args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
delete_view
1457. [obj], opts, request.user, self.admin_site, using)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in get_deleted_objects
109. collector.collect(objs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in collect
160. return super(NestedObjects, self).collect(objs,
source_attr=source_attr, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/deletion.py"
in collect
196. elif sub_objs:
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
__nonzero__
100. self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
_fetch_all
857. self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
iterator
220. for row in compiler.results_iter():
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in results_iter
713. for rows in self.execute_sql(MULTI):
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in execute_sql
786. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
69. return super(CursorDebugWrapper, self).execute(sql,
params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py" in __exit__
99. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/oracle/base.py"
in execute
816. return self.cursor.execute(query,
self._param_generator(params))

Exception Type: DatabaseError at /admin/portal/customers/121/delete/
Exception Value: ORA-00942: table or view does not exist
--
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/49598d10-ce53-43a3-bae3-e09d383f4cce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
G Z
2014-07-16 22:21:46 UTC
Permalink
upon further investigation I found that inspectdb on the production
database only will output a models.py for the django tables, I need it to
output it for the entire schema like it did on the development database,
to prevent unessecary changes the premissions of the django user are
restricted could this be causing the issue?

I also know delete works on the dev database and it doesnt on the
production.

when i try to delete something from production it can't find the view or
table, but in the development it deletes it.
--
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/89959763-2f48-404b-abfe-14011a245479%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
G Z
2014-07-16 23:31:23 UTC
Permalink
here are my user objects for the two tables obviously development has more
do you think this could be causing the issue


***@hotrod:~/workspace/Django Projects/trunk/holon$ sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 16 17:26:23 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter user-name: dev/***@db1

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options


Session altered.


Session altered.

SQL> select * from user_objects;

OBJECT_NAME
SUBOBJECT_NAME
OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED
LAST_DDL_TIME TIMESTAMP STATUS T G S NAMESPACE
--------------------------------------------------------------------------------------------------------------------------------
------------------------------ ---------- --------------
------------------- ------------------ ------------------
------------------- ------- - - - ----------
EDITION_NAME
------------------------------
SYS_C0082559

590134 590134 INDEX 29-MAY-14 19:57:14
29-MAY-14 19:57:14 2014-05-29:19:57:14 VALID N Y N 4


AUTH_USER_SQ

590135 SEQUENCE 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N N N 1


AUTH_USER_TR

590136 TRIGGER 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N N N 3


DJANGO_CONTENT_TYPE

590137 590137 TABLE 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N N N 1


SYS_C0082564

590138 590138 INDEX 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N Y N 4


SYS_C0082565

590139 590139 INDEX 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N Y N 4


DJANGO_CONTENT_TYPE_SQ

590140