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 correctly make a public synonym

This is a pretty silly one, but I need help. I have a table owned by mydbowner. It is named …

oracle database-administration
How to create copy of full schema on same database in oracle

I want to create full copy of the schema on the same database. What is the best technique to do …

oracle oracle11g oracle10g database-administration
how to drop database

i used the following sytanx drop database filmo; and got the following error: ERROR 1010 (HY000): Error dropping database (can't rmdir …

mysql database-administration
No start database manager command was issued. SQLSTATE=57019

I am new to DB2 and I have installed DB2 9.7. I created an instance which is shown below [sathish@oc3855733574 ~]$ …

database db2 database-administration
How to change database from Single user mode to multi user

I have a Database,Which is in Single user mode ,If i want to access a tables in the database …

sql sql-server database database-administration administrator
improve speed of mysql import

I have large database of 22GB. I used to take backup with mysqldump command in a gzip format. When i …

mysql linux database-administration
Are there any good PostgreSQL clients for linux?

I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL. pgAdmin III is buggy …

linux postgresql client database-administration
How can I list all tables in a database with Squirrel SQL?

I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries. But …

database-administration database-table squirrel-sql database-management
Oracle alter table insufficient privileges

I have just installed oracle 12c and then i am trying to grant user various rights. I am logged in …

sql oracle permissions privileges database-administration
Get IP address of oracle client users

I need a query to get all IP's of client users that have already a session to the database, I …

oracle client oracle-sqldeveloper ip-address database-administration