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 SEQUENCE 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N N N 1


DJANGO_CONTENT_TYPE_TR

590141 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_SESSION

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


SYS_C0082570

590145 590145 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_IL0000590142C00002$$

590144 590144 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_LOB0000590142C00002$$

590143 590143 LOB 29-MAY-14 19:57:15
29-MAY-14 19:57:15 2014-05-29:19:57:15 VALID N Y N 8


DJANGO_ADMIN_LOG_6340C63C

590146 590146 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


DJANGO_ADMIN_LOG_37EF4EB4

590147 590147 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_PERMISSION_37EF4EB4

590148 590148 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_GROUP_PERMISSIONS_5F4A8D8

590149 590149 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_GROUP_PERMISSIONS_83DF41E

590150 590150 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_USER_GROUPS_6340C63C

590151 590151 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_USER_GROUPS_5F412F9A

590152 590152 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_USER_USER_PERMISSIONSBD5D

590153 590153 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


AUTH_USER_USER_PERMISSIONS7493

590154 590154 INDEX 29-MAY-14 19:57:44
29-MAY-14 19:57:44 2014-05-29:19:57:44 VALID N N N 4


DJANGO_SESSION_B7B81F0C

590155 590155 INDEX 29-MAY-14 19:57:45
29-MAY-14 19:57:45 2014-05-29:19:57:45 VALID N N N 4


POLLS_POLL

590156 590156 TABLE 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N N N 1


SYS_C0082573

590157 590157 INDEX 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N Y N 4


POLLS_POLL_SQ

590158 SEQUENCE 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N N N 1


POLLS_POLL_TR

590159 TRIGGER 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N N N 3


POLLS_CHOICE

590160 590160 TABLE 29-MAY-14 20:13:00
29-MAY-14 20:13:03 2014-05-29:20:13:00 VALID N N N 1


SYS_C0082577

590161 590161 INDEX 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N Y N 4


POLLS_CHOICE_SQ

590162 SEQUENCE 29-MAY-14 20:13:00
29-MAY-14 20:13:00 2014-05-29:20:13:00 VALID N N N 1


POLLS_CHOICE_TR

590163 TRIGGER 29-MAY-14 20:13:01
29-MAY-14 20:13:01 2014-05-29:20:13:01 VALID N N N 3


POLLS_CHOICE_70F78E6B

590164 590164 INDEX 29-MAY-14 20:13:03
29-MAY-14 20:13:03 2014-05-29:20:13:03 VALID N N N 4


VM_BACKUP_STORAGE_SEQ

593274 SEQUENCE 16-JUN-14 16:45:59
16-JUN-14 16:45:59 2014-06-16:16:45:59 VALID N N N 1


LICENSE_TRIGGER

621203 TRIGGER 16-JUL-14 09:59:11
16-JUL-14 11:14:26 2014-07-16:11:14:26 VALID N N N 3


CUSTOMER_TRIGGER

621206 TRIGGER 16-JUL-14 15:10:38
16-JUL-14 15:10:38 2014-07-16:15:10:38 VALID N N N 3


BONUS

600715 600715 TABLE 26-JUN-14 09:46:13
26-JUN-14 09:46:13 2014-06-26:09:46:13 VALID N N N 1


DEPT

601577 601577 TABLE 26-JUN-14 09:46:14
26-JUN-14 09:46:14 2014-06-26:09:46:14 VALID N N N 1


EMP

600716 600716 TABLE 26-JUN-14 09:46:13
26-JUN-14 09:46:13 2014-06-26:09:46:13 VALID N N N 1


SALGRADE

601578 601578 TABLE 26-JUN-14 09:46:14
26-JUN-14 09:46:14 2014-06-26:09:46:14 VALID N N N 1


VM_LICENSE_HISTORY_SEQ

601582 SEQUENCE 26-JUN-14 12:50:03
26-JUN-14 12:50:03 2014-06-26:12:50:03 VALID N N N 1


VM_LICENSE_SEQ

601583 SEQUENCE 26-JUN-14 12:50:03
26-JUN-14 12:50:03 2014-06-26:12:50:03 VALID N N N 1


DJANGO_ADMIN_LOG

589924 589924 TABLE 29-MAY-14 19:57:12
29-MAY-14 19:57:44 2014-05-29:19:57:12 VALID N N N 1


SYS_C0082522

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


SYS_IL0000589924C00008$$

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


SYS_LOB0000589924C00008$$

590102 590102 LOB 29-MAY-14 19:57:12
29-MAY-14 19:57:12 2014-05-29:19:57:12 VALID N Y N 8


SYS_IL0000589924C00005$$

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


SYS_LOB0000589924C00005$$

589925 589925 LOB 29-MAY-14 19:57:12
29-MAY-14 19:57:12 2014-05-29:19:57:12 VALID N Y N 8


DJANGO_ADMIN_LOG_SQ

590105 SEQUENCE 29-MAY-14 19:57:12
29-MAY-14 19:57:12 2014-05-29:19:57:12 VALID N N N 1


DJANGO_ADMIN_LOG_TR

590106 TRIGGER 29-MAY-14 19:57:12
29-MAY-14 19:57:12 2014-05-29:19:57:12 VALID N N N 3


