ORacle 9i table backup

How can I a backup tables which are big, that is more than 125 GB?
I tried using the exp utility without any success.
Can somebody give me steps to do this and the imp steps too..
Note: The export has to be from a 9i database and import will be done in 11g database.

Thanks@
D-pkAsked:
Who is Participating?
 
D-pkConnect With a Mentor Author Commented:
what if I export the dump in to my local PC (Windows XP), does the windows system has that restriction?

exp USERID=usr/pwd TABLES=big_table_125gb  FILE=C:\TABLES_DUMPS\big_table_125gb.dmp

I tried this but its still trying to create it in the unix server itself...
Lets say if I try in the command prompt..
For ex:
exp USERID=usrname/pwd@198.2.34.122 TABLES=big_table_125gb FILE=C:\TABLES_DUMPS\big_table_125gb.dmp
it gives me errors like:

EXP-00056: ORACLE error 12514 encountered
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
EXP-00000: Export terminated unsuccessfully

Do I have to give any port numbers or any other parameters to work?

Thanks@
0
 
slightwv (䄆 Netminder) Commented:
Why did exp fail?  export file to large?

What OS?
0
 
D-pkAuthor Commented:
These were the errors I got..


EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

I am able to do smaller tables, but the tables which 125GB, it gives me the above errors.
OS is Linux. (I gave uname -a, if that is correct)

Thanks@
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You need to set up a large file filesystem:
http://en.wikipedia.org/wiki/Large_file_support

or
Create a named pipe, export using it then split the output:

http://www.linuxjournal.com/article/2156
http://linux.about.com/library/cmd/blcmdl1_split.htm

try the following (I don't have access to fully test this):

mkfifo pipe


then: exp file=pipe tables=(largetable)

from another window:
split –bytes=1000m pipe myExpPiece
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Before you do all that:  Check the obvious and see if you have enough free space in the filesystem...
0
 
slightwv (䄆 Netminder) Commented:
>>does the windows system has that restriction?

It shouldn't but you have network lag time built into the time.

>>ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

You need to use a database alias from your tnsnames.ora file.  If you don't know how to configure your client, it will need to be a separate question.
0
 
gopiseraConnect With a Mentor Commented:
Adding to above

Add the tns entry  in your oracle home of windows and then try using with that tns entry

<addressname> =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <sid>)
 )
)

exp USERID=usr/pwd@<addressname>   TABLES=big_table_125gb  FILE=C:\TABLES_DUMPS\big_table_125gb.dmp


Make sure that the exp  profile is set to 11.  Since,  You are importing into a 11g database.  :)


0
 
D-pkAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.