how to Alter database archievelog in Oracle?

Question

I have an excel sheet to be upload on oracle and so that data can be access with SQL commands.
Please suggest some opinions...

Answer 1

Edit the parameter initialization file.
Log_archieve_start =true -turn it on
Log_archieve_dest=c:/oracle/ora81/archieve -location
log_archieve_format="ARCH%S.LOG" - name format for archieve file .
%S for log sequence number .

Answer 2

Sol>alter table
(name of parent table) use primary key data base (child table);