Re: how to make a backup sql file for my database??

thx Rauf Sarwar, I have called exp to make a dmp file for my db If I want to import this database in other pc, do I need to create the same user account name and tablespace b4 import this file??

And Do I just call imp and follow the steps to import the file???

Thx

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0306292140.64971baf_at_posting.google.com...
> "myhome" <myhome_at_home.hk> wrote in message news:<3eff9ca8_at_shknews01>...
> > I have a database in Oracle 9i. I want to backup the structure and data
in
> > some *.sql file. Can sqlplus do this purpose for me?? and How to do?
> >
> > Thx
>
> Any reason why you don't want to use Oracle's Export tool called exp?
>
> Regards
> /Rauf Sarwar
Received on Mon Jun 30 2003 - 01:13:08 CDT