Home » RDBMS Server » Server Administration » urgent plz help me
urgent plz help me [message #375169] Thu, 02 August 2001 02:39 Go to next message
jeevan
Messages: 18
Registered: August 2001
Junior Member
hai!

I have to move the tables that are existing in my database along with all the triggers and stored procedures. I should copy(dump) the tables in to a floppy and have to install them some where. Please help me by suggesting the way to dump the tables into the floppy.

thnks in advance
Jeevan
Re: urgent plz help me [message #375172 is a reply to message #375169] Thu, 02 August 2001 08:07 Go to previous message
S.Muthukumar
Messages: 2
Registered: August 2001
Junior Member
Hi,
All u need to do is, export the reqd tales, copy it to the machine where u want to import.

Command :

exp userid/pwd file=file_name tables=table_name log=log_file_name

this command will export the tables along with the data, constraints, triggers attached to the tables.

HTH
S.Muthu Kumar
Previous Topic: Re: COMPLEX SQL QUERY - HELP REQUIRED
Next Topic: Re: set timing on
Goto Forum:
  


Current Time: Fri Jul 05 11:24:37 CDT 2024