tables as sys.
18. Q. Why is 'Character type conversion 3 to 1 not supported' on an import?
A. That's import telling you it's trying to load a varchar into a char.
You need to get a v6 export of the v7 database by using the v6 export
utility against the v7 database:
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 .....) ;
