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 gurus, This is a weird problem that we have been facing since yesterday. In the transaction RSPC, we had created a process chain in Feb 09. It ran smoothly till yesterday. However when I try to schedule the process chain now, it gives me a dump st [More]
Hello QM Experts!    I would like to ask a listing of the all possible movement types applicable/related to QM. I would really appreciate if someone could help me. Thank you. Regards, Heinrick PaladHere you go mate .these are the most imp movement ty [More]
Hi, We would like to avoid user to change payment term when posting a incoming invoice. Please let me know if this could be done by IMG. regards, StevenHi, Please follow the steps: 1) Use T-Code SHD0 and give the Transaction code : MIRO, 2) Go to the [More]
Hi, I need to get the meta data (e.g. sample rate, length, resolution ..) extracted from a wmv9 video file. I know that there is no direct support for wmv files in java, e.g. from the JMF. Although there is a plugin fobs4jmf available which is a wrap [More]
I am trying to lay out a book with about 15 chapters.  I start by ading some text to a chapter page but that only accepts a few lines.  I thought iBooks Author would add pages automatically as I added more text but that doesn't seem to be the case. I [More]
hi there! im looking for help with this problem which ive had for teh last 3 months. basically one day, when i turned my laptop on it didnt log straigh into windows, it came to a screen that said 'resource conflict - pci network controller in slot 09 [More]
APP #1 I'd really like to see a notepad app that you can scribble or write on with your fingers or pen - so you can jot down ideas, graphics or script. SYSTEM #2 Retrieval of user content (music, video, photo) - this means in the event your PC crashe [More]
Dear Guru, My prompt has a calendar month edit box which is in "YYYY / MM" format. I have set this as a presentation variable p_month. Now I need to add 1 month to this presentation variable in the filter, I have tried to write the sql but it is [More]
hello im trying to authenticate the user from the data base but there after execute query i want to get no of rows using ocirowcount but there is no result in the ocirowcount it returns me 0 always there is no result in databae i also execute query t [More]
I have a menu on the top of the page on a sidebar-sort. I was wondering how you could make it move to the left, not until the scrollbar reaches the end of the page, but when I say so. If i put the key position under the menu, it disappears. If i put [More]