[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TO_NUMBER(SUBSTR(version, 1, 3))
FROM product_component_version
WHERE product like 'Oracle%Enterprise Edition%';
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace_type = p_tablespace_type;
UPDATE gl_storage_parameters
SET tablespace_name = l_tablespace_name;
SELECT distinct dt.tablespace_name
FROM dba_tablespaces dt,
fnd_product_installations fpi
WHERE dt.extent_management = 'DICTIONARY'
AND (dt.tablespace_name = fpi.tablespace
OR dt.tablespace_name = fpi.index_tablespace);
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace_type = p_tablespace_type;
SELECT initial_extent,
allocation_type
FROM dba_tablespaces
WHERE tablespace_name = p_tablespace_name;
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace NOT IN (select tablespace_name
from dba_tablespaces)
AND tablespace_type IN ('TRANSACTION_TABLES', 'TRANSACTION_INDEXES', 'REFERENCE', 'ARCHIVE' ,'SUMMARY', 'INTERFACE', 'MEDIA', 'AQ', 'NOLOGGING', 'TOOLS');
SELECT COUNT(1)
INTO l_cnt
FROM fnd_object_tablespaces;
SELECT COUNT(1)
INTO l_cnt
FROM fnd_tablespaces;
SELECT '1'
FROM dba_users
WHERE username in (select oracle_username
from fnd_oracle_userid
where read_only_flag in ('E','A','U','K','M'))
AND default_tablespace <> (select tablespace
from fnd_tablespaces
where tablespace_type = l_def_tab_tsp);
SELECT '1'
FROM fnd_product_installations
WHERE oracle_id in (select oracle_id
from fnd_oracle_userid
where read_only_flag in ('E','A','U','K','M'))
AND (index_tablespace <> (select tablespace
from fnd_tablespaces
where tablespace_type = l_def_ind_tsp)
OR
tablespace <> (select tablespace
from fnd_tablespaces
where tablespace_type = l_def_tab_tsp));
SELECT is_new_ts_mode
FROM fnd_product_groups;
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace_type = p_tablespace_type;
UPDATE fnd_object_tablespaces fot
SET oracle_username = (select fou.oracle_username
from fnd_product_installations fpi,
fnd_oracle_userid fou
where fpi.oracle_id = fou.oracle_id
and fpi.application_id = fot.application_id)
WHERE oracle_username IS NULL;
SELECT gsp.object_name,
gsp.tablespace_name,
ft.tablespace_type
FROM gl_storage_parameters gsp,
fnd_tablespaces ft
WHERE gsp.tablespace_name = ft.tablespace
AND object_type = 'T';
SELECT dt.owner,
dt.table_name,
fot.object_source,
fot.tablespace_type,
fot.custom_tablespace_type,
fot.custom_flag
FROM dba_tables dt,
fnd_object_tablespaces fot
WHERE dt.table_name like l_table_name||'%'
AND fot.oracle_username(+) = dt.owner
AND fot.object_name(+) = dt.table_name
-- AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')
AND NVL(dt.temporary, 'N') = 'N'
AND NOT EXISTS ( select ds.table_name
from dba_snapshots ds
where ds.owner = dt.owner
and ds.table_name = dt.table_name)
AND NOT EXISTS ( select dsl.log_table
from dba_snapshot_logs dsl
where dsl.log_owner = dt.owner
and dsl.log_table = dt.table_name)
AND NOT EXISTS ( select dqt.queue_table
from dba_queue_tables dqt
where dqt.owner = dt.owner
and dqt.queue_table = dt.table_name)
AND dt.table_name not like 'AQ$%'
AND dt.table_name not like 'DR$'
AND dt.table_name NOT LIKE 'RUPD$%'
ORDER BY dt.owner;
SELECT fpi.application_id
FROM fnd_product_installations fpi,
fnd_oracle_userid fou
WHERE fpi.oracle_id = fou.oracle_id
AND fou.oracle_username = l_oracle_username
ORDER BY fpi.application_id;
FND_OBJECT_TABLESPACES_PKG.INSERT_ROW
(l_rowid,
l_app_id,
l_table_name,
'TABLE',
gl_rec.tablespace_type,
NULL,
'RULES',
l_owner,
NULL,
SYSDATE,
g_user_id,
SYSDATE,
g_user_id,
g_login_id);
FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW
(l_app_id,
l_table_name,
'TABLE',
gl_rec.tablespace_type,
l_custom_tsp_type,
'RULES',
l_owner,
l_custom_flag,
SYSDATE,
g_user_id,
g_login_id);
SELECT rule_id,
rule_query,
tablespace_type
FROM fnd_ts_mig_rules
ORDER BY rule_id;
SELECT fpi.application_id
FROM fnd_product_installations fpi,
fnd_oracle_userid fou
WHERE fpi.oracle_id = fou.oracle_id
AND fou.oracle_username = l_oracle_username
ORDER BY fpi.application_id;
query := 'SELECT dt.owner, dt.table_name, fot.object_source,
fot.tablespace_type, fot.custom_tablespace_type,
fot.custom_flag
FROM dba_tables dt, fnd_object_tablespaces fot
'||rules_rec.rule_query||'
AND fot.oracle_username(+) = dt.owner
AND fot.object_name(+) = dt.table_name
AND NVL(dt.iot_type, ''X'') NOT IN (''IOT'', ''IOT_OVERFLOW'')
AND NVL(dt.temporary, ''N'') = ''N''
AND dt.owner IN (select oracle_username
from fnd_oracle_userid
where read_only_flag IN (''E'',''A'',''U'',''K'',''M''))
AND NOT EXISTS ( select ds.table_name
from dba_snapshots ds
where ds.owner = dt.owner
and ds.table_name = dt.table_name)
AND NOT EXISTS ( select dsl.log_table
from dba_snapshot_logs dsl
where dsl.log_owner = dt.owner
and dsl.log_table = dt.table_name)
AND NOT EXISTS ( select dqt.queue_table
from dba_queue_tables dqt
where dqt.owner = dt.owner
and dqt.queue_table = dt.table_name)
AND dt.table_name not like ''AQ$%''
AND dt.table_name not like ''DR$''
AND dt.table_name NOT LIKE ''RUPD$%''
ORDER BY dt.owner';
FND_OBJECT_TABLESPACES_PKG.INSERT_ROW
(l_rowid,
l_app_id,
l_table_name,
'TABLE',
rules_rec.tablespace_type,
NULL,
'RULES',
l_owner,
NULL,
SYSDATE,
g_user_id,
SYSDATE,
g_user_id,
g_login_id);
FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW
(l_app_id,
l_table_name,
'TABLE',
rules_rec.tablespace_type,
l_custom_tsp_type,
'RULES',
l_owner,
l_custom_flag,
SYSDATE,
g_user_id,
g_login_id);
SELECT oracle_id,
oracle_username
FROM fnd_oracle_userid
WHERE read_only_flag in ('E', 'A', 'U', 'K', 'M')
ORDER by oracle_username;
SELECT dtq.tablespace_name
FROM dba_ts_quotas dtq
WHERE dtq.username = p_username
AND EXISTS (select dt.tablespace_name
from dba_tablespaces dt
where dt.tablespace_name = dtq.tablespace_name)
ORDER by dtq.tablespace_name;
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace_type = l_def_tab_tsp;
SELECT tablespace
FROM fnd_tablespaces
WHERE tablespace_type = l_def_ind_tsp;
SELECT ft.tablespace
FROM fnd_tablespaces ft;
UPDATE fnd_product_installations
SET tablespace = l_txn_tablespace,
index_tablespace = l_txn_ind_tablespace
WHERE oracle_id = usr_rec.oracle_id;
UPDATE fnd_product_groups
SET is_new_ts_mode = 'Y';
SELECT pre_name
FROM CTX_USER_PREFERENCES
WHERE PRE_NAME = 'TXN_IND_STORAGE_PREF';