AUTH_PERMISSION

590107 590107 TABLE 29-MAY-14 19:57:13
29-MAY-14 19:57:44 2014-05-29:19:57:13 VALID N N N 1


SYS_C0082525

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


SYS_C0082526

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


AUTH_PERMISSION_SQ

590110 SEQUENCE 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 1


AUTH_PERMISSION_TR

590111 TRIGGER 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 3


AUTH_GROUP_PERMISSIONS

590112 590112 TABLE 29-MAY-14 19:57:13
29-MAY-14 19:57:44 2014-05-29:19:57:13 VALID N N N 1


SYS_C0082530

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


SYS_C0082531

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


AUTH_GROUP_PERMISSIONS_SQ

590115 SEQUENCE 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 1


AUTH_GROUP_PERMISSIONS_TR

590116 TRIGGER 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 3


AUTH_GROUP

590117 590117 TABLE 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 1


SYS_C0082534

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


SYS_C0082535

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


AUTH_GROUP_SQ

590120 SEQUENCE 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 1


AUTH_GROUP_TR

590121 TRIGGER 29-MAY-14 19:57:13
29-MAY-14 19:57:13 2014-05-29:19:57:13 VALID N N N 3


AUTH_USER_GROUPS

590122 590122 TABLE 29-MAY-14 19:57:14
29-MAY-14 19:57:44 2014-05-29:19:57:14 VALID N N N 1


SYS_C0082540

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


SYS_C0082541

590124 590124 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_GROUPS_SQ

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


AUTH_USER_GROUPS_TR

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


AUTH_USER_USER_PERMISSIONS

590127 590127 TABLE 29-MAY-14 19:57:14
29-MAY-14 19:57:44 2014-05-29:19:57:14 VALID N N N 1


SYS_C0082546

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


SYS_C0082547

590129 590129 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_USER_PERMISSIONS_SQ

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


AUTH_USER_USER_PERMISSIONS_TR

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


AUTH_USER

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


SYS_C0082558

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


LICENSE_ASSIGNMENTS_TR

621031 TRIGGER 15-JUL-14 09:38:57
15-JUL-14 09:38:57 2014-07-15:09:38:57 VALID N N N 3


LICENSE_ASSIGNMENTS

621028 621028 TABLE 15-JUL-14 09:38:56
15-JUL-14 09:39:04 2014-07-15:09:38:56 VALID N N N 1


SYS_C0087675

621029 621029 INDEX 15-JUL-14 09:38:56
15-JUL-14 09:38:56 2014-07-15:09:38:56 VALID N Y N 4


LICENSE_ASSIGNMENTS_SQ

621030 SEQUENCE 15-JUL-14 09:38:57
15-JUL-14 09:38:57 2014-07-15:09:38:57 VALID N N N 1


LICENSE_ASSIGNMENTS_3ABD520D

621032 621032 INDEX 15-JUL-14 09:39:04
15-JUL-14 09:39:04 2014-07-15:09:39:04 VALID N N N 4


LICENSE_ASSIGNMENTS_EE31349E

621033 621033 INDEX 15-JUL-14 09:39:04
15-JUL-14 09:39:04 2014-07-15:09:39:04 VALID N N N 4


PORTAL_VM_ASSIGNMENTS

621046 621046 TABLE 15-JUL-14 12:21:39
15-JUL-14 12:21:50 2014-07-15:12:21:39 VALID N N N 1


SYS_C0087681

621047 621047 INDEX 15-JUL-14 12:21:39
15-JUL-14 12:21:39 2014-07-15:12:21:39 VALID N Y N 4


PORTAL_VM_ASSIGNMENTS_SQ

621048 SEQUENCE 15-JUL-14 12:21:40
15-JUL-14 12:21:40 2014-07-15:12:21:40 VALID N N N 1


PORTAL_VM_ASSIGNMENTS_TR

621049 TRIGGER 15-JUL-14 12:21:40
15-JUL-14 12:21:40 2014-07-15:12:21:40 VALID N N N 3


PORTAL_VM_ASSIGNMENTS_EE31349E

621050 621050 INDEX 15-JUL-14 12:21:50
15-JUL-14 12:21:50 2014-07-15:12:21:50 VALID N N N 4


PORTAL_VM_ASSIGNMENTS_3ABD520D

621051 621051 INDEX 15-JUL-14 12:21:50
15-JUL-14 12:21:50 2014-07-15:12:21:50 VALID N N N 4


VM_PATHS

602756 602756 TABLE 27-JUN-14 10:23:13
27-JUN-14 10:23:13 2014-06-27:10:23:13 VALID N N N 1


TD_VMS

590568 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TI_IP_ADDRESSES

590569 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TD_RESOURCE_POOLS

590570 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TD_STORAGE_TIERS

590571 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TU_STORAGE_TIERS

590572 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TI_DATACENTERS

590573 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TI_HOSTS

590574 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TBI_CIDR_ALLOCATIONS

590575 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TAI_CIDR_ALLOCATIONS

590576 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TI_DATASTORES

590577 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TU_DATASTORES

590578 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:27 2014-06-26:15:25:26 VALID N N N 3

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


TU_DATACENTERS

590579 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_DATACENTERS

