User pmdba

22 votes

Can ransomware embed itself in to a SQL backup file?

answered May 11, 2022 at 22:44

4 votes

Accepted

Oracle 12c - Logon Trigger According To Machine Information

answered Nov 7, 2021 at 1:10

4 votes

Accepted

How to read the select statement to understand the result

answered Dec 18, 2020 at 4:02

4 votes

Accepted

how to resolve the error "ADMIN option not granted for role 'my_role_1'"

answered Jun 15, 2020 at 14:31

4 votes

Accepted

Oracle database: how to change varchar length of same column in multiple tables in one go?

answered Aug 10 at 11:47

3 votes

How Does a Database that Supports TDE Work In Practice?

answered Nov 23 at 13:28

3 votes

Accepted

ORA-06502: 'character string buffer too small' when writing to a csv

answered Aug 29, 2020 at 13:11

3 votes

Accepted

oracle - hashing method, excluding DBMS_CRYPTO

answered Sep 18, 2020 at 2:55

3 votes

Use of Parallel hints in a SQL query

answered Oct 10, 2020 at 4:25

3 votes

Accepted

How do I SHOW TABLES in Oracle Database?

answered Nov 13, 2021 at 0:31

3 votes

Accepted

How to get Full Plan in Oracle?

answered Jul 25, 2021 at 0:21

2 votes

schema ownership/permissions in MS-SQL vs Oracle

answered Jun 17, 2022 at 16:12

2 votes

How secure is a local harddrive stored database?

answered Jul 5, 2022 at 2:37

2 votes

I tried running this script, but i kept getting not a group by error

answered Oct 15, 2021 at 17:08

2 votes

Accepted

understanding oracle pluggable databases

answered Apr 2, 2022 at 2:48

2 votes

Accepted

Oracle NET - How to enable SOURCE_ROUTE with LOAD_BALANCE and FAILOVER?

answered Sep 23, 2022 at 22:41

2 votes

How to change password version by myself in oracle?

answered Feb 28, 2021 at 11:51

2 votes

Choosing the right blocksize for Oracle Database tablespaces with lobs

answered Mar 2, 2021 at 19:54

2 votes

Migrating data from 11G Linux to 19C on Windows

answered Dec 17, 2020 at 5:02

2 votes

SPFILE invalid after being edited in Windows

answered Aug 2, 2021 at 12:24

2 votes

Oracle - Understanding Password Hash Versions

answered Aug 11, 2021 at 18:33

2 votes

Why is a port needed for DBMS?

answered Nov 4, 2020 at 5:46

2 votes

Accepted

ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

answered Sep 28, 2020 at 3:44

2 votes

Oracle - LRM-00109: could not open parameter file

answered Aug 11, 2020 at 2:21

2 votes

Oracle - Is a separate database more secure than using the same database and a separate schema

answered Jul 2, 2020 at 20:50

2 votes

Accepted

Oracle 11gR2 - How To Audit SYS.USER$ Table

answered Jul 24, 2020 at 10:23

2 votes

How to add a new listener on a new port and restrict it to one instance only

answered Jun 29, 2020 at 4:10

2 votes

Accepted

Audit all insert, delete, update and select statements on a schema in Oracle 12.2

answered Jun 8, 2020 at 13:30

2 votes

Accepted

Oracle DB : Export only table data from from all tables of given schemas

answered Jun 20, 2020 at 12:12

2 votes

Column name on NOT NULL constaint violation not shown

answered Jun 23, 2020 at 11:58

Stack Exchange Network

180 Answers

Can ransomware embed itself in to a SQL backup file?

Oracle 12c - Logon Trigger According To Machine Information

How to read the select statement to understand the result

how to resolve the error "ADMIN option not granted for role 'my_role_1'"

Oracle database: how to change varchar length of same column in multiple tables in one go?

How Does a Database that Supports TDE Work In Practice?

ORA-06502: 'character string buffer too small' when writing to a csv

oracle - hashing method, excluding DBMS_CRYPTO

Use of Parallel hints in a SQL query

How do I SHOW TABLES in Oracle Database?

How to get Full Plan in Oracle?

schema ownership/permissions in MS-SQL vs Oracle

How secure is a local harddrive stored database?

I tried running this script, but i kept getting not a group by error

understanding oracle pluggable databases

Oracle NET - How to enable SOURCE_ROUTE with LOAD_BALANCE and FAILOVER?

How to change password version by myself in oracle?

Choosing the right blocksize for Oracle Database tablespaces with lobs

Migrating data from 11G Linux to 19C on Windows

SPFILE invalid after being edited in Windows

Oracle - Understanding Password Hash Versions

Why is a port needed for DBMS?

ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

Oracle - LRM-00109: could not open parameter file

Oracle - Is a separate database more secure than using the same database and a separate schema

Oracle 11gR2 - How To Audit SYS.USER$ Table

How to add a new listener on a new port and restrict it to one instance only

Audit all insert, delete, update and select statements on a schema in Oracle 12.2

Oracle DB : Export only table data from from all tables of given schemas

Column name on NOT NULL constaint violation not shown