Oracle question: copying a database

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

threaded replied

14 July 2005, 10:17
Result

The DBAs etc., gone for lunch, went in and did it myself. Just imported onto the new machine and everything is working fine.

I recon the DBA must have had finger troubles with the first one...
Leave a comment:
BlasterBates replied

14 July 2005, 10:11
Isn't that silly, it seems to have printed part of my profile....

hmmm
Leave a comment:
Rebecca Loos replied

14 July 2005, 08:25
Blaster, what's this cardboard box at the back of KingsX business?
Leave a comment:
The Lone Gunman replied

14 July 2005, 08:16
Originally posted by BlasterBates

I was just to going to say the same thing but rebecca beat me to it.

I often fantasise about Rebecca beating me........IGMC
Leave a comment:
BlasterBates replied

14 July 2005, 08:11
I was just to going to say the same thing but rebecca beat me to it.
Leave a comment:
Rebecca Loos replied

14 July 2005, 08:07
that looks fine.
just one thing: are they typing this in DOS or UNIX? If DOS, then they need to specify which database it is e.g. system/manager@databasename
Leave a comment:
threaded started a topic Oracle question: copying a database

14 July 2005, 07:06
Oracle question: copying a database
Have this tiny database on an Oracle 9i: 20 odd tables, some sequences and stored procedures, about 3Gb of data.

I want to copy it onto another machine, and just start using it.

Had a go with that exp and imp stuff, but looks like somethings were in the middle of transactions, also the sequences went back to zero. Well, I asked the DBA to do an exp for me. I asked them to type:

Code:

exp system/manager file="c:\temp\exp.dmp" full=Y

.

Client won't let me at the database for the seconds it takes to do the exp, so have to do it by request via the DBA.

So was the above command incorrect? What should I have asked them to type?
Tags: None