590580 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TI_VMS

590581 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_VCENTERS

590582 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_VCENTERS

590583 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TI_VM_GROUPS

590584 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_VM_GROUPS

590585 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_VM_GROUPS

590586 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_ESXI_LICENSES

590587 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TD_HOSTS

590588 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_ESXI_LICENSES

590589 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TD_CIDR_ALLOCATIONS

590590 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_CIDR_ALLOCATIONS

590591 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_CUSTOMERS

590592 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_CUSTOMERS

590593 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TD_DATASTORES

590594 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TI_VM_STORAGE_HISTORIES

590595 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_VM_STORAGE_HISTORIES

590596 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TI_VM_STORAGE_PERF_HISTORIES

590597 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_VM_STORAGE_PERF_HISTORIES

590598 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_HOSTS

590599 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3


TU_IP_ADDRESSES

590600 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TU_RESOURCE_POOLS

590601 TRIGGER 26-JUN-14 15:25:27
26-JUN-14 15:25:27 2014-06-26:15:25:27 VALID N N N 3


TI_IP_ADDRESS_USAGE_HISTORY

590602 TRIGGER 26-JUN-14 15:25:28
26-JUN-14 15:25:28 2014-06-26:15:25:28 VALID N N N 3


TU_VMS

590603 TRIGGER 26-JUN-14 15:25:28
26-JUN-14 15:25:28 2014-06-26:15:25:28 VALID N N N 3


TD_IP_ADDRESSES

590604 TRIGGER 26-JUN-14 15:25:28
26-JUN-14 15:25:28 2014-06-26:15:25:28 VALID N N N 3


TU_IP_ADDRESS_USAGE_HISTORIES

590605 TRIGGER 26-JUN-14 15:25:28
26-JUN-14 15:25:28 2014-06-26:15:25:28 VALID N N N 3


VM_MAC_ADDRESS_SEQ

590477 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


NETWORK_DEVICE_SEQ

590478 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


IOPS

590495 590495 TABLE 30-MAY-14 10:07:48
30-MAY-14 10:09:09 2014-05-30:10:07:48 VALID N N N 1


NETFLOWS

590501 590501 TABLE 30-MAY-14 10:07:49
30-MAY-14 10:09:09 2014-05-30:10:07:49 VALID N N N 1


UNALLOCATED_IPS

590507 590507 TABLE 30-MAY-14 10:07:49
30-MAY-14 10:09:09 2014-05-30:10:07:49 VALID N N N 1


IP2RAW

590512 FUNCTION 30-MAY-14 10:09:09
26-JUN-14 15:20:46 2014-05-29:15:14:55 VALID N N N 1


RAW2IP

590513 FUNCTION 30-MAY-14 10:09:09
26-JUN-14 15:20:46 2014-05-29:15:14:55 VALID N N N 1


PORTAL_USERPROFILE

606831 606831 TABLE 01-JUL-14 09:38:29
01-JUL-14 09:38:30 2014-07-01:09:38:29 VALID N N N 1


PORTAL_USERPROFILE_TR

606835 TRIGGER 01-JUL-14 09:38:30
01-JUL-14 09:38:30 2014-07-01:09:38:30 VALID N N N 3


SYS_C0085707

606832 606832 INDEX 01-JUL-14 09:38:30
01-JUL-14 09:38:30 2014-07-01:09:38:30 VALID N Y N 4


SYS_C0085708

606833 606833 INDEX 01-JUL-14 09:38:30
01-JUL-14 09:38:30 2014-07-01:09:38:30 VALID N Y N 4


PORTAL_USERPROFILE_SQ

606834 SEQUENCE 01-JUL-14 09:38:30
01-JUL-14 09:38:30 2014-07-01:09:38:30 VALID N N N 1


CUSTOMER_SEQ

590456 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


DATACENTER_SEQ

590457 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


DATASTORE_SEQ

590458 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


HOST_SEQ

590459 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


IP_ADDRESS_SEQ

590460 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


LICENSE_SEQ

590461 SEQUENCE 30-MAY-14 10:07:46
30-MAY-14 10:07:46 2014-05-30:10:07:46 VALID N N N 1


RESOURCE_POOL_SEQ

590462 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


STORAGE_TIER_SEQ

590463 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VCENTER_SEQ

590464 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_GROUP_SEQ

590465 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_SEQ

590466 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


CIDR_ALLOCATION_SEQ

590467 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_COMPUTE_HISTORY_SEQ

590468 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


GUEST_OS_SEQ

590469 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_NAS_USAGE_HISTORY_SEQ

590470 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


NAS_DEVICE_SEQ

590471 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


IP_USAGE_LOADER_SEQ

590472 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


LICENSE_AUTHORITY_SEQ

590473 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_STORAGE_HISTORY_SEQ

590474 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_STORAGE_PERF_HISTORY_SEQ

590475 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


VM_IP_ADDRESS_HISTORY_SEQ

590476 SEQUENCE 30-MAY-14 10:07:47
30-MAY-14 10:07:47 2014-05-30:10:07:47 VALID N N N 1


MANAGED_ENTITY_SEQ

601636 SEQUENCE 26-JUN-14 15:19:31
26-JUN-14 15:19:31 2014-06-26:15:19:31 VALID N N N 1


