Sitemap

Amicuk Programming Answers

At the time of reindex what should we take care ?

2015-10-11   Views:0

Advertisement

Hi All, 1. When we reindex the table, what precausion to be take care. If the table having partition, triggers - Should we take a backup of these ? 2. How to compress/defragment the table ? Regards, Rajan B1 - reindex how? Do you mean drop/re-create

Hi All,
1. When we reindex the table, what precausion to be take care. If the table having partition, triggers - Should we take a backup of these ?
2. How to compress/defragment the table ?
Regards,
Rajan B

The replay answer
Advertisement
1 - reindex how? Do you mean drop/re-create index to reorganize it? You should probably use ALTER INDEX x REBUILD instead, but it is rarely necessary to rebuild Oracle indexes. You should make sure the target tablespace has ample free space to hold the resulting index plus if you rebuild in the existing tablespace that means it needs enough free space to hold two copies while the command runs.
If you are changing the index to add or remove columns to support queries then you likely want to perform this action at a time when the table is not needed for update activity.
2 - If this would be beneficial you could use either alter table move commands or export/truncate/import (see Utilities manual entries for expdp or exp and impdp or imp depending on Oracle version)
HTH -- Mark D Powell --

Go to See the other 8 answers

Not all loops appear in loop browser... even after I reindex.  Please help.

Category:DefaultRelease time:2015-10-11Views:130

I've just spent the past couple of hours trying to reindex my loops so that they all show in the browser... to no avail. Which is to say, they will show, if you know how to find them. Let me explain: I have Jam Pack Promos 2, 3, and 4. These loops be[More]

Broken in Logic 9?: Reindex loops from external drive

Category:DefaultRelease time:2015-10-11Views:130

Adding loops from an external drive in Logic 9 does not seem to work any longer. It used to work great in L8. Anyone have similar experiences? Know any work arounds? Is it a bug? If it's a bug I'll file it with Apple. Previously in Logic 8 it was eas[More]

At the time of reindex what should we take care ?

Category:DefaultRelease time:2015-10-11Views:130

Hi All, 1. When we reindex the table, what precausion to be take care. If the table having partition, triggers - Should we take a backup of these ? 2. How to compress/defragment the table ? Regards, Rajan B1 - reindex how? Do you mean drop/re-create[More]

Garageband start-up failure after installing or reindexing Loops Library

Category:DefaultRelease time:2015-10-11Views:130

Bought Logic Pro 9 2 weeks ago and installed it the same day except for the Loops Pack, works like a charm, also the compatibility with Garageband seemed flawless. Last Monday I had installed the Apple Loops Pack and still everything was OK, I had us[More]

Spotlight frequently reindexes drives in Snow Leopard

Category:DefaultRelease time:2015-10-11Views:130

Spotlight frequently reindexes my drives (like every other day), taking between 7 and 20 hours each time and generally bogging down my system when I'm trying to get real work done. The basic classes of error reported by mds, as seen in the system log[More]

Spotlight reindex, mds crash

Category:DefaultRelease time:2015-10-11Views:130

Hello, I was searching a lot of stuff and I didn't found any resonable solution. It starts about the last update to 10.9.1. (17.12.). Main problem is like this: every time I open a lid on my AriMac, spotlight is starting reindexation. I found some li[More]

How to mass-reindex files with same name but different file extensions

Category:DefaultRelease time:2015-10-11Views:130

(reposting cos I'm confused about if I posted in the proper place before. Please delete if it is a repost.) So I'm on a remote workflow. I pick all the raw data and convert it in two quality standards, one on 'high' with full specifications and one o[More]

Why does reindex documents at Server in the Configuration Manager break the help system?

Category:DefaultRelease time:2015-10-11Views:130

Background: So, I have a nice hosted help system on Server 9. I'm using the Access database since it's a light load project. It works OK. All admin features work OK (except groups and users bug, unrelated), including reports on search and usage. So,[More]

Disabling Popularity Trends and Reindex library in Sharepoint 2013

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need to disable "Popularity Trends" option for all items, lists and libraries in SharePoint 2013. Also i need to disable "Reindex library" options in SharePoint 2013 document library Advanced settings. If this is possible, can an[More]

How can i reindex my mail accounts (imap)?

Category:DefaultRelease time:-0001-11-30Views:130

i've noticed that i can't seem to search my mails anymore. or just a subset from what's in the accounts. how i can force mail.app to reindex my imap accounts?yeah i noticed the edit and did what the page said. while it did s.th. that took its sweet t[More]

How to force reindexing of rows?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have CONTEXT index with with "user_datastore" generated by procedure. I want to control which records need to be reindexed. The method I use now is: Update a_tabel set text_column = text_column where id in (select that provides list of row[More]

Hot
I have two mac computers, one at work and one at home, and an iphone. I also have an gmail account I use daily..so the question is how can I set it up so I can follow my calender iCal at home and work computer and on the iphone and gmail, everything [More]
Hi all, I need help with custom drop-down field in SRM 5.0 shopping cart. We need to create custom field called Location in SRM goods receipt transaction. And this location field will be a drop-down field that will be filled with values from location [More]
I mostly charge my phone via my laptop. The cable has been acting up the past week or so, (computer said USB disabled, etc.) I also noticed some bunching near the end. Decided it was probably time for a new cord, but didn't think much else of it. Ton [More]
Since I built my site with the first incarnation of iWeb, and the update has been installed, will simply republishing the content change the images from PNG to JPG or do the graphics need to be reimported into the pages? Does iWeb do the conversion u [More]
i have the fatality fps sound card. my problem is wiv the mic jack at the rear of the card. i need to use this instead of the one on the front panel as when playing battlefield 2 it defaults to the connection on the back of the card. however i need t [More]
In case my question has totally confused you, let me describe the situation, a general one which I'm sure some of you have already tackled. Suppose you're acquiring data from several channels (let's say two waveforms). And you only want to capture th [More]
Hello All, My client does not have and want to install the SAP Content server for Archivelink, my suggestion is to map a external server on SAP server (like F: for exemple) that we could see in AL11 and place (also read)  the files there. Another ser [More]
My application has a requirement for multiple lookup data ( asset types , broker types ) with code and description. The lookup data is fairly static and only updated through an external source.Can I use a read only BMP Entity EJB. The primary key wil [More]
I use Document.importNode(Node, String) to import a node from one document into another document. I want to preserve the namespace of the imported node. This works ok if the imported node specifies xmlns, even xmlns="". But if the imported node [More]
Hi, I have been trying to publish my site every day for about a week now with no luck. I get the same error message each time: iWeb couldn't publish to MobileMe. The MobileMe servers are busy. Please try again in a few minutes. I've already tried: Cl [More]