Archive for Oracle DB Objects (tables, sql etc) (Cat)

56 results.
Jun 17, 2008 temp tablespace usage
Jun 17, 2008 dbms_metadata to get ddl for creating objects
Jun 17, 2008 list extents by owner
Jun 17, 2008 select extents
Jun 17, 2008 tablespace size and free space
Jun 23, 2008 alter all users to new default temp tablespace
Jun 23, 2008 create script to rebuild all invalid objects.sql
Jun 23, 2008 describe a table.sql
Jun 23, 2008 describe multiple tables.sql
Jun 23, 2008 detiled info on a table columns.sql
Jun 23, 2008 get general tablespace info again again.sql
Jun 23, 2008 get general tablespace info again.sql
Jun 23, 2008 get general tablespace info another.sql
Jun 23, 2008 get general tablespace info.sql
Jun 23, 2008 list a tables columns.sql
Jun 23, 2008 list all objects.sql
Jun 23, 2008 list all sequences.sql
Jun 23, 2008 list all tables.sql
Jun 23, 2008 list basic segment details again.sql
Jun 23, 2008 list basic segment details.sql
Jun 23, 2008 list foreign keys on a table and all foreign references again.sql
Jun 23, 2008 list foreign keys on a table and all foreign references.sql
Jun 23, 2008 list index and column names for a table again.sql
Jun 23, 2008 list index and column names for a table.sql
Jun 23, 2008 list index partition details.sql
Jun 23, 2008 list synonyms.sql
Jun 23, 2008 list tables and their partitions.sql
Jun 23, 2008 list tablespaces.sql
Jun 23, 2008 list users and default tablespace.sql
Jun 23, 2008 list views with name like.sql
Jun 23, 2008 query all objects.sql
Jun 23, 2008 see what foreign keys are pointing to this table.sql
Jun 23, 2008 show a users privileges.sql
Jun 23, 2008 show all tables for a user.sql
Jun 23, 2008 show general stats for a partitioned table again.sql
Jun 23, 2008 show stats for a partitioned table and its indexes
Jun 23, 2008 show general stats for a table – more.sql
Jun 23, 2008 show general stats for a table again again.sql
Jun 23, 2008 show general stats for a table Another view .sql
Jun 23, 2008 show general stats for a table.sql
Jun 23, 2008 show grants.sql
Jun 23, 2008 show object dependencies.sql
Jun 23, 2008 show partition index structure.sql
Jun 23, 2008 show partition table column statistics.sql
Jun 23, 2008 show partition table structures.sql
Jun 23, 2008 show privs on an object.sql
Jun 23, 2008 show structure of indexes on a table.sql
Jun 23, 2008 show text for a package.sql
Jun 23, 2008 show view text.sql
Jun 23, 2008 simple list of constraints on a table.sql
Jun 23, 2008 sum blocks used by schema.sql
Jun 23, 2008 sum size of tablespace datafiles and free space.sql
Jun 23, 2008 tablespace info from dba_segments
Jun 23, 2008 tablespace info from dba_segments and dba_objects
Jun 23, 2008 tablespace info by ts name and object_type from dba_segments
Aug 27, 2010 dbms_metadata.get_ddl for a full schema