ESXI_LICENSE_SEQ

601637 SEQUENCE 26-JUN-14 15:19:31
26-JUN-14 15:19:31 2014-06-26:15:19:31 VALID N N N 1


CIDR_ALLOCATIONS

601638 601638 TABLE 26-JUN-14 15:19:32
26-JUN-14 15:25:27 2014-06-26:15:19:32 VALID N N N 1


CUSTOMERS

601639 601639 TABLE 26-JUN-14 15:19:32
16-JUL-14 15:10:38 2014-06-26:15:19:32 VALID N N N 1


DATACENTERS

601640 601640 TABLE 26-JUN-14 15:19:32
26-JUN-14 15:25:27 2014-06-26:15:19:32 VALID N N N 1


DATASTORES

601641 601641 TABLE 26-JUN-14 15:19:33
26-JUN-14 15:25:27 2014-06-26:15:19:33 VALID N N N 1


ESXI_LICENSES

601642 601642 TABLE 26-JUN-14 15:19:33
26-JUN-14 15:25:26 2014-06-26:15:19:33 VALID N N N 1


HOSTS

601643 601643 TABLE 26-JUN-14 15:19:33
26-JUN-14 15:25:27 2014-06-26:15:19:33 VALID N N N 1


IP_ADDRESSES

601644 601644 TABLE 26-JUN-14 15:19:33
26-JUN-14 15:25:28 2014-06-26:15:19:33 VALID N N N 1


RESOURCE_POOLS

601645 601645 TABLE 26-JUN-14 15:19:34
26-JUN-14 15:25:27 2014-06-26:15:19:34 VALID N N N 1


STORAGE_TIERS

601646 601646 TABLE 26-JUN-14 15:19:34
26-JUN-14 15:25:26 2014-06-26:15:19:34 VALID N N N 1


VCENTERS

601647 601647 TABLE 26-JUN-14 15:19:35
26-JUN-14 15:25:27 2014-06-26:15:19:35 VALID N N N 1


VM_GROUPS

601648 601648 TABLE 26-JUN-14 15:19:35
26-JUN-14 15:25:27 2014-06-26:15:19:35 VALID N N N 1


VM_COMPUTE_HISTORIES

601649 601649 TABLE 26-JUN-14 15:19:35
26-JUN-14 15:25:26 2014-06-26:15:19:35 VALID N N N 1


VMS

601650 601650 TABLE 26-JUN-14 15:19:35
27-JUN-14 10:45:52 2014-06-27:10:45:52 VALID N N N 1


IP_ADDRESS_USAGE_HISTORIES

601651 601651 TABLE 26-JUN-14 15:19:36
26-JUN-14 15:25:28 2014-06-26:15:19:36 VALID N N N 1


VM_STORAGE_HISTORIES

601652 601652 TABLE 26-JUN-14 15:19:36
26-JUN-14 15:25:27 2014-06-26:15:19:36 VALID N N N 1


VM_STORAGE_PERF_HISTORIES

601653 601653 TABLE 26-JUN-14 15:19:36
26-JUN-14 15:25:27 2014-06-26:15:19:36 VALID N N N 1


VM_MAC_ADDRESSES

601654 601654 TABLE 26-JUN-14 15:19:37
26-JUN-14 15:25:25 2014-06-26:15:19:37 VALID N N N 1


NETWORK_DEVICE_IP_ADDRESSES

601655 601655 TABLE 26-JUN-14 15:19:37
26-JUN-14 15:25:25 2014-06-26:15:19:37 VALID N N N 1


NETWORK_DEVICE_MAC_ADDRESSES

601656 601656 TABLE 26-JUN-14 15:19:37
26-JUN-14 15:25:25 2014-06-26:15:19:37 VALID N N N 1


NETWORK_DEVICES

601657 601657 TABLE 26-JUN-14 15:19:37
26-JUN-14 15:24:29 2014-06-26:15:19:37 VALID N N N 1


VM_IP_ADDRESS_HISTORIES

601658 601658 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:25:25 2014-06-26:15:19:38 VALID N N N 1


NAS_DEVICES

601659 601659 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:25:25 2014-06-26:15:19:38 VALID N N N 1


VM_NAS_USAGE_HISTORIES

601660 601660 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:25:25 2014-06-26:15:19:38 VALID N N N 1


VM_COMPUTE_USAGE_HISTORIES

601661 601661 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:25:25 2014-06-26:15:19:38 VALID N N N 1


NAS_USAGE

601662 601662 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:20:46 2014-06-26:15:19:38 VALID N N N 1


GUEST_OS

601663 601663 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:24:29 2014-06-26:15:19:38 VALID N N N 1


LICENSE_AUTHORITIES

601664 601664 TABLE 26-JUN-14 15:19:38
26-JUN-14 15:24:29 2014-06-26:15:19:38 VALID N N N 1


LICENSES

601665 601665 TABLE 26-JUN-14 15:19:39
26-JUN-14 15:24:29 2014-06-26:15:19:39 VALID N N N 1


MANAGED_ENTITIES

601666 601666 TABLE 26-JUN-14 15:19:39
26-JUN-14 15:25:25 2014-06-26:15:19:39 VALID N N N 1


