![]() ![]() To avoid the error, see Note 514178 and execute utlvalid.sql for all relevant users. Validation of partitioned objects with VALIDATE STRUCTURE encounters an ORA-14508 error if the utlvalid.sql script was not executed for the executing database user. What problems can occur in connection with partitioning? Avoid redo log data when you delete old data because, unlike a DELETE, a DROP or TRUNCATE does not generate redo log data.Ĥ.Partitioning is transparent for the application and does not require any change to SQL queries and DML statements.You can improve the performance of queries if only specific partitions have to be read.Partitions that are no longer required can simply be dropped (no reorganization to recover disk space and no time consuming DELETEs are necessary).Improved administration because many operations can be carried out on separate partitions (data loads, index creation and rebuilding, backup/recovery and so on).Objects with LONG fields and LONG RAW fields cannot be partitioned.ģ. Table partitioned, relevant index partitioned.Table partitioned, relevant index not partitioned. ![]() Table not partitioned, relevant index partitioned.All combinations are theoretically possible: In the same way as normal tables and indexes, partitions are physical segments for which extents are allocated (see Note 666061). Partitioning is the process of separating data into logical subsets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |