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
Hi all, We need to have a report which will give a list of people whose SAP ID passwords are expiring so that they can change their passwords. Is there any standard report to get this list ? If we need to have a custom report where can we get the dat [More]
Hi, I have a table with 4 columns, Can any one tell me how can i increase the text size and apply different fonts in webdynpro java application. Thanks Satish JHi Satish, To expain it bit more clearly. Copy the images you need to use in the applicati [More]
I have iPad2 iOS 5.0 and just bought Apple Composite AV cable. Can't stream video from iPad to TV. I listen the audio, but no video appears. Any suggestions?Hi Julian! I have AppleTV and thinking about an ipad. Are you sure about it? Is it easy? Usin [More]
Hi Experts, My client would like the possibility to choose several reasons for an opportunity status. e.g. : Status : Won          Reasons : Price                           Right Ressources Do you know how to do this (if it's possible) ? Thanks a lot [More]
These tiny arrows greatly annoy me when I add these elements to the sidebar. Is there a way to remove them? http://puu.sh/38xCQ.jpgDoes clicking the arrow have the effect as clicking the icon part because sometimes the serve a different purpose? It s [More]
Can I install Adobe Pro XI on a machine with Adobe Standard [email protected] you mean acrobat pro and standard, that may work, but it may not. more importantly, why would you leave acrobat standard on a computer that has acrobat pro? you should uninstall [More]
Hi All, I imported a hyperion financial report into smartview power point. i want the following steps to be automated. 1) make a connection to data source 2) perform refresh all command 3) save the power point 4) close the point Is this possibe and c [More]
Hello at all, everytime, when i start the listener of my Oracle 11gR2 test instance, he says me the following: Service "dbprod2" has 1 instance(s). Instance "dbprod2", status UNKNOWN, has 1 handler(s) for this service... My instance is [More]
Using PSE 9. After importing my raw files I am currently saving the edited version of my images as TIFF files. Is there any advantage to saving the edited image in PSD format?  Yes indeed Juergen, but layered tiff files normally end up being huge and [More]
Hello all, I am trying to create a alphabetized pop-up menu from data on a second sheet and need help. Manually typing in the data into inspector will work once but data is continously added and would like it alphabetized. Here is what I have. Sheet [More]