VM_LICENSE_HISTORIES

601667 605852 TABLE 26-JUN-14 15:19:39
30-JUN-14 16:07:19 2014-06-26:15:19:39 VALID N N N 1


VM_LICENSES

601668 605840 TABLE 26-JUN-14 15:19:39
16-JUL-14 11:14:26 2014-06-26:15:19:39 VALID N N N 1


VM_BACKUP_STORAGE

601669 621205 TABLE 26-JUN-14 15:19:39
16-JUL-14 10:47:39 2014-06-26:15:19:39 VALID N N N 1


REPORT_COMPUTE

601670 601670 TABLE 26-JUN-14 15:19:39
26-JUN-14 15:19:39 2014-06-26:15:19:39 VALID N N N 1


XPKCIDR_ALLOCATIONS

601671 601671 INDEX 26-JUN-14 15:20:46
26-JUN-14 15:20:46 2014-06-26:15:20:46 VALID N N N 4


XPKCUSTOMERS

601672 601672 INDEX 26-JUN-14 15:20:46
26-JUN-14 15:20:46 2014-06-26:15:20:46 VALID N N N 4


XPKDATACENTERS

601673 601673 INDEX 26-JUN-14 15:20:46
26-JUN-14 15:20:46 2014-06-26:15:20:46 VALID N N N 4


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

XIF1DATACENTERS

601674 601674 INDEX 26-JUN-14 15:20:46
26-JUN-14 15:20:46 2014-06-26:15:20:46 VALID N N N 4


XPKDATASTORES

601675 601675 INDEX 26-JUN-14 15:20:46
26-JUN-14 15:20:46 2014-06-26:15:20:46 VALID N N N 4


XIF1DATASTORES

601676 601676 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XPKESXI_LICENSES

601677 601677 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XPKHOSTS

601678 601678 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XAK1HOSTS

601679 601679 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XAK2HOSTS

601680 601680 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XIF2HOSTS

601681 601681 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XIF1HOSTS

601682 601682 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:20:47 2014-06-26:15:20:47 VALID N N N 4


XPKIP_ADDRESSES

601683 601683 INDEX 26-JUN-14 15:20:47
26-JUN-14 15:21:12 2014-06-26:15:20:47 VALID N N N 4


XIF1IP_ADDRESSES

601684 601684 INDEX 26-JUN-14 15:21:12
26-JUN-14 15:21:35 2014-06-26:15:21:12 VALID N N N 4


XPKRESOURCE_POOLS

601685 601685 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XAK1RESOURCE_POOLS

601686 601686 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XPKSTORAGE_TIERS

601687 601687 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XPKVCENTERS

601688 601688 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XPKVM_GROUPS

601689 601689 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XIF1VM_GROUPS

601690 601690 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XIF2VM_RESOURCE_HISTORIES

601691 601691 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XPKVMS

601692 601692 INDEX 26-JUN-14 15:21:35
26-JUN-14 15:21:35 2014-06-26:15:21:35 VALID N N N 4


XIF1VMS

601693 601693 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


DATACENTERK2

601694 601694 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


DATASTOREK2

601695 601695 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


HOSTSK2

601696 601696 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


RESOURCE_POOLSK2

601697 601697 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XAK1VMS

601698 601698 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XPKVM_STORAGE_PERFORMANCE_HIST

601699 601699 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XIE1VM_STORAGE_PERFORMANCE_HIS

601700 601700 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XPKVM_MAC_ADDRESS_HISTORIES

601701 601701 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XPKNETWORK_DEVICE_IP_ADDRESSES

601702 601702 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XPKNETWORK_DEVICES

601703 601703 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XPKNETWORK_DEVICE_MAC_ADDRESSE

601704 601704 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:36 2014-06-26:15:21:36 VALID N N N 4


XAK1IP_ADDRESSES

601705 601705 INDEX 26-JUN-14 15:21:36
26-JUN-14 15:21:59 2014-06-26:15:21:36 VALID N N N 4


XIF2NETWORK_DEVICE_IP_ADDR

601706 601706 INDEX 26-JUN-14 15:21:59
26-JUN-14 15:21:59 2014-06-26:15:21:59 VALID N N N 4


XAK1NETWORK_DEVICE_MAC_ADDRESS

601707 601707 INDEX 26-JUN-14 15:21:59
26-JUN-14 15:21:59 2014-06-26:15:21:59 VALID N N N 4


XAK1VM_MAC_ADDRESSES

601708 601708 INDEX 26-JUN-14 15:21:59
26-JUN-14 15:21:59 2014-06-26:15:21:59 VALID N N N 4


XPKVM_IP_ADDRESS_HISTORIES

601709 601709 INDEX 26-JUN-14 15:21:59
26-JUN-14 15:21:59 2014-06-26:15:21:59 VALID N N N 4


XPKIP_ADDRESS_USAGE_HISTORIES

601710 601710 INDEX 26-JUN-14 15:21:59
26-JUN-14 15:24:28 2014-06-26:15:21:59 VALID N N N 4


XPKNAS_DEVICES

601711 601711 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKVM_NAS_USAGE_HISTORIES

601712 601712 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKGUEST_OS

