Re: can i move a tablespace to another drive?

From: Andrew Finkenstadt <andy_at_vistachrome.com>
Date: Thu, 18 Nov 1993 22:56:01 GMT
Message-ID: <CGpMDE.18n_at_vistachrome.com>


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."
Received on Thu Nov 18 1993 - 23:56:01 CET

Original text of this message