Printable View
I have created a Database with some tables,sequences,triggers,indexes,etc...and I have to send it to a client.
What do you recomend me to do?
Should I create a .dmp file and send it,so the client can import it or do you think there's a better way?
Thanks in advance
Hi
1)SIZE MATTERS......well if its a small file yep.
2)Coldbackup of the datafiles.contorl files redlog files paarmeter files etc if the client and developemnt platform are same.
regards
Hrishy
If must export the database che command is:
exp system/pwd@SID file=expfull.dmp full=y log=expfull.log buffer=100000
the client must have a DB for import.
Yes,I export making a .bat file like:
exp user/password@SID log=name.log file=name.dmp full=y
But it doesn't work.I don't know why.When I click on the .bat file,DOS window appears and it drives crazy,running and running...
I have done it this way other times.
Jamoji; Regarding the .BAT file, are your directories correct? Also, you can zip the .DMP file before FTP'ing it, they compress very well.
MH
Yes,my user,password and sevice name are ok.
In fact,I try to execute the .bat file in my desktop (just to try it...) and happens what I told you before.But if I copy another exp file from one of my Oracle folders,that works properly,and try to execute it in my desktop,it happens the same crazy thing...
I tried to create the .bat file in the server desktop,or an oracle server folder,but it's useless...
What does the .BAT file look like? Does it set the oracle_sid ev? That could cause the problem.
SET ORACLE_SID=Blah!
MH