Hi All,
I was trying to import into one user in my database, but after importing few tables, it got hanged for an hour. I really failed to understand why ? Interesting to know that the categorypartlink tables doesn't have any row.
. . importing table "CATALOG_DETAIL" 0 rows imported
. . importing table "CATEGORYCODES" 0 rows imported
. . importing table "CATEGORYHIERARCHY" 0 rows imported
. . importing table "CATEGORYHIERARCHYLANG" 0 rows imported
. . importing table "CATEGORYHIERARCHYLEVEL" 8 rows imported
. . importing table "CATEGORYHIERARCHYRELATIONSHIP" 0 rows imported
. . importing table "CATEGORYLEVELFORMATLINK" 16 rows imported
. . importing table "CATEGORYPARTFORMATLINK" 0 rows imported
. . importing table "CATEGORYPARTLINK" 0 rows imported
. . importing table "CATEGORYPARTLINKLANG"
when I see into the OEM, this is what I found.
SELECT count(*)
FROM sys.exu9tabu
WHERE owner = :1
AND name = :2
AND bitand(property, 8196) != 0
Execution Steps:
Step # Step Name
33 SELECT STATEMENT
32 SORT [AGGREGATE]
31 . VIEW
30 UNION-ALL
13 NESTED LOOPS [OUTER]
11 NESTED LOOPS
8 NESTED LOOPS
5 NESTED LOOPS
2 SYS.USER$ TABLE ACCESS [BY INDEX ROWID]
1 SYS.I_USER1 INDEX [UNIQUE SCAN]
4 SYS.OBJ$ TABLE ACCESS [BY INDEX ROWID]
3 SYS.I_OBJ2 INDEX [RANGE SCAN]
7 SYS.TAB$ TABLE ACCESS [CLUSTER]
6 SYS.I_OBJ# INDEX [UNIQUE SCAN]
10 SYS.TS$ TABLE ACCESS [CLUSTER]
9 SYS.I_TS# INDEX [UNIQUE SCAN]
12 SYS.I_COM1 INDEX [RANGE SCAN]
29 NESTED LOOPS [OUTER]
27 NESTED LOOPS
24 NESTED LOOPS
21 NESTED LOOPS
18 NESTED LOOPS
15 SYS.USER$ TABLE ACCESS [BY INDEX ROWID]
14 SYS.I_USER1 INDEX [UNIQUE SCAN]
17 SYS.OBJ$ TABLE ACCESS [BY INDEX ROWID]
16 SYS.I_OBJ2 INDEX [RANGE SCAN]
20 SYS.TAB$ TABLE ACCESS [CLUSTER]
19 SYS.I_OBJ# INDEX [UNIQUE SCAN]
23 SYS.IND$ TABLE ACCESS [BY INDEX ROWID]
22 SYS.I_IND1 INDEX [UNIQUE SCAN]
26 SYS.TS$ TABLE ACCESS [CLUSTER]
25 SYS.I_TS# INDEX [UNIQUE SCAN]
28 SYS.I_COM1 INDEX [RANGE SCAN]
hare krishna
Alok