601713 601713 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKLICENSE_AUTHORITIES

601714 601714 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKLICENSES

601715 601715 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XAK1GUEST_OS

601716 601716 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKVM_COMPUTE_USAGE_HISTORIES

601717 601717 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XIE1VM_STORAGE_HISTORIES

601718 601718 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKVM_STORAGE_HISTORIES

601719 601719 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XIE1VM_COMPUTE_HISTORIES

601720 601720 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XIF4VM_RESOURCE_HISTORIES

601721 601721 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XIF3VM_RESOURCE_HISTORIES

601722 601722 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XIF1VM_RESOURCE_HISTORIES

601723 601723 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKVM_RESOURCE_HISTORIES

601724 601724 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XAK1LICENSES

601725 601725 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XAK2MANAGED_ENTITIES

601726 601726 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKMANAGED_ENTITIES

601727 601727 INDEX 26-JUN-14 15:24:28
26-JUN-14 15:24:28 2014-06-26:15:24:28 VALID N N N 4


XPKVM_LICENSE_HISTORIES

601728 605851 INDEX 26-JUN-14 15:24:28
30-JUN-14 16:07:19 2014-06-26:15:24:28 VALID N N N 4


XPKVM_BACKUP_STORAGE

601729 621204 INDEX 26-JUN-14 15:24:29
16-JUL-14 10:47:39 2014-06-26:15:24:29 VALID N N N 4


XPKVM_LICENSES

601730 605839 INDEX 26-JUN-14 15:24:29
30-JUN-14 15:45:00 2014-06-26:15:24:29 VALID N N N 4


XIE1VM_LICENSES

601731 605838 INDEX 26-JUN-14 15:24:29
30-JUN-14 15:45:00 2014-06-26:15:24:29 VALID N N N 4


XIE1VM_LICENSE_HISTORIES

601732 605850 INDEX 26-JUN-14 15:24:29
30-JUN-14 16:07:19 2014-06-26:15:24:29 VALID N N N 4


TI_VM_COMPUTE_HISTORIES

601733 TRIGGER 26-JUN-14 15:25:26
26-JUN-14 15:25:26 2014-06-26:15:25:26 VALID N N N 3



257 rows selected.


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

593400 593400 TABLE 17-JUN-14 14:34:31
17-JUN-14 14:35:23 2014-06-17:14:34:31 VALID N N N 1


VM_BACKUP_STORAGE

593393 SYNONYM 17-JUN-14 08:23:59
11-JUL-14 15:34:29 2014-07-11:15:34:29 VALID N N N 1


SYS_C0084004

593410 593410 INDEX 17-JUN-14 14:34:31
17-JUN-14 14:34:31 2014-06-17:14:34:31 VALID N Y N 4


SYS_IL0000593400C00008$$

593409 593409 INDEX 17-JUN-14 14:34:31
17-JUN-14 14:34:31 2014-06-17:14:34:31 VALID N Y N 4


SYS_LOB0000593400C00008$$

593408 593408 LOB 17-JUN-14 14:34:31
17-JUN-14 14:34:31 2014-06-17:14:34:31 VALID N Y N 8


SYS_IL0000593400C00005$$

593407 593407 INDEX 17-JUN-14 14:34:31
17-JUN-14 14:34:31 2014-06-17:14:34:31 VALID N Y N 4


SYS_LOB0000593400C00005$$

593401 593401 LOB 17-JUN-14 14:34:31
17-JUN-14 14:34:31 2014-06-17:14:34:31 VALID N Y N 8


DJANGO_ADMIN_LOG_SQ

593411 SEQUENCE 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N N N 1


DJANGO_ADMIN_LOG_TR

593412 TRIGGER 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N N N 3


AUTH_PERMISSION

593413 593413 TABLE 17-JUN-14 14:34:32
17-JUN-14 14:35:23 2014-06-17:14:34:32 VALID N N N 1


SYS_C0084007

593414 593414 INDEX 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N Y N 4


SYS_C0084008

593415 593415 INDEX 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N Y N 4


AUTH_PERMISSION_SQ

593416 SEQUENCE 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N N N 1


AUTH_PERMISSION_TR

593417 TRIGGER 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N N N 3


AUTH_GROUP_PERMISSIONS

593418 593418 TABLE 17-JUN-14 14:34:32
17-JUN-14 14:35:23 2014-06-17:14:34:32 VALID N N N 1


SYS_C0084012

593419 593419 INDEX 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N Y N 4


SYS_C0084013

593420 593420 INDEX 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N Y N 4


AUTH_GROUP_PERMISSIONS_SQ

593421 SEQUENCE 17-JUN-14 14:34:32
17-JUN-14 14:34:32 2014-06-17:14:34:32 VALID N N N 1


AUTH_GROUP_PERMISSIONS_TR

593422 TRIGGER 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 3


AUTH_GROUP

593423 593423 TABLE 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 1


SYS_C0084016

593424 593424 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


SYS_C0084017

593425 593425 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


AUTH_GROUP_SQ

593426 SEQUENCE 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 1


AUTH_GROUP_TR

593427 TRIGGER 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 3


MANAGED_ENTITIES

