| ramesh |
Posted: Jan 01, 2008 06:17:08 AM |
Total Post: 77
Joined: Dec, 2006
|
I hav a table which contains historical data,
and is not needed frequently, but is important
i contains some 21540894 rows which consists data from last 12 years.
so dont want to hav all the data in the backup,
so can i store this table in seperate tablespace(datafile) and hav the copy on the pc. and take a copy of it,
all i want to do is that i dont want such a big table in daily backup bcos it consumes a lot of time.
i use the imp/exp utility.
can anyone help me.
..ramesh |
|
|
 Mohammed Taj |
| Posted: Jan 01, 2008 07:26:57 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
First of all exp/imp is not a backup method.
second what is your oracle version if 10g then use exclude option with exp command for that big specific table.
third what is your backup script ?
|
|
|
|
|
| ramesh |
| Posted: Jan 02, 2008 12:04:53 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Hi.. Mohammed
my server works on Linux platform and we use oracle9i
and my backup script goes like this:-
(i take backup from client working on winxp)
this is the bat file:-(erpbackup.bat)
exp parfile=d:\erpbkup\erpbackup.TXT
this is txt file:-(erpbackup.txt)
userid=username/password@SID file=d:\erpbkup\erp.DMP
log=d:\erpbkup\erp.LOG
buffer=4096000
statistics=none
owner=user
plz help me what to do with the table it consumes a lot time for export
Thanks..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
