Questions about database-administration
Read more about database-administration
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Oracle IMPDP into table with different column order
I am using APPEND option of IMPDP to import into an existing table. ( APPEND option adds rows to an existing table).
Though the columns on source and target are same - the order of columns is differen...
oradbanj
Votes: 0
Answers: 1
Unable to set MAXDOP option on a non-clustered columnstore Index
I'm trying to set MAXDOP option on a non-clustered columnstore index using the following ways and it doesn't seem to be sticking. Server is SQL Server 2019.
Index properties -> Options Page ->...
neel
Votes: 0
Answers: 0
MySql reserve specific index on sorting (Fix an order for few rows to override existing sorting)
Name
Date
A
2022-5-4
B
2022-6-21
C
2022-6-22
D
2022-7-2
In above table sorting is according to Date column, now I just moved last D record on 3rd position by using drag-drop. Here re...
priti narang
Votes: 0
Answers: 1
Analyzing commit activity retrospectively in Oracle 19c
I'm trying to work out why my Oracle 19c database is "suddenly" experiencing high commit waits. Looking in V$ACTIVE_SESSION_HISTORY and DBA_HIST_ACTIVE_SESS_HISTORY shows me that lots of se...
Marcus
Votes: 0
Answers: 0