New answers tagged oracle
0
votes
ORA-28040: No matching authentication protocol
The error can have two different root causes:
DB server and Client's driver are not compatible and can not agree on common password hashing algorithm
User's password is only stored as an new(old) ...
- 1,584
0
votes
impdp failing in AWS RDS - seems RDS internal package (RDS_SYS_TRIGGER_UTIL) is missing or invalid?
Does BBR6 have the necessary privileges to run the import in the dev database? For e.g., is the role DATAPUMP_IMP_FULL_DATABASE assigned to it there? (In that database, select * from user_role_privs;...
- 11
0
votes
sqldeveloper export tool ignores filter by schema
This is old, but I wasn't able to find a satisfying answer anywhere.
After some experimentation I figured out how the process works, and it's kind of ridiculous.
On the "Types to Export" ...
- 1
-1
votes
Unable to connect to auxiliary database
Was the WIEN instance started NOMOUNT? The status BLOCKED implies it. I think you should be using the regular service name for GRAZ, not the _DGMGRL one. If you haven't already copied across the ...
0
votes
ODI-26211 "Mapping name is not unique" error — even with fresh repository and no agent
If you're using a 19c database, you'll need to upgrade to 19.27 or later, which also has the ODI repository installed. Lower versions have issues with XML and JSON interpretation. If you're using a ...
0
votes
SQL combination implementation
Well, I don't see any join in your example. My guess is that you want something like
SELECT
A.owner AS owner_A, A.table_name AS table_name_A,
B.owner AS owner_B, B.table_name AS table_name_B
...
- 1,327
0
votes
Wrong size of archive log?
Obviously I was looking on the wrong place. Correct parameter to manage might bealter system set db_recovery_file_dest_size=60G scope=both;
- 213
0
votes
Oracle - Set Object to NonEditionable
select 'alter ' || OBJECT_TYPE || ' ' || OBJECT_NAME || ' noneditionable;'
from ALL_OBJECTS
where OWNER='xy'
and EDITIONABLE = 'Y'
order by 1,2;
Top 50 recent answers are included