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>
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