Tag Info

New answers tagged

0

When you select the "Device" (file) to restore your database from, the Database combobox below is populated and the first item is selected. But! Whatever event that populates the Files grid is not firing. If you explicitly select your database from that drop down, the Files grid will then populate and the "Relocate all files to folder" checkbox will enable. ...


2

How to get the 8.00.194 (!!!!!!) server to 8.00.2040: You can download Service Pack 4 (8.00.2039) from here, which you will need to install before you can install the 8.00.2040 hotfix. How to restore a 2000 .bak to a 2008 server: You may need to clarify your actual requirements and clean up the question, but if you are trying to ultimately restore a SQL ...


1

As Chris already mentioned LOAD is a utility and therefore the UTIL_HEAP_SZ must be set high enough (but don't ask too much, always monitor the memory free space with top). You need a lot of memory for a fast load (see DATA BUFFER below). Here are things that speed up the load: More containers for the tablespace where the table is (best on separate luns / ...


1

To troubleshoot, I would start by looking at the output of SELECT current_user; and SHOW search_path;. Also, the output of \dp termin in psql. My suspicion here is that you are stumbling over mixed case identifiers. The error message mentions a table Map Notice the capital letter M. Are you sure there is no mix-up with another table named map (lower ...



Top 50 recent answers are included