Questions tagged [sysdba]
sysdba is an Oracle Database system privilege.
48 questions
0 votes
0 answers
61 views
SQL Backup folder permission issue
Having an issue on one of our SQL servers at work in which the SQL backup folder permissions are not right and the folder is inaccessible. I just noticed this problem when attempting to setup nightly ...
0 votes
1 answer
680 views
SYS user getting ORA-01017 (invalid username/password; logon denied) even putting right password in Oracle 19c
→ OS: Oracle Linux Server release 8.7 → DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0 After cloning a virtual machine that we can connect normally ...
0 votes
0 answers
82 views
Copying data from old column to new column with large amount of records
While updating/copying the data from old column to new column we are facing the issue with tablespaces in database. Records count: 158 million+ Using below query to update the records, UPDATE ...
0 votes
1 answer
269 views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link? I am getting ORA-00942: table or view does not exist when tried to query the same.
- 23
0 votes
1 answer
545 views
Why is the SYS user granted both the DBA role and the SYSDBA privilege?
If the SYSDBA privilege gives the grantee ultimate authority, then why does the SYS user also have the DBA role in addition to the SYSDBA privilege?
- 131
2 votes
0 answers
261 views
Resuming PostgreSQL logical replication (missing pg_stat_replication entry)
I implemented a logical replication on PostgreSQL 14 (from AWS to on-premise) via windows. A few days we experience internet lags. When i checked the pg_stat_replication in publication source, it was ...
0 votes
1 answer
871 views
How to we get history of sql statements of sysdba?
We have been running a list of commands in cli: sqlplus / as sysdba We did not have "history on" and we logged out of the session. How do we get the list of sql statements we ran before as ...
0 votes
1 answer
44 views
Migration db (error when alter DB)
i am new as DBA. i want to migrate db, can i do one time alter for all data ?. or must one alter to one data ? this my query. DECLARE @name VARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM ...
