|
1) run 'catexp6.sql' as sys on the v7 database (this will establish the views needed for a v6 export. 2) From the v6, set up TWO_TASK to point to the v7 database, then perform the export. 19. Q. What do I do if Drop tablespace is hanging in v6? A. Make sure that the DC_ parameters are high enough. dc_free_extents > select count(*) from sys.fet$; dc_used_extents > select count(*) from sys.uet$; row_cache_enqueue >= dc_free_extents + dc_used_extents; 20. Q. How many blocks are actually used by the data in my tables ? A. This query will count all the blocks occupied by the table's data: select count(distinct(substr(ROWID, 1, 8) || (substr(ROWID, 15, 4)) from 21. Q. How can I find all the duplicate entries in a table ? A. select * from real_table_name X where rowid < (select max(ROWID) from real_table_name where col1=X.col1 and col2=X.col2 .....) ; (责任编辑：编程世界) |