591571 SYNONYM 09-JUN-14 09:10:50
09-JUN-14 09:10:50 2014-06-09:09:10:50 VALID N N N 1


AUTH_USER_GROUPS

593428 593428 TABLE 17-JUN-14 14:34:33
17-JUN-14 14:35:24 2014-06-17:14:34:33 VALID N N N 1


SYS_C0084022

593429 593429 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


SYS_C0084023

593430 593430 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


AUTH_USER_GROUPS_SQ

593431 SEQUENCE 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 1


AUTH_USER_GROUPS_TR

593432 TRIGGER 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N N N 3


AUTH_USER_USER_PERMISSIONS

593433 593433 TABLE 17-JUN-14 14:34:33
17-JUN-14 14:35:24 2014-06-17:14:34:33 VALID N N N 1


SYS_C0084028

593434 593434 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


SYS_C0084029

593435 593435 INDEX 17-JUN-14 14:34:33
17-JUN-14 14:34:33 2014-06-17:14:34:33 VALID N Y N 4


AUTH_USER_USER_PERMISSIONS_SQ

593436 SEQUENCE 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 1


AUTH_USER_USER_PERMISSIONS_TR

593437 TRIGGER 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 3


AUTH_USER

593438 593438 TABLE 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 1


SYS_C0084040

593439 593439 INDEX 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N Y N 4


SYS_C0084041

593440 593440 INDEX 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N Y N 4


AUTH_USER_SQ

593441 SEQUENCE 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 1


AUTH_USER_TR

593442 TRIGGER 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 3


DJANGO_CONTENT_TYPE

593443 593443 TABLE 17-JUN-14 14:34:34
17-JUN-14 14:34:35 2014-06-17:14:34:34 VALID N N N 1


SYS_C0084046

593444 593444 INDEX 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N Y N 4


SYS_C0084047

593445 593445 INDEX 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N Y N 4


DJANGO_CONTENT_TYPE_SQ

593446 SEQUENCE 17-JUN-14 14:34:34
17-JUN-14 14:34:34 2014-06-17:14:34:34 VALID N N N 1


DJANGO_CONTENT_TYPE_TR

593447 TRIGGER 17-JUN-14 14:34:35
17-JUN-14 14:34:35 2014-06-17:14:34:35 VALID N N N 3


DJANGO_SESSION

593448 593448 TABLE 17-JUN-14 14:34:35
17-JUN-14 14:35:24 2014-06-17:14:34:35 VALID N N N 1


SYS_C0084052

593451 593451 INDEX 17-JUN-14 14:34:35
17-JUN-14 14:34:35 2014-06-17:14:34:35 VALID N Y N 4


SYS_IL0000593448C00002$$

593450 593450 INDEX 17-JUN-14 14:34:35
17-JUN-14 14:34:35 2014-06-17:14:34:35 VALID N Y N 4


SYS_LOB0000593448C00002$$

593449 593449 LOB 17-JUN-14 14:34:35
17-JUN-14 14:34:35 2014-06-17:14:34:35 VALID N Y N 8


DJANGO_ADMIN_LOG_6340C63C

593452 593452 INDEX 17-JUN-14 14:35:23
17-JUN-14 14:35:23 2014-06-17:14:35:23 VALID N N N 4


DJANGO_ADMIN_LOG_37EF4EB4

593453 593453 INDEX 17-JUN-14 14:35:23
17-JUN-14 14:35:23 2014-06-17:14:35:23 VALID N N N 4


AUTH_PERMISSION_37EF4EB4

593454 593454 INDEX 17-JUN-14 14:35:23
17-JUN-14 14:35:23 2014-06-17:14:35:23 VALID N N N 4


AUTH_GROUP_PERMISSIONS_5F4A8D8

593455 593455 INDEX 17-JUN-14 14:35:23
17-JUN-14 14:35:23 2014-06-17:14:35:23 VALID N N N 4


AUTH_GROUP_PERMISSIONS_83DF41E

593456 593456 INDEX 17-JUN-14 14:35:23
17-JUN-14 14:35:23 2014-06-17:14:35:23 VALID N N N 4


AUTH_USER_GROUPS_6340C63C

593457 593457 INDEX 17-JUN-14 14:35:24
17-JUN-14 14:35:24 2014-06-17:14:35:24 VALID N N N 4


AUTH_USER_GROUPS_5F412F9A

593458 593458 INDEX 17-JUN-14 14:35:24
17-JUN-14 14:35:24 2014-06-17:14:35:24 VALID N N N 4


AUTH_USER_USER_PERMISSIONSBD5D

593459 593459 INDEX 17-JUN-14 14:35:24
17-JUN-14 14:35:24 2014-06-17:14:35:24 VALID N N N 4


AUTH_USER_USER_PERMISSIONS7493

593460 593460 INDEX 17-JUN-14 14:35:24
17-JUN-14 14:35:24 2014-06-17:14:35:24 VALID N N N 4


DJANGO_SESSION_B7B81F0C

593461 593461 INDEX 17-JUN-14 14:35:24
17-JUN-14 14:35:24 2014-06-17:14:35:24 VALID N N N 4


PORTAL_USERPROFILE_TR

594538 TRIGGER 19-JUN-14 13:44:28
19-JUN-14 13:44:28 2014-06-19:13:44:28 VALID N N N 3


