Hi,
In my oragnization we have primary and secondary server concept. From the begining primary server is window2000 server and baan4c4 oracle 9i. After 1 year we gone backup server concept. For that purpose we installed new server os - windows2003 server and oracle 9i and baan4c4. We made network licensing also.
Now., what we require copy the data from windows 2003 server to windows 2000 server.
or any other solution. Both servers baan4 c4 is same service packs.

Thanks in advance if any body helps with immediate

Thanks & Regards
Jhansi Rani

Moving Oracle data from one server (irregardless of Win 2000 / Win 2003) to another should not be a problem as long as both Oracle instances are configured the same. Just use Oracle Export to collect a copy of production data and then use Oracle Import to load that copy into the second server. There are other ways to get at this too, but Oracle Export/Import is fairly straight forward.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

If both Oracle instances are configured the same , you can use script for every table

create table

create table TTIEDM010770 TABLESPACE TAB770, PCTFREE 5, INITRANS 3, STORAGE (INITIAL 209715200 NEXT 104857600) as select * from TTIEDM010720 where 1=2;

copy table

copy from baan/baan@MT2 append TTIEDM010770 using select * from TTIEDM010720;

create index

CREATE UNIQUE INDEX TTIEDM100770$IDX1 ON TTIEDM100770 (T$EITM , T$REVI) STORAGE (INITIAL 41943040 NEXT 20971520) TABLESPACE IDX770 UNRECOVERABLE PARALLEL (DEGREE 10);
CREATE UNIQUE INDEX TTIEDM010770$IDX2 ON TTIEDM010770 (T$SEAK , T$EITM) STORAGE (INITIAL 41943040 NEXT 20971520) TABLESPACE IDX770 UNRECOVERABLE PARALLEL (DEGREE 10);
CREATE UNIQUE INDEX TTIEDM010770$IDX3 ON TTIEDM010770 (T$SEAB , T$EITM) STORAGE (INITIAL 41943040 NEXT 20971520) TABLESPACE IDX770 UNRECOVERABLE PARALLEL (DEGREE 10);

create grant

grant delete on TTIEDM010770 to R_BAAN;
grant insert on TTIEDM010770 to R_BAAN;
grant select on TTIEDM010770 to R_BAAN;
grant update on TTIEDM010770 to R_BAAN;

Max

If i follow straight import means total Database import. If so, as per primary key concept, those records shoul not insert into database means append the database. in which way i can do that.
Now every day we are taking the export backup into DLT Tapes.

Thanks & Regards,
Jhansi/-