hi all

i m using Oracle 10g

how can i take backup and then restore oracle database?


thnx,

Ashu

declare
BACK varchar2(556);
begin
BACK:=GET_FILE_NAME('E:\project\backup','Backup'|| To_Char(Sysdate,'ddmmyyyyhhmmss'),'NULL','Save As',Save_File);
--READ_IMAGE_FILE(BACK,'JPEG','CBLOCK.CIMAGE');
--:t:=BACK;
If bb Is Not Null Then
Host('Exp Work/info File='||bb||'.dmp');
Else
Null;
End If;
end;

Hi,

Ashu your problem is not big you can solve your problem by using this latest Study Material..........




Cert4Prep Questions Answers

Oracle 10g Certifications

Hi, I found out from reading about Oracle that there are two most common ways to perform oracle backup and recovery. It is through recovery manager and user-managed backup. I do hope, I make sense with this:)