exporting database

[jamoji]

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

[hrishy]

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

[dba81]

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.

[jamoji]

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.

[Mr.Hanky]

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

[jamoji]

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...

[Mr.Hanky]

What does the .BAT file look like? Does it set the oracle_sid ev? That could cause the problem.
SET ORACLE_SID=Blah!

MH