database-administration Questions
8
Solved
I'm getting this error if i try to login as db user. If lsnrctl status is run i get the below error. DB was working fine all these years and stopped working suddenly.
Connecting to (DESCRIPTION=(A...
Foozle asked 19/5, 2014 at 17:39
4
An update SQL query was executed on the server, which caused many problems later.
How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL ...
Dorcasdorcea asked 12/2, 2013 at 10:55
16
Solved
What is the difference between a user and a schema in Oracle?
Reverso asked 18/5, 2009 at 23:11
5
Solved
I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries.
But how can I list all tables in the database? And preferably all column and column types.
Lupulin asked 4/2, 2011 at 9:52
8
Solved
When I am invoking the file mysql_secure_installation I get an error like
[mysqk123@InstallZeMo bin]$ ./mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL My...
Ovida asked 15/3, 2013 at 18:7
7
Solved
I'm trying to see the contents of a collection using MongoDB Compass. I have username/password authentication set up. I can log in successfully but can't see any documents in the collection. Instea...
Lamrert asked 17/8, 2018 at 19:59
11
Solved
I have large database of 22GB. I used to take backup with mysqldump command in a gzip format.
When i extract the gz file it produces the .sql file of 16.2GB
When I try to import the databa...
Requiescat asked 15/4, 2015 at 7:7
14
Solved
I'm trying to create my own database using SQLPlus. So first I log into it as admin:
sqlplus sys/sys_password as sysdba
And then I try to create a new user, called sqlzoo :
CREATE USER sqlzoo I...
Talkative asked 3/12, 2014 at 19:50
9
Solved
I have a database in a local file that is used by a program. The program has limited functionality and I needed to run some quick queries. I installed SQL Server Management Studio Express 2005 (SSM...
Ansilme asked 16/12, 2011 at 1:21
2
I'm running a query that duplicates a very large table (92 million rows) on PostgreSQL. After a 3 iterations I got this error message:
The query was:
CREATE TABLE table_name
AS SELECT * FROM big_t...
Misdoubt asked 9/11, 2020 at 14:32
3
Solved
When i tried to create a table in my User_DB schema i am getting an error as ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA. I run the following query to get all the T...
Spathose asked 6/5, 2016 at 11:23
5
Solved
I am new to DB2 and I have installed DB2 9.7.
I created an instance which is shown below
[sathish@oc3855733574 ~]$ db2ilist
sathish
Settings of /etc/services is shown below
DB2_sathish 60000/tcp
D...
Lashay asked 31/7, 2015 at 7:5
0
We created a PostgreSQL production database in AWS RDS a few months back and now we have received a requirement from the application team to install a connection pooler - PgBouncer in it.
I couldn'...
Footrest asked 7/2, 2023 at 14:43
6
Solved
I was trying to delete PostgreSQL user:
DROP USER ryan;
I received this error:
Error in query:
ERROR: role "ryan" cannot be dropped because some objects depend on it
DETAIL: privileges for dat...
Babbette asked 10/7, 2018 at 2:28
2
Solved
I know that there is a way to list all prepared statements for the current session by selecting all rows from the pg_prepared_statements table, but is there a way to see all prepared statements for...
Shredding asked 28/8, 2012 at 12:39
3
Solved
How can I get the last logged in date for certain user.
I googled and stumbled upon this query
SELECT name, accdate FROM sys.syslogins
But the accdate column seems to be deprecated, and does not...
Lennox asked 20/12, 2017 at 11:49
3
I want to create full copy of the schema on the same database. What is the best technique to do that?
I have few ideas in mind:
Datapump Over Db link
IMPDP on network link
EXPDP and then IMPDP.
...
Weisman asked 6/11, 2014 at 17:27
2
We have a server environment in SQL Server 2016. The Server is virtualized meaning it shares its memory and cpu.
Lately if heavily under stress i.e. sorts building hashtables etc. we see heavy gro...
Liu asked 8/10, 2016 at 7:15
2
Solved
Background:
Application Server:
Java Based Application is running on Windows Server 2008 R2 Enterprise.
Java Version on this Server is Version 6 Update 32.
JDBC Driver Version: 4.0
Database...
Bushbuck asked 21/8, 2019 at 16:22
2
Solved
We have oracle express edition 11g i.e. ORACLE XE 64bit. There is 10GB available space in the database. But system tablespace is 98% full, there are 2 system tabalespaces.
When we (our startup tea...
Celik asked 18/9, 2017 at 18:33
3
Solved
I have a Database,Which is in Single user mode ,If i want to access a tables in the database i will be changing in the properties from single to multiuser.How can i make the Database multi user per...
Baiss asked 30/7, 2014 at 19:19
4
Solved
Is there a way for a user to terminate one's own session/connections, given an Oracle SID, without DBA rights?
Specifically, I can run this in my DB without admin rights:
SELECT SID, "SERIAL#&...
Canaigre asked 19/3, 2020 at 22:46
1
Solved
What happens if two transactions try to modify the same row simultaneously? Normally, once the row is modified, the other transaction waits until the first one performs commit or rollback. But what...
Cm asked 3/5, 2021 at 6:48
5
Solved
I'm trying to take a look at locks that are happening on
specific tables in my PostgreSQL database.
I see there's a table called pg_locks
select * from pg_locks;
Which seems to give me a bunch ...
Aquarium asked 9/5, 2016 at 7:39
4
Solved
I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :-
ORA-01219: database not open: queries allowed on fixed tables/views only)
I l...
Hillman asked 8/4, 2014 at 14:33
1 Next >
© 2022 - 2024 — McMap. All rights reserved.