Skip to main content

New answers tagged

1 vote
Accepted

TRUNCATE WITH PARTITION Constantly Fails on 1 Out of 620 Tables

As Dan Guzman mentioned, a truncate requires exclusive access to the entire table. It appears this is the case even when truncating a specific partition, as opposed to just requiring exclusive access ...
Ross Bush's user avatar
  • 567
0 votes

Error "No catalog entry found for partition ID ..."

-- Step 1: Run DBCC CHECKDB DBCC CHECKDB('myDB') WITH ALL_ERRORMSGS, NO_INFOMSGS; -- Step 2: Run DBCC CHECKCATALOG DBCC CHECKCATALOG('myDB') WITH NO_INFOMSGS; -- Step 3: Investigate the specific ...
warashi nguyen's user avatar
0 votes

SQL query to get the names of the partitions which are detached from the parent table in postgres?

Those tables are no longer attached to the partition parent, you need another way to identify them. Your comment indicates the naming pattern 'user_session_data_%'. This returns all tables matching ...
Erwin Brandstetter's user avatar
0 votes
Accepted

Compressing partitioned tables in Oracle 19c

Fixed it. The above steps will indeed be followed (DBMS_REDEFINITION). However, if your table has partitioned indexes, you will need to drop them. -- Check indexes SELECT index_name FROM all_indexes ...
datascinalyst's user avatar
0 votes

Using ENUM as partition key when RANGE Partitioning PostgreSQL

Enum is a list of values with an order you can fill a enum with dummy values and have so your ranges as needed. Of course you don't have integers any more, instead you need to use the status texts ...
nbk's user avatar
  • 8,491
0 votes
Accepted

How to attach partition with primary key

So, I'm going to answer my own question after I lost a day trying to define a solution and finally I found it just by trying different combinations of statements. In my initial question, I left out a ...
Philipp Faster's user avatar

Top 50 recent answers are included