APPS.FND_TS_MIG_UTIL dependencies on DBA_TABLESPACES

Line 48: FROM dba_tablespaces dt,

44: PROCEDURE migrate_tsp_to_local
45: IS
46: CURSOR tsp_csr IS
47: SELECT distinct dt.tablespace_name
48: FROM dba_tablespaces dt,
49: fnd_product_installations fpi
50: WHERE dt.extent_management = 'DICTIONARY'
51: AND (dt.tablespace_name = fpi.tablespace
52: OR dt.tablespace_name = fpi.index_tablespace);

Line 53: l_tablespace_name DBA_TABLESPACES.TABLESPACE_NAME%TYPE;

49: fnd_product_installations fpi
50: WHERE dt.extent_management = 'DICTIONARY'
51: AND (dt.tablespace_name = fpi.tablespace
52: OR dt.tablespace_name = fpi.index_tablespace);
53: l_tablespace_name DBA_TABLESPACES.TABLESPACE_NAME%TYPE;
54: BEGIN
55: OPEN tsp_csr;
56: LOOP
57: FETCH tsp_csr INTO l_tablespace_name;

Line 90: FROM dba_tablespaces

86: IS
87: CURSOR tbs_ues_csr IS
88: SELECT initial_extent,
89: allocation_type
90: FROM dba_tablespaces
91: WHERE tablespace_name = p_tablespace_name;
92: l_ues NUMBER;
93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;
94: BEGIN

Line 93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;

89: allocation_type
90: FROM dba_tablespaces
91: WHERE tablespace_name = p_tablespace_name;
92: l_ues NUMBER;
93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;
94: BEGIN
95: OPEN tbs_ues_csr;
96: FETCH tbs_ues_csr INTO l_ues, l_allocation_type;
97: if tbs_ues_csr%NOTFOUND then

Line 116: from dba_tablespaces)

112: CURSOR tsp_csr IS
113: SELECT tablespace
114: FROM fnd_tablespaces
115: WHERE tablespace NOT IN (select tablespace_name
116: from dba_tablespaces)
117: AND tablespace_type IN ('TRANSACTION_TABLES', 'TRANSACTION_INDEXES', 'REFERENCE', 'ARCHIVE' ,'SUMMARY', 'INTERFACE', 'MEDIA', 'AQ', 'NOLOGGING', 'TOOLS');
118: l_tablespace_name VARCHAR2(30);
119: BEGIN
120: OPEN tsp_csr;

Line 511: from dba_tablespaces dt

507: SELECT dtq.tablespace_name
508: FROM dba_ts_quotas dtq
509: WHERE dtq.username = p_username
510: AND EXISTS (select dt.tablespace_name
511: from dba_tablespaces dt
512: where dt.tablespace_name = dtq.tablespace_name)
513: ORDER by dtq.tablespace_name;
514:
515: CURSOR txn_tsp_csr IS