Dump/copy tableA records onto tableB
Posted on 2005-03-21
I've looked around this section for an answer and so far I see answers that require quite a bit of manual work to get going. I am using Oracle 9 with SQL Plus as my client. My version of SQL plus does not have the EXP or IMP command so I am left to think that 'SELECT INTO' or 'COPY' are my only options. Basically, I have tableA and tableB both inside the same schema/database. TableA and tableB are very similar although both have only a few fields that are not on the other table. I have verified that those fields present in tableB and NOT in tableA can be NULL. Now all I want to do is dump/copy all of the fields(available from tableA) from tableA onto tableB (sorry for the extreme repetition). Furthermore, there is one field in tableA that corresponds to tableB although they are named differently (tableA.date_entered_Db -> tableB.date_entered).
So I want to move the following information:
tableA.Title -> tableB.Title
tableA.Lexis_Cite -> tableB.Lexis_Cite
tableA.Case_Date -> tableB.Case_Date
tableA.Detailed_Form -> Discarded completely
tableA.Date_Entered_Db -> tableB.Date_Entered
tableA.Cert_Denied -> tableB.Cert_Denied
tableB.Precedential -> NULL as per default
Please send explicity instructions on how to do this. Lastly, how would I save my entire schema/database in case I want to restore it to the current status?