Top "Database-administration" questions

the aspects of database usage not directly related to the insertion and extraction of information, such as security, configuration and performance tuning

How to use DBMS_CRYPTO.encrypt function in oracle

I want to encrypt password column in the database and I am trying to use encrypt function present inside DBMS_…

database oracle oracle11g oracle10g database-administration
mysql_secure_installation "Can't connect to local MySQL server through socket"

When I am invoking the file mysql_secure_installation I get an error like [mysqk123@InstallZeMo bin]$ ./mysql_secure_installation …

mysql database-administration mysql-error-2002
SQL Server 2016 - How to get last logged in date for user?

How can I get the last logged in date for certain user. I googled and stumbled upon this query SELECT …

sql-server database-administration
Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

I was trying to delete PostgreSQL user: DROP USER ryan; I received this error: Error in query: ERROR: role "ryan" …

postgresql roles database-administration
How do I find the last time that a PostgreSQL database has been updated?

I am working with a postgreSQL database that gets updated in batches. I need to know when the last time …

sql postgresql metadata database-administration
How to export & import only data in oracle 11g?

I want to export only data on of my master tables and then imports it to some other server on …

database oracle database-administration
how to drop partition without dropping data in MySQL?

I have a table like: create table registrations( id int not null auto_increment primary key, name varchar(50), mobile_number …

mysql sql database database-partitioning database-administration
Oracle SQL Developer copy database step by step

I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as …

sql database oracle oracle-sqldeveloper database-administration
set new value for "ft_min_word_len " FULLTEXT in mysql

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\…

mysql full-text-search database-administration fulltext-index
What's the difference between the Oracle SYS and SYSTEM accounts?

What are the differences between the Oracle SYS and SYSTEM built in accounts? Edit: Apart from 3 letters!

oracle administration database-administration