/                                                                                                                                                  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                                                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                                                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                                                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~     contents[[Ljava/lang/Object;()VCodeLineNumberTable getContents()[[Ljava/lang/Object; SourceFile VtosMsg.java [Ljava/lang/Object;java/lang/Object3001Cluster3002 Database Link3003Function3004Index3005 Package Body3006Package3007 Procedure3008 Refresh Group3009Sequence3010Snapshot3011 Snapshot Log3012Synonym3013Table3014Trigger3015View3016General3017Name:5136Constraint Name:3018Schema: 3019 Query Text:3020Advanced3021Options3022Replace if Exists3023Force3024 Read Only3025 Constraint3026With Check Option3027Status:3028Public3029Connection Details3030 Current User3031Connected User3032 Fixed User3033 Username:3034 Password:3035 Service Name:3036Test3037The Database Link is active.3038 The Database Link is not active.3039 Tablespace:3040Size:3041Type:3042Number of Hash Keys:3043Hash Function:3044Default3045 Expression3046Cluster Key Columns3047 Hash Cluster3048 Index Cluster3049Name3050Datatype3051Size3052Scale3055 Ascending3056 Descending3057Values3058Minimum:3059Maximum:3060Initial:3061 Last Number:30623063 Cycle Values3064 Order Values3065Cache3066No Cache3160 Monitoring30673068values3069 Interval:3071local database3072remote database3073 Object Type:3074DB Link:3075Object:3076 As Alias For:3077 High Value3078 High Values3079Table:3080Index:3081 Partitions3082Columns3083Partition Columns3084 Table Columns3085 Index Columns3086Partitions in Table3087Partitions in Index3088 Partition3089 Tablespace3092Blocks:3093 Leaf Blocks:3095OK3096Cancel3144 Java Source5000 Resolvers3099 Exchange...3100Make Local Indices Unusable3101Rebuild Unusable Local Indices3102Split...3103Truncate Deallocated Storage3104Reuse Deallocated Storage3106Index Partition3107Table Partition3108 Table Wizard3109Add3110Remove3111Edit3112+Column is already in partition column list.3113JOperation will remove all the existing partitions, do you want to proceed?3114Delete31153117`Operation will remove all the existing partitions and partition columns, do you want to proceed?3118Partition Type: 3119Local3120Global3121 Queue Table3122Queue3123 Array Type3124 Table Type3125 Object Type2000If you keep the partition columns that you have specified, you must create at least one partition; otherwise, remove the partition columns.3126 Insert Before3127 Insert After3128Move Up3129 Move Down20010Do you want to remove all the partition columns?3131Exchange Partition 2004You must select a table3134 Select the non-Partitioned table3135Aliases:3136 As Object3138Specify Attributes3145Move Partition 3146Split Partition 3147%Local Index Operations for Partition 3148Truncate Partition 3149Merge Partition 3150Partition Name3151{0} - High values3152Range partition column order3153Hash partition column order3154Index Partition Name3155 Restrictions3156 Constraints:3139 31403141 314231433500 Index On:3502Unique3505Index On Table:3506Index On Cluster:35073508Cluster Columns3509Order3510Bitmap3511Unsorted3512Reverse3513 No Logging3514 Unrecoverable3515Key Compression3516Prefix Length:35993600Define Columns3601 Define Query3602 Constraints3603Constraint on the Table36043605Referenced Columns3606Constraint Definition : 360736083609Type3610Disable?3856RELY (Do Not Enforce)?3909 No Validate?3611Referenced Schema3612Referenced Table3613Cascade On Delete3614Check Condition5622 Deferrable?5664Initially Deferred?3615361636173618Nulls?3619 Default Value3620!Define table as part of a Cluster3621Cluster:3622 Table Column3623Cluster Column36243625Constraints can't be defined for the table being created using a query. This is either because no query is specified on the General page or because the query specified is incorrect.3626 Nested Tables3627"Please Enter Nested Table Name(s):3628Scope3629Schema363036313632Drop3633Ref3634 Scope Schema3635 Scope Table3636 Object Table3637Nested Tables...3638The query used to create the table has been changed. The change(s) may affect the constraints you've defined on the table. Do you want to remove the constraints already defined?3639!The query specified is incorrect.3640,Partitioning is not available for the table.3641The query used to create the table has been changed. The change(s) may affect the partitions you've added to the table. Do you want to remove the partitions already added?3642*Clustering is not available for the table.3644Standard3645Organized Using Index (IOT)3646With Overflow Data Segment3647Overflow3648Data Storage...3649$Percentage Threshold (PCTTHRESHOLD):3650Include Column (INCLUDING):3651All Partitions3652Specific Partition3653)Overflow Data Segment Physical Properties3654Overflow Segment Partitions3655!Physical Properties for Partition3656Clustering is not available for the table being created using a query. This is either because no query is specified on the General page or because the query specified is incorrect.3657=Index-Organized Tables (IOT's) cannot be stored in a cluster.3658Primary Key Columns3659Partitioning is not available for the table being created using a query. This is either because no query is specified on the General page or because the query specified is incorrect.3660You must define a primary key for the Index-Organized Table (IOT) before you define partitions. Please go to the Constraints page to define a primary key.36623663"Overflow Data Segment Storage for 3664'Overflow Segment Storage for Partition 3665zYou are creating a cluster index. Partitioning is only supported for a table index whose underlying table is unclustered.3666Partition type:3667Range3668Hash3669 Composite3670XChoose the partition columns on which you want to partition the table on and order them.3671 Hash Panel3672Composite Panel3673Range Partitions:3674Enter the names of the partitions and their high values. Oracle Enterprise Manager will decide how the data should be partitioned based on the informantion you have entered.3675Click the 'Autogenerate' button to display the 'Create Autogenerated Partitions' dialog box which allows you to enter information about the time range or data range for the partitions and the number of partitions to be created for your table.3676Autogenerate...3677 Set MAXVALUE3682Unset MAXVALUE3678 Customize...3679_PART136803There are no rows selected in the range partitions.36988You cannot drop the highest partition in a global index.3699/You cannot drop the partition of a local index.3710If you switch from a LOCAL partitioned index to GLOBAL partitioned index, you CANNOT switch back. Do you still want to proceed?3683Merge the contents of this and an adjacent partition into a new partition. The original two partitions are dropped. The new partition will be given an Oracle generated name. You can specify a new name and customize storage options. The partition will be given an Oracle generated name, but you can specify another name by selecting the New Partition Name box below and entering a new name.3684 Partition:3685&Select the partition to be merged with36863687%Specify options for the new partition3688#Perform merge operation as parallel37009You cannot do a merge on a table with only one partition.3689kMove this partition to another tablespace. If the partition has data, the following will be marked unusable3690/ * all corresponding local index partitions.3691( * all global nonpartitioned indexes.36927 * all the partitions of global partitioned indexes.3693Select the tablespace3694 Tablespace: 3695"Perform move operation as parallel3696Split this partition into two new partitions. Each new partition will be created with a new segment and physical attributes. The segment associated with the old partition is discarded.3697#Perform split operation as parallel3720F{0}in an Index Organized Table (IOT) is not supported in your database3721Dropping a table removes the table definition from the data dictionary. All rows of the table are no longer accessible. All associated indexes and triggers are dropped. All associated views, PL/SQL program units and synonyms remain but become invalid.3722BSome columns of this table have been renamed. This may cause certain dependent objects of this table to become invalid. Press Show Dependents button to view dependent objects that may become invalid. You will need to change references to old column names in these objects to make them valid. Apply changes to this table?3723Show Dependents...3724Table Dependents3725Following objects reference one or more columns of this table. Renaming of columns may cause these objects to become invalid. The list below excludes those dependent objects that are not affected by column rename.3726 Dependents3727 Save List...3728(no dependents found)3709 Introduction3701Columns Definition3702Primary Key Definition3703Foreign Constraint3704Null and Unique Constraints3705Check Constraints3706Review3707Storage Information3708Use Abstract Datatype3711"Show default value for all columns3750'Remove all rows from the partition. If this partition contains data, you must first disable any referential integrity constraints on the table. Alternatively, you can delete the rows and then truncate the partition. If the storage option is not specified, the storage will be dropped by default.3751Storage options3752Reuse storage : keeps space from the deleted rows allocated to the partition or subpartition. The space is subsequently available only for inserts and updates to the same partition or subpartition.3753Drop storage : deallocates space from the deleted rows and makes it available for use by other schema objects in the tablespace.37630Are you sure you want to truncate partition {0}?3754=Make the local indexes unusable or rebuild the local indexes.3755Make the local indexes unusable3756"Rebuild the unusable local indexes3764GAre you sure you want to Make Local Indexes Unusable for partition {0}?3765JAre you sure you want to Rebuild Unusable Local Indexes for partition {0}?3757Convert this partition into a nonpartitioned table and convert a nonpartitioned table into a partition of a partitioned table by exchanging their data.3758Restrictions are listed below:37592 * Both tables must have same number of columns3760 * Both tables must have the same primary key, and no validated foreign keys must reference either of the tables unless the referenced table is empty3762FExchange local index partitions with the corresponding regular indexes3761+Do not check for the proper mapping of rows3800380138023803 Column Name:3804Column Datatype:38053806Scale:3807;Does this column have a default value? If so, please enter.3808Insert38092006Specify a name for the column3813Is this column a Foreign Key?3814#No, the column is not a Foreign Key3815 Yes, the column is a Foreign Key3816TA Foreign Key can be specified by selecting a Schema, a Table and one of its Columns3817Referenced Schema:3818Referenced Table:3819Referenced Column:3821Can the column value be Null?3822Yes, it can be Null3823No, it cannot be Null3824(Does the column value have to be Unique?3825Yes, it must be Unique3826!No, it does not have to be Unique38281What do you want the Name of the new table to be?38291Which Schema do you want the table to be part of?38304Which Tablespace do you want to create the table in?2007specify a name for the table3832(Does this column have a Check Condition?3833/No, the column doesn't have any Check Condition3834%Yes, the column has a Check Condition3835,What is the Check Condition for this column?3836Example:3837dept_num BETWEEN 10 AND 993838dept_name = UPPER(dept_name)3839+dept_loc in ('Dallas', 'Boston', 'Chicago')3840Primary Key Constraint38413Do you want to create a primary key for this table?3842(No, I don't want to create a primary key3843#Yes, I want to create a primary key3844Review Table Definition3845KColumns order can be changed by selecting a column and moving it Up or Down3846Primary Key Order38473848 3849Properties of column : {0}3850Columns defined :3851#Override default storage parameters3852Specify initial number of rows3853Specify growth rate3854constraints on column : {0}3855'Multiple Constraints cannot be modified3858Constraints Storage38595Generate full redo for CONSTRAINT data pages(LOGGING)3860$Constraint Data Segment Storage for 38613857=Constraint must be enabled for the constraint to be enforced.3900Source39013903Invalid3904Compile3905 Show Errors3906 Hide Errors3907Errors3908Hide4000 Trigger On4001 On Schema:4002 On Table:4003 On Cluster:4004Replace If Exists4005Enable4006 Trigger Body:4007Timing4008Triggering Statement4009 Fire Trigger:4010Before4011After401240134014Update of Columns4015Trigger for Each Row4016 Referencing4017Old as:4018New as:4019 Condition:4020 Column Name4021 Fire Trigger?4022 Instead Of4023Event4024 Event Type4025402640274028 Parent as:40294030Database4031Trigger On Table4032View:4033Update4034Methods4100Storage41014102Use Cluster Parameters4103Extents4104 Initial Size:4105 Next Size:4106Increase Size by:4107Minimum Number:4108Maximum Number:4109Value4110 Unlimited4111 Space Usage4112+Percentage free space reserved for updates:4113Listing Chained Rows is supported only for tables and clusters5500 Dimension5501Dimension Wizard5503+This dimension will be an OLAP invalid one.5600Last Analyzed:5601Number of Rows:5602 Sample Size:5604 Empty Blocks:5605Average Space:5606Average Row Length:5607Continued Row Count:5608Average Space Freelist Blks:5609No. of Freelist Blks:5610 Tree Height:5611Distinct Keys:5612Clustering Factor:56135614Average Leaf Blocks/Key:5615Average Data Blocks/Key:56165617Override Default Logging Value5618Logging5619GLOGGING - Redo logs are generated. Updates are slower but recoverable.5620PNOLOGGING - No redo logs are generated. Updates are faster but not recoverable.5621FPlace frequently accessed data to the top of the buffer cache. (CACHE)56639MONITORING - Collects modification statistics on a table.5669ANOMONITORING - Not to collect modification statistics on a table.5502Summary Advisor Wizard5550Workload consists of SQL statements and related metics. Select any of the following filters to limit the workload scope. Make sure the names in the list are separated by commas for any of the filter types below.5557=Make sure the trace collection names are separated by commas.5551Filter by applications:5552 Select ...5553-Filter by sum of cardinalities of base tables5554Filter by last execution date5555Filter by number of executions5556-Filter by users executing the SQL statements:55293Filter by schemas referenced by the SQL statements:5558&Filter by user-supplied priority value55593Filter by tables refereneced by the SQL statements:5561Filter by response time5563Filter by collection names:5565You have selected to filter your workload by application name, but have not entered any name in the application list field. You must enter at least one application name in that field before you are allowed to continue.5566You have selected to filter your workload by cardintality, but have not entered the minimum cardinality. You must enter the minimum cardinality before you are allowed to continue.5592You have selected to filter your workload by cardintality, but have not entered the maximum cardinality. You must enter the maximum cardinality before you are allowed to continue.5567DThe maximum cardinality cannot be less than the minimum cardinality.5568HThe maximum last use date cannot be less than the minimum last use date.5569You have selected to filter your workload by frequency, but have not entered the minimum frequency. You must enter the minimum frequency before you are allowed to continue.5593You have selected to filter your workload by frequency, but have not entered the maximum frequency. You must enter the maximum frequency before you are allowed to continue.5570@The maximum frequency cannot be less than the minimum frequency.5571You have selected to filter your workload by owner, but have not entered any name in the user list field. You must enter at least one user name in that field before you are allowed to continue.5599You have selected to filter your workload by schema, but have not entered any name in the schema list field. You must enter at least one schema name in that field before you are allowed to continue.5572You have selected to filter your workload by priority, but have not entered the minimum priority. You must enter the minimum priority before you are allowed to continue.5594You have selected to filter your workload by priority, but have not entered the maximum priority. You must enter the maximum priority before you are allowed to continue.5573>The maximum priority cannot be less than the minimum priority.5574You have selected to filter your workload by base table, but have not entered any name in the table list field. You must enter at least one table name in that field before you are allowed to continue.5575You have selected to filter your workload by response time, but have not entered the minimum response time. You must enter the minimum response time before you are allowed to continue.5595You have selected to filter your workload by response time, but have not entered the maximum response time. You must enter the maximum response time before you are allowed to continue.5576HThe maximum response time cannot be less than the minimum response time.5577VPlease specify the minimum collection id or unselect the collection id type of filter.5578LThe maximum collection id you just specified is less than the minimum value.5579You have selected to filter your workload by trace name, but have not entered any name in the collection name list field. You must enter at least one collection name in that field before you are allowed to continue.5580Select Application List5581PPlease select the workload applications from the following list of applications:5582Select Owner List5583DPlease select the workload owners from the following list of owners:5530Select Schema List5531FPlease select the workload schemas from the following list of schemas:5584Select Base Table List5585IPlease select the workload base tables from the following list of tables:5586Select Trace Name List5587NPlease select the workload trace names from the following list of trace names:55884Sorry, no application can be found on this database.5589ESorry, no Oracle Trace collection name can be found on this database.5590SQL5591Trace55465547KB5548MB5549GB5545Summary Recommendations5543 New Summary5544Existing Summary5542 Target Point5541Total space for all summaries: 5540 Show Subquery5536 Create/Retain5537Recommendations shown below are based on the target performance gain you have chosen. For each summary to be created, you can modify its name, schema, tablespace, and refresh method property in the table below. You cannot edit a summary which will be retained.5535Recommendations shown below are based on the target performance gain you have chosen. For each summary you can modify its name, schema, tablespace, and refresh method property in the table below.55385539dRecommendations to drop certain existing summaries are shown below. The drops are recommended either because those existing summaries contribute to performance beyond the target point or because they are used less often. If you want to retain any of the summaries, uncheck them from the list. The Summary Advisor will then re-calculate its recommendations.5534You have chosen not to drop certain existing summaries. As a result, the Summary Advisor will re-calculate the recommendations. Do you want to perform the operation now?5533?If you set space usage to {0} you will get {1} performance gain5532Performance Gain (%)55970You must select one or more items from the list.55981You must select one or more tables from the tree.55105The materialized view has been compiled successfully.5623Partitioning allows you to physically group data in your table. Range partitioning divides the data according to a range of values in a particular column, and is particularly useful if you will have at least 2GB of data in the table.5624Partitions Option56254Do you want to use range partitioning on this table?5626*No, I do not want to partition this table.56278Yes, use range partitioning using a column in the table.5628Column:5629 Data Type:5630Partitions Data5631=What is the earliest date which will be found in this column?5632Date:56332What length of time do you want in each partition?5634Range:5635YEAR5636MONTH5637DAY5638WEEK5639 How many partitions do you want?5640 Partitions:5641Number:5642?Will you be adding more partitions to this table in the future?5643.Yes, I will add more partitions in the future.56441No, I will not add more partitions in the future.5645Partitions Details5646Partitions Index Definition5647Partitions Index Details5665Range field can not be empty.5666%Lowest number field can not be empty.5667(Partition number field can not be empty.5668Using autogenerate will wipe out all the partitions you have created. Are you sure you want to use the autogenerated partitions instead?5648~Are you sure you want only one column in the table? Press the 'Add' button in the Columns Definition page to add more columns.5649Based on the partitioning data you provided, the following partitions will be created. You can edit the data ranges, or return to the previous page to change the number of partitions.5650PYou can optimize your partitions by selecting which tablespaces they will be in.5651[For faster access to your partition data, a local prefixed partition index will be created.5652The {0} column will be the first column in the index. You can choose to include other columns in the index to improve search capabilities on those columns.5653 IDX_{0}_{1}5654GYou can name your index partitions and put them in separate tablespace.5655SQL generated:5656?What is the smallest number which will be found in this column?56574What range of numbers do you want in each partition?5658Drop Column Expression5659Add Column Expression5660Function-Based Index Status:56615662 Enable Index5700Constraint Column Details5701Lob Storage Details5702 Object Schema5703Referenced Schema5704Referenced Table5705Cascade On Delete5706Data Storage for Lob5707Yes5708No5709Object Definition5711Data Storage for Constraint5800You are creating a bitmap index on a non-partitioned table. Partitioning is only supported for a bitmap index whose underlying table is partitioned.5801CTable with LONG or LONG RAW datatype columns cannot be partitioned.5802'Clustered tables cannot be partitioned.5803sThe table you are creating contains duplicate column names. Please rename those columns before creating partitions5805Any changes to data block space parameters, transaction entry parameters, or storage parameters are not allowed for clustered table. Oracle uses the parameters of the cluster for all clustered tables.5819?Only range partitioned tables are supported in current version.5818XChoose the partition columns on which you want to partition the index on and order them.5812Purge5813 Purge SQL Log5814;Specify the records you want to purge in the SQL Log table.5815Rows5816Delete all the rows in the log5817Delete the selected rows58245821Contents Of SQL Log5820Generate Report For SQL Log5822 Table Mode5823 OEM User:3766Autogenerated Partitions5710Constraint Storage Details58045900`The selected object has been compiled successfully. Check with individual object for any errors.5901bThe selected objects have been compiled successfully. Check with individual object for any errors.5902LThis can be a very time consuming operation. Do you want to do it right now?5905 No Parallel5906NPlace least frequently accessed data to the end of the buffer cache. (NOCACHE)5907Parallel Option5908Logging Option5909Caching Option5910Monitoring Option5950Create595159525953 From Type5954To Type5955Transformation Expression5956Transformations5957AFollowing are the transformations for all schemas in the database5958Create Transformation5959Edit Transformation5960Transformation Function5961Use Existing Function5962 Function:5963Transform From5964 Transform To5965CPlease select the transform function or provide the sql expression.5966-Make sure all the required inputs are filled.5967