Hi !
Assuming that you want to create a batch file in C:\WINDOWS. The export is a full export type.
1) Go to MS DOS Prompt.
2) Change Directory to C:\WINDOWS.
3) COPY CON backup.bat
exp <user>/<password>@<tnsalia
log=expdat.log
<CTRL> + <Z>
1 file(s) created
4) Now you can execute the batch file by saying:
C:\WINDOWS\> backup
Note: Since you said that you want to schedule the backup, use some scheduler (for ex. in Windows-NT programs like AT) and call the backup.bat file.
Sagi.
Main Topics
Browse All Topics
by: mnicorasPosted on 2001-11-06 at 00:07:02ID: 6621604
Hi,
try this if you have run it under system or sys account:
create or replace function f_getTS return varchar2 is
ts varchar2(500);
begin
for c in (select tablespace_name from dba_tablespaces) loop
ts := ts || ',' || c.tablespace_name;
end loop;
ts := substr(ts,2,length(ts));
return ts;
end f_getTS;
/
spool export.bat
select 'exp system/password@tnsalias file=exp_ts tablespaces='||f_getTS from dual;
spool off
/
best regards,
Marius Nicoras
ps: don't forget to change <password> and <tnsalias> according to your settings in the spool part!