Vil se alle tabeller i Oracle

Man kan se alle brugerens tabeller vha.

SELECT *
FROM USER_TABLES:

Hvis du har administrator-rettigheder kan du bruge

SELECT *
FROM DBA_TABLES.

Du kan jo lave et script

SELECT \'describe \' || TABLE_NAME || \';\'
FROM USER_TABLES;

Dette vil generere describe-kommandoer til dig.

Andre gode \'USER\' tables:

USER_ALL_TABLES
USER_ARGUMENTS
USER_ASSOCIATIONS
USER_AUDIT_OBJECT
USER_AUDIT_SESSION
USER_AUDIT_STATEMENT
USER_AUDIT_TRAIL
USER_CATALOG
USER_CLU_COLUMNS
USER_CLUSTERS
USER_CLUSTER_HASH_EXPRESSIONS
USER_COL_COMMENTS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_COLL_TYPES
USER_CONS_COLUMNS
USER_CONSTRAINTS
USER_DB_LINKS
USER_DEPENDENCIES
USER_DIMENSIONS
USER_DIM_ATTRIBUTES
USER_DIM_CHILD_OF
USER_DIM_HIERARCHIES
USER_DIM_JOIN_KEY
USER_DIM_LEVELS
USER_DIM_LEVEL_KEY
USER_ERRORS
USER_EXTENTS
USER_FREE_SPACE
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_INDEXES
USER_INDEXTYPES
USER_INDEXTYPE_OPERATORS
USER_INTERNAL_TRIGGERS
USER_JOBS
USER_LIBRARIES
USER_LOBS
USER_LOB_PARTITIONS
USER_LOB_SUBPARTITIONS
USER_METHOD_PARAMS
USER_METHOD_RESULTS
USER_MVIEW_AGGREGATES
USER_MVIEW_ANALYSIS
USER_MVIEW_DETAIL_RELATIONS
USER_MVIEW_JOINS
USER_MVIEW_KEYS
USER_MVIEWS
USER_NESTED_TABLES
USER_OBJECT_TABLES
USER_OBJECTS
USER_OBJECT_SIZE
USER_OBJ_AUDIT_OPTS
USER_OPANCILLARY
USER_OPARGUMENTS
USER_OPBINDINGS
USER_OPERATORS
USER_OUTLINE_HINTS
USER_OUTLINES
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_KEY_COLUMNS
USER_PART_INDEXES
USER_PART_LOBS
USER_PART_TABLES
USER_PARTIAL_DROP_TABS
USER_PASSWORD_LIMITS
USER_POLICIES
USER_QUEUE_SCHEDULES
USER_QUEUE_TABLES
USER_QUEUES
USER_REFRESH
USER_REFRESH_CHILDREN
USER_REFS
USER_REGISTERED_SNAPSHOTS
USER_RESOURCE_LIMITS
USER_ROLE_PRIVS
USER_RSRC_CONSUMER_GROUP_PRIVS
USER_RSRC_MANAGER_SYSTEM_PRIVS
USER_RULESETS
USER_SEGMENTS
USER_SEQUENCES
USER_SNAPSHOTS
USER_SNAPSHOT_LOGS
USER_SNAPSHOT_REFRESH_TIMES
USER_SOURCE
USER_SUBPART_COL_STATISTICS
USER_SUBPART_HISTOGRAMS
USER_SUBPART_KEY_COLUMNS
USER_SYNONYMS
USER_SYS_PRIVS
USER_TAB_COL_STATISTICS
USER_TAB_COLUMNS
USER_TAB_COMMENTS
USER_TAB_HISTOGRAMS
USER_TAB_MODIFICATIONS
USER_TAB_PARTITIONS
USER_TAB_PRIVS
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_RECD
USER_TAB_SUBPARTITIONS
USER_TABLES
USER_TABLESPACES
USER_TRIGGERS
USER_TRIGGER_COLS
USER_TS_QUOTAS
USER_TYPES
USER_TYPE_ATTRS
USER_TYPE_METHODS
USER_UNUSED_COL_TABS
USER_UPDATABLE_COLUMNS
USER_USERS
USER_USTATS
USER_VARRAYS
USER_VIEWS

Du kan undgå describe, hvis du bruge data fra tabellen USER_TAB_COLUMNS.

Se mere på Oracle: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/toc.htm

Du skal evt. registrere dig først.

Tusind tak for hjælpen, det redde min aften...

Tusind tak for hjælpen, det reddede min aften...