select 'select * from ' || t1.table_schema || '.' || t1.table_name || ' where ' || t2.column_name || ' like ''%rakomkakom%'';'
from information_schema.tables t1
right join information_schema.columns t2
on t1.table_name = t2.table_name
and t1.table_schema = t2.table_schema
where t1.table_name not like 'pg%'
and t1.table_schema not in ('pg_catalog', 'information_schema')
and (
t2.data_type in ('text', 'bpchar')
or t2.data_type like 'character%'
);
Note:If you intend to use 32-bit client applications to access 64-bit servers, then you must also install (where available) the latest 32-bit versions of the packages listed in this table.
expdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log
impdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log
ORA-00932: Inconsistent datatypes: expected CHAR got ANYDATA
sqlplus / as sysdba
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = ORCLCDB)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = my-host-name.my-doamin.ru) (PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
lsnrctl stop
lsnrctl start