12-09-2007
FreeBSD7.0_BETA4 installing
about more half one part during installing my FreeBSD7.0_BETA4 ,some thing wrong happened : "unable to open the packages files /INDEX selected from you media" so what should I do ,just tell me the way to deal with the problem ,thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hey
i want to install freebsd 5.1 but i ran into some problems
i have a old cpu, i made boot disks from kern.flp and mfsboot.flp from the cd, and boot up, when i'm done and gonna install, it won't find the cd, then i tryed to installed with ftp, but i coulden't figure out how to do, i have a DHCP... (5 Replies)
Discussion started by: ekizz
5 Replies
2. AIX
hi, everybody£º
i have a question, pls help me¡£
OS : RS/6000 AIX 4.3.3
cPU : Powerpc,POWER3
I install X11.Dt, X11.apps, X11.base, X11.compat, X11.motif, X11.vsm full and Optional install X11.fnt using smitty!
When i compling my gui programs , i found that all the include file of ... (1 Reply)
Discussion started by: q30
1 Replies
3. Linux
Yea, im having a little confusion towards installing red-hat using promise controllers. It was more easy with Windows cause it prompts me and i just press F6 at the beginning of the installation and then it gives me the list of the controllers i need (from a floppy). I tried using the noprobe on... (5 Replies)
Discussion started by: kyoist
5 Replies
4. Debian
I just reformatted my computer because of a bad tip I and I installed only the base-system to add what I'd want later. My question is how/where can I get a good X-server for Debian? I'm so used to gnome and don't really like it and want to try something else. I heard about something called: Xfree... (1 Reply)
Discussion started by: riwa
1 Replies
5. AIX
Question from an AIX noob --
I recently installed an AIX box with what I thought was recent 5.3 media. After the install it was at ML 5300-00.
My question is, it seems as if each ML/TL needs to be installed prior to the next - which currently makes 6(?) updates. Am I missing something - is... (4 Replies)
Discussion started by: tb0ne
4 Replies
6. Linux
Hi all,
I wanted to install the latest version of firefox 2 but it seems when I attempt to install it, it seems to be saying it is looking for c libraries version 2.3? I believe I currently have an older version of the c libraries. I am currently running Sun's JDS Linux 2003. My Mozilla web... (1 Reply)
Discussion started by: scriptingmani
1 Replies
7. UNIX for Dummies Questions & Answers
About more half one part during installing my FreeBSD7.0_BETA4 ,
some thing wrong happened : "unable to open the packages files /INDEX selected from you media"
so what should I do ,just tell me the way to deal with the problem ,thanks. (1 Reply)
Discussion started by: magic_dk
1 Replies
8. Ubuntu
Hi
I have dual operating system i.e Win XP and KUBUNTU. Now my windows XP is corrupted and i want to reinstall Win XP. So i just want to know Shall i have to reinstall Linux also or i can only reinstall win xp without affecting linux installation.
Thanks
Sarbjit (3 Replies)
Discussion started by: sarbjit
3 Replies
9. BSD
Hi,
Am using FreeBSD7.4/i386
I forgot to install ports,
So now trying to install them using "portsnap fetch"
I get the output as
Help me to sort out this.. (3 Replies)
Discussion started by: Priya Amaresh
3 Replies
10. BSD
Hi,
During OS installation of FreeBSD7.4/i386 I missed to include ports collection.
Now when I try with sysinstall command via ftp servers avaliable in tha list it says "unable to open ftp connection. Error:0"
Could You Please suggest me the exact site wher I can get ports collection via FTP to... (1 Reply)
Discussion started by: Priya Amaresh
1 Replies
LEARN ABOUT OSX
alter_index
ALTER
INDEX(7) SQL Commands ALTER INDEX(7)
NAME
ALTER INDEX - change the definition of an index
SYNOPSIS
ALTER INDEX name RENAME TO new_name
ALTER INDEX name SET TABLESPACE tablespace_name
ALTER INDEX name SET ( storage_parameter = value [, ... ] )
ALTER INDEX name RESET ( storage_parameter [, ... ] )
DESCRIPTION
ALTER INDEX changes the definition of an existing index. There are several subforms:
RENAME The RENAME form changes the name of the index. There is no effect on the stored data.
SET TABLESPACE
This form changes the index's tablespace to the specified tablespace and moves the data file(s) associated with the index to the new
tablespace. See also CREATE TABLESPACE [create_tablespace(7)].
SET ( storage_parameter = value [, ... ] )
This form changes one or more index-method-specific storage parameters for the index. See CREATE INDEX [create_index(7)] for details
on the available parameters. Note that the index contents will not be modified immediately by this command; depending on the parame-
ter you might need to rebuild the index with REINDEX [reindex(7)] to get the desired effects.
RESET ( storage_parameter [, ... ] )
This form resets one or more index-method-specific storage parameters to their defaults. As with SET, a REINDEX might be needed to
update the index entirely.
PARAMETERS
name The name (possibly schema-qualified) of an existing index to alter.
new_name
The new name for the index.
tablespace_name
The tablespace to which the index will be moved.
storage_parameter
The name of an index-method-specific storage parameter.
value The new value for an index-method-specific storage parameter. This might be a number or a word depending on the parameter.
NOTES
These operations are also possible using ALTER TABLE [alter_table(7)]. ALTER INDEX is in fact just an alias for the forms of ALTER TABLE
that apply to indexes.
There was formerly an ALTER INDEX OWNER variant, but this is now ignored (with a warning). An index cannot have an owner different from its
table's owner. Changing the table's owner automatically changes the index as well.
Changing any part of a system catalog index is not permitted.
EXAMPLES
To rename an existing index:
ALTER INDEX distributors RENAME TO suppliers;
To move an index to a different tablespace:
ALTER INDEX distributors SET TABLESPACE fasttablespace;
To change an index's fill factor (assuming that the index method supports it):
ALTER INDEX distributors SET (fillfactor = 75);
REINDEX INDEX distributors;
COMPATIBILITY
ALTER INDEX is a PostgreSQL extension.
SEE ALSO
CREATE INDEX [create_index(7)], REINDEX [reindex(7)]
SQL - Language Statements 2010-05-14 ALTER INDEX(7)