Oracle Enterprise Manager - Table View
Setup
Preferences
Help
Logout
Database Instance: ablinux
>
Tables
>
View Table: BALHAL.CIKK
Logged in As SYSTEM
View Table: BALHAL.CIKK
Actions
Create Like
Create Index
Create Synonym
Create Trigger
Generate DDL
Object Privileges
Manage Optimizer Statistics
Reorganize
Run Segment Advisor
Shrink Segment
Show Dependencies
View Data
Flashback Table
Flashback Versions Query
General
Name
CIKK
Schema
BALHAL
Tablespace
USERS
Organization
Standard, Heap Organized
Columns
Name
Data Type
Size
Scale
Not NULL
Default Value
CKOD
NUMBER
CNEV
VARCHAR2
20
SZIN
VARCHAR2
15
SULY
FLOAT
126
Indicates a Primary Key column
Indicates a Unique Key column
Constraints
Previous
Next
Name
Type
Table Columns
Disabled
Deferrable
Initially Deferred
Validate
RELY
No constraints have been defined.
Indexes
Number of Indexes
0
Schema.Index
Indexed Columns
Column Position
No object found.
Storage
Tablespace
Name
USERS
Extent Management
Local
Segment Management
Automatic
Logging
Yes
Space Usage
Free Space (PCTFREE)(%)
10
Number of Transactions
Initial
1
Maximum
255
Buffer Pool
Buffer Pool
DEFAULT
Options
Parallel Degree
Disabled
Enable Row Movement
No
Cache
Disabled
Statistics
Last Analyzed
2009.03.05. 22:00:04
Empty Blocks
0
Average Space
0
Number of Rows
1000
Sample Size
1000
Average Row Length
18
Continued Row Count
0
Average Space Freelist Blocks
0
Number of Freelist Blocks
0
Actions
Create Like
Create Index
Create Synonym
Create Trigger
Generate DDL
Object Privileges
Manage Optimizer Statistics
Reorganize
Run Segment Advisor
Shrink Segment
Show Dependencies
View Data
Flashback Table
Flashback Versions Query
Database
|
Setup
|
Preferences
|
Help
|
Logout
Copyright © 1996, 2005, Oracle. All rights reserved.
About Oracle Enterprise Manager 10g Database Control