Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export complete DB and Import into another Server Command

Status
Not open for further replies.

myvision69

Programmer
Feb 3, 2006
18
US
Export complete DB and Import into another Server Command


I am looking to export complete database (DUMP) from one server and import into another from the export (DUMP)

What is the command I can use to accomlish that? I do have the DB Admin User and Password.

THANKS SO MUCH
 
Perhaps use exp from the command line (ie not within SQLplus). Use exp help=Y for usage details. Use imp to import the data on the other server.

Alan Bennett said:
I don't mind people who aren't what they seem. I just wish they'd make their mind up.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top