Re: can i move a tablespace to another drive?

gsa_at_panix.com (Gary Assa) writes:
>I am getting write errors on a SCSI disk and would like to move my 150mb
>tablespace to another drive in V6 under Unix 3.2v4. Can I just mv it and
>then update the SYS.dba_files table (or whatever it is called) to point
>to the new location, or is there a more complicated thing I must do???

Read the V6 DBA Manual:

SQLDBA> shutdown immediate
SQLDBA> startup nomount
SQLDBA> connect internal
SQLDBA> alter database nomount;
SQLDBA> ! cp /old/file/name /new/file/name

• IF AND ONLY IF SUCCESSFUL do this: SQLDBA> alter database rename '/old/file/name' to '/new/file/name'; -- SQLDBA> alter database open; SQLDBA> select count(*) from table_on_tablespace_with_moved_file_name;
• that was a sanity check :-) SQLDBA> disconnect SQLDBA> shutdown immediate SQLDBA> startup SQLDBA> exit

-- 
Andrew Finkenstadt  |  Systems Analyst, Homes & Land Publishing Corporation
+1 904-575-0189     |  GEnie Sysop
andy_at_genie.geis.com |  THE RELATIONAL OATH:  "I promise to use the key, the
andy_at_homes.com      |  whole key, and nothing but the key, so help me Codd."