Re: On recovering single fragmented table via archecker
Realized the cut-and-paste left out the database line at the top of
the example table-level restore schema command file in the previous
email.
=====================
-- Example schema command file
-- for table-level restore using archecker
database testdb@ids10_tcp;
-- source table (on archive):
-- if the source table had been a
-- fragmented table created with the
-- with rowids clause, you must
-- specify that
create table frag_tab1
(
col1 serial,
col2 integer,
col3 char(40),
col4 boolean,
col5 dec
) with rowids fragment by round robin
in dbspace1, dbspace2;
-- table or file to restore to:
create external table ext_tab1
(
col1 serial,
col2 integer,
col3 char(40),
col4 boolean,
col5 dec
)
using ("/tmp/ext_tab1.unl", delimited);
-- restore statement:
insert into ext_tab1 select * from frag_tab1;
restore to current with no log;
=========================
--Hyun-Ju