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
Just got my Logic Studio Upgrade (from Pro 7) and installed it. First time I launched, I got one of those scary complete system hardware crashes (where the screen goes grey) as soon as it started scanning for plug-ins. After I rebooted, I removed all [More]
Hello, I just updated to a new computer and pulled my Audigy Platinum SB0090 (with the front dri've panel) out of my old system and installed it in my new systemell E52 (AMD dual core)Windows XP SP23GB memory?) I disabled the onboard sound in the BIO [More]
I am thinking of buying an iPod mini but I don't have an Apple computer. Does the iPod mini work with Windows efficiently? Thanks....Hello Ian, Can you be really specific about the necessary Windows XP updates needed? I run XP Pro on a rather new com [More]
How can I have a message pop up when clicking on digital signature that warns the person they are signing an official government document.  I invision the message popping up making the statement and a button within the message that can be clicked to [More]
I have an ATV 3 (MD199KN/A), which have hanging menus after haven been on sleep. If I wants to play something from, say, Youtube, it looks like this: The cartoon keeps going in the background and going to, say, Netflix doesn't help either: My only op [More]
Hello All, Iam using EP 7.0 SP19. I used Lightweight desktop for the user and assigned default home role. I am getting a popup window in the right top corner with the message as below "Closing Session". I checked that using HTTP Watch, its loadi [More]
Hi: I am looking to build a solution for a prospective client.  I want to use FCP server's file manager to allow remote users to access and obtain content.  This arrangement is actually for healthcare solution. I know FCP is used to manage and transf [More]
I have another laptop that I use from time to time, how do I get my adobe photoshop onto it?Cloud License allows 2 activations http://www.adobe.com/legal/licenses-terms.html -Install on a 2nd computer http://forums.adobe.com/thread/1452292?tstart=0 - [More]
I don't understand the constant complaining in the forum lately about Logic, especially LP9. Apparently, the complainers are choosing to use their free time to cry, rather than spend it "fixing" Logic Pro. I, for one, love Logic - especially LP9 [More]
In this simple program, i used the logical operator OR ||, but i can't get it to run right!! is there is something i'm doing wrong here in this source code?In this program i even tried the logical operator AND which is && but still no good results [More]