PORTAL_USERPROFILE

594534 594534 TABLE 19-JUN-14 13:44:27
19-JUN-14 13:44:28 2014-06-19:13:44:27 VALID N N N 1


SYS_C0084119

594535 594535 INDEX 19-JUN-14 13:44:27
19-JUN-14 13:44:27 2014-06-19:13:44:27 VALID N Y N 4


SYS_C0084120

594536 594536 INDEX 19-JUN-14 13:44:27
19-JUN-14 13:44:27 2014-06-19:13:44:27 VALID N Y N 4


PORTAL_USERPROFILE_SQ

594537 SEQUENCE 19-JUN-14 13:44:28
19-JUN-14 13:44:28 2014-06-19:13:44:28 VALID N N N 1


VM_LICENSES

594539 SYNONYM 19-JUN-14 14:36:58
14-JUL-14 14:35:40 2014-07-14:14:35:40 VALID N N N 1


VM_LICENSE_HISTORIES

594540 SYNONYM 19-JUN-14 14:38:02
26-JUN-14 14:54:27 2014-06-26:14:54:27 VALID N N N 1


VM_MAC_ADDRESSES

589920 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_NAS_USAGE_HISTORIES

589921 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_STORAGE_HISTORIES

589922 SYNONYM 28-MAY-14 09:33:44
28-MAY-14 09:33:44 2014-05-28:09:33:44 VALID N N N 1


VM_STORAGE_PERF_HISTORIES

589923 SYNONYM 28-MAY-14 09:33:44
28-MAY-14 09:33:44 2014-05-28:09:33:44 VALID N N N 1


IP2RAW

590020 SYNONYM 29-MAY-14 15:17:16
29-MAY-14 15:17:16 2014-05-29:15:17:16 VALID N N N 1


RAW2IP

590019 SYNONYM 29-MAY-14 15:16:55
29-MAY-14 15:16:55 2014-05-29:15:16:55 VALID N N N 1


CIDR_ALLOCATIONS

589894 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


VMS

589893 SYNONYM 28-MAY-14 09:33:34
28-MAY-14 09:33:34 2014-05-28:09:33:34 VALID N N N 1


CUSTOMERS

589895 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


DATACENTERS

589896 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


DATASTORES

589897 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


ESXI_LICENSES

589898 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


GUEST_OS

589899 SYNONYM 28-MAY-14 09:33:41
28-MAY-14 09:33:41 2014-05-28:09:33:41 VALID N N N 1


HOSTS

589900 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


IOPS

589901 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 INVALID N N N 1


IP_ADDRESS_USAGE_HISTORIES

589902 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


IP_ADDRESSES

589903 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


LICENSE_AUTHORITIES

589904 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


LICENSES

589905 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


NAS_DEVICES

589906 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


NAS_USAGE

589907 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


NETFLOWS

589908 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 INVALID N N N 1


NETWORK_DEVICE_IP_ADDRESSES

589909 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


NETWORK_DEVICE_MAC_ADDRESSES

589910 SYNONYM 28-MAY-14 09:33:42
28-MAY-14 09:33:42 2014-05-28:09:33:42 VALID N N N 1


NETWORK_DEVICES

589911 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


RESOURCE_POOLS

589912 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


STORAGE_TIERS

589913 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


UNALLOCATED_IPS

589914 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 INVALID N N N 1


VCENTERS

589915 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_COMPUTE_HISTORIES

589916 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_COMPUTE_USAGE_HISTORIES

589917 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_GROUPS

589918 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1


VM_IP_ADDRESS_HISTORIES

589919 SYNONYM 28-MAY-14 09:33:43
28-MAY-14 09:33:43 2014-05-28:09:33:43 VALID N N N 1

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



99 rows selected.

SQL>
--
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/025458b4-f0e3-4171-a16e-13b473ed2724%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
G Z
2014-07-17 15:23:49 UTC
Permalink
anyone have an idea?
Post by G Z
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:*
ORA-00942: table or view does not exist
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
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'portal')
('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')
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
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
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in results_iter
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/6dc9b14a-5c7f-4ef6-84f2-9d8f52fe0a1e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Michiel Overtoom
2014-07-17 16:45:16 UTC
Permalink
So I'm still running in to issues using a prexisting database, ive worked out almost all of the issues
I'm following your posts with interest, since I will be writing a Django app soon which also has to use a pre-existing database.

Greetings,
--
"You can't actually make computers run faster, you can only make them do less." - RiderOfGiraffes
--
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/9EF371D0-F129-447B-9292-7DFA24726BB4%40xs4all.nl.
For more options, visit https://groups.google.com/d/optout.
G Z
2014-07-17 23:49:25 UTC
Permalink
Thanks,

I am unable to solve this issue but im running it down.
Post by G Z
So I'm still running in to issues using a prexisting database, ive
worked out almost all of the issues
I'm following your posts with interest, since I will be writing a Django
app soon which also has to use a pre-existing database.
Greetings,
--
"You can't actually make computers run faster, you can only make them do
less." - RiderOfGiraffes
--
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/b5a03bdf-6bf6-49df-bffb-8177f5b8256b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...