Django Admin DB Error only when trying to delete an inserted record delete.
73 views
Skip to first unread message
G Z
Jul 16, 2014, 5:14:35 PM7/16/14
to django...@googlegroups.com
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.
# You'll have to do the following manually to clean this up:
# * 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
class AuthGroup(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(unique=True, max_length=160, blank=True)
class Meta:
managed = False
db_table = 'auth_group'
class AuthGroupPermissions(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
group = models.ForeignKey(AuthGroup)
permission = models.ForeignKey('AuthPermission')
class Meta:
managed = False
db_table = 'auth_group_permissions'
class AuthPermission(models.Model):
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)
class Meta:
managed = False
db_table = 'auth_permission'
class AuthUser(models.Model):
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()
class Meta:
managed = False
db_table = 'auth_user'
class AuthUserGroups(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
group = models.ForeignKey(AuthGroup)
class Meta:
managed = False
db_table = 'auth_user_groups'
class AuthUserUserPermissions(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
permission = models.ForeignKey(AuthPermission)
class Meta:
managed = False
db_table = 'auth_user_user_permissions'
class Bonus(models.Model):
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)
class Meta:
managed = False
db_table = 'bonus'
class CidrAllocations(models.Model):
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)
class Meta:
managed = False
db_table = 'cidr_allocations'
def clean(self):
if self.public_address != 'Y' and self.public_address != 'N':
raise ValidationError('Please enter a Y or N')
def __unicode__(self): # Python 3: def __str__(self):
return self.allocation_name
class Customers(models.Model):
customer_id = models.BigIntegerField(primary_key=True, editable=False)
customer_name = models.CharField(max_length=30)
inactive = models.CharField(max_length=1)
class Meta:
managed = False
db_table = 'customers'
def __unicode__(self): # Python 3: def __str__(self):
return self.customer_name
def clean(self):
if self.inactive != 'Y' and self.inactive != 'N':
raise ValidationError('Please enter a Y or N')
class Datacenters(models.Model):
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)
class Meta:
managed = False
db_table = 'datacenters'
class Datastores(models.Model):
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)
class Meta:
managed = False
db_table = 'datastores'
class Dept(models.Model):
deptno = models.IntegerField(blank=True, null=True)
dname = models.CharField(max_length=14, blank=True)
loc = models.CharField(max_length=13, blank=True)
class Meta:
managed = False
db_table = 'dept'
class DjangoAdminLog(models.Model):
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)
class Meta:
managed = False
db_table = 'django_admin_log'
class DjangoContentType(models.Model):
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)
class Meta:
managed = False
db_table = 'django_content_type'
class DjangoSession(models.Model):
session_key = models.CharField(primary_key=True, max_length=80)
session_data = models.TextField(blank=True)
expire_date = models.DateTimeField()
class Meta:
managed = False
db_table = 'django_session'
class Emp(models.Model):
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)
class Meta:
managed = False
db_table = 'emp'
class EsxiLicenses(models.Model):
esxi_license_id = models.BigIntegerField(primary_key=True, editable=False)
license_type = models.CharField(max_length=40)
class Meta:
managed = False
db_table = 'esxi_licenses'
class GuestOs(models.Model):
guest_os_id = models.FloatField(primary_key=True, editable=False)
guest_os = models.CharField(unique=True, max_length=60)
class Meta:
managed = False
db_table = 'guest_os'
class Hosts(models.Model):
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)
class Meta:
managed = False
db_table = 'hosts'
class Iops(models.Model):
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()
class Meta:
managed = False
db_table = 'iops'
class IpAddressUsageHistories(models.Model):
datetime = models.DateTimeField()
bytes_sent = models.BigIntegerField()
bytes_received = models.BigIntegerField()
ip_address = models.ForeignKey('IpAddresses')
load_sequence = models.BigIntegerField()
class Meta:
managed = False
db_table = 'ip_address_usage_histories'
class IpAddresses(models.Model):
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)
class Meta:
managed = False
db_table = 'ip_addresses'
class LicenseAssignments(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
license = models.ForeignKey('Licenses')
vm_license = models.ForeignKey('VmLicenses')
class Meta:
managed = False
db_table = 'license_assignments'
class LicenseAuthorities(models.Model):
license_authority_id = models.FloatField(primary_key=True, editable=False)
licensing_authority = models.CharField(max_length=30)
class Meta:
managed = False
db_table = 'license_authorities'
def __unicode__(self): # Python 3: def __str__(self):
return self.licensing_authority
class Licenses(models.Model):
license_id = models.FloatField(primary_key=True, editable=False)
license_authority_id = models.FloatField()
product = models.CharField(max_length=30)
class Meta:
managed = False
db_table = 'licenses'
def __unicode__(self): # Python 3: def __str__(self):
return self.product
class ManagedEntities(models.Model):
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)
class Meta:
managed = False
db_table = 'managed_entities'
class NasDevices(models.Model):
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')
class Meta:
managed = False
db_table = 'nas_devices'
def __unicode__(self): # Python 3: def __str__(self):
return self.device_name
class NasUsage(models.Model):
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()
class Meta:
managed = False
db_table = 'nas_usage'
class Netflows(models.Model):
datetime = models.DateTimeField()
ip_address = models.CharField(max_length=39)
sbytes = models.FloatField()
rbytes = models.FloatField()
class Meta:
managed = False
db_table = 'netflows'
class NetworkDeviceIpAddresses(models.Model):
network_device = models.ForeignKey('NetworkDevices')
ip_address = models.ForeignKey(IpAddresses, unique=True)
class Meta:
managed = False
db_table = 'network_device_ip_addresses'
class NetworkDeviceMacAddresses(models.Model):
network_device = models.ForeignKey('NetworkDevices')
mac_address = models.CharField(max_length=17)
datacenter = models.ForeignKey(Datacenters)
class Meta:
managed = False
db_table = 'network_device_mac_addresses'
def __unicode__(self): # Python 3: def __str__(self):
return self.mac_address
class NetworkDevices(models.Model):
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)
class Meta:
managed = False
db_table = 'network_devices'
def __unicode__(self): # Python 3: def __str__(self):
return self.name
def clean(self):
snmp_security = set(['AuthPriv', 'NoAuthNoPriv', 'AuthNoPriv'])
auth_protocols = set(['MD5', 'SHA'])
priv_protocols = set(['AES', 'DES'])
if self.snmp_version < 1 or self.snmp_version > 3:
raise ValidationError('Please enter a 1, 2 or 3')
if self.snmp_security not in snmp_security:
raise ValidationError('Please enter AuthPriv, NoAuthNoPriv or AuthNoPriv')
if self.snmp_auth_protocol not in auth_protocols:
raise ValidationError('Please enter MD5 or SHA')
if self.snmp_priv_protocol not in priv_protocols:
raise ValidationError('Please enter AES or DES')
class PollsChoice(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
poll = models.ForeignKey('PollsPoll')
choice_text = models.CharField(max_length=400, blank=True)
votes = models.IntegerField()
class Meta:
managed = False
db_table = 'polls_choice'
class PollsPoll(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
question = models.CharField(max_length=400, blank=True)
pub_date = models.DateTimeField()
class Meta:
managed = False
db_table = 'polls_poll'
class PortalUserprofile(models.Model):
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)
class Meta:
managed = False
db_table = 'portal_userprofile'
class PortalVmAssignments(models.Model):
id = models.IntegerField(primary_key=True, editable=False)
vm_license = models.ForeignKey('VmLicenses')
license = models.ForeignKey(Licenses)
class Meta:
managed = False
db_table = 'portal_vm_assignments'
class ReportCompute(models.Model):
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
class Meta:
managed = False
db_table = 'report_compute'
class ResourcePools(models.Model):
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()
class Meta:
managed = False
db_table = 'resource_pools'
class Salgrade(models.Model):
grade = models.FloatField(blank=True, null=True)
losal = models.FloatField(blank=True, null=True)
hisal = models.FloatField(blank=True, null=True)
class Meta:
managed = False
db_table = 'salgrade'
class StorageTiers(models.Model):
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)
class Meta:
managed = False
db_table = 'storage_tiers'
def __unicode__(self):
return self.tier_name
class UnallocatedIps(models.Model):
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)
class Meta:
managed = False
db_table = 'unallocated_ips'
class Vcenters(models.Model):
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)
class Meta:
managed = False
db_table = 'vcenters'
def __unicode__(self): # Python 3: def __str__(self):
return self.name
class VmBackupStorage(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_backup_storage'
class VmComputeHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_compute_histories'
class VmComputeUsageHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_compute_usage_histories'
class VmGroups(models.Model):
vm_group_id = models.BigIntegerField(primary_key=True, editable=False)
customer = models.ForeignKey(Customers)
vm_group_name = models.CharField(max_length=30)
class Meta:
managed = False
db_table = 'vm_groups'
def __unicode__(self):
return self.vm_group_name
class VmIpAddressHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_ip_address_histories'
class VmLicenseHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_license_histories'
class VmLicenses(models.Model):
vm_license_id = models.BigIntegerField(primary_key=True, editable=False)
license = models.ForeignKey(Licenses)
#license = models.ManyToManyField(Licenses)
vm = models.ForeignKey('Vms')
class Meta:
managed = False
db_table = 'vm_licenses'
class VmMacAddresses(models.Model):
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()
class Meta:
managed = False
db_table = 'vm_mac_addresses'
class VmNasUsageHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_nas_usage_histories'
class VmPaths(models.Model):
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
class Meta:
managed = False
db_table = 'vm_paths'
class VmStorageHistories(models.Model):
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)
class Meta:
managed = False
db_table = 'vm_storage_histories'
class VmStoragePerfHistories(models.Model):
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()
class Meta:
managed = False
db_table = 'vm_storage_perf_histories'
class Vms(models.Model):
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)
class Meta:
managed = False
db_table = 'vms'
def __unicode__(self): # Python 3: def __str__(self):
return self.vm_name
class UserProfile(models.Model):
user = models.OneToOneField(User)
website = models.URLField(blank=True)
picture = models.ImageField(upload_to='profile_images', blank=True)
def __unicode__(self):
return self.user.username
Whenever I try to delete and entry i made it gives me the following error:
| Exception Type: | DatabaseError |
|---|---|
| Exception Value: | ORA-00942: table or view does not exist |
Environment:
Request Method: GET
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
G Z
Jul 16, 2014, 6:21:47 PM7/16/14
to django...@googlegroups.com
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.
G Z
Jul 16, 2014, 7:31:23 PM7/16/14
to django...@googlegroups.com
here are my user objects for the two tables obviously development has more do you think this could be causing the issue
grant@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/root66@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>
G Z
Jul 17, 2014, 11:23:49 AM7/17/14
to django...@googlegroups.com
anyone have an idea?
Michiel Overtoom
Jul 17, 2014, 12:46:08 PM7/17/14
to django...@googlegroups.com
On Jul 16, 2014, at 23:14, G Z wrote:
> So I'm still running in to issues using a prexisting database, ive worked out almost all of the issues
Greetings,
--
"You can't actually make computers run faster, you can only make them do less." - RiderOfGiraffes
G Z
Jul 17, 2014, 7:49:25 PM7/17/14
to django...@googlegroups.com
Thanks,
I am unable to solve this issue but im running it down.
Reply all
Reply to author
Forward
0 new messages