Oracle question: copying a database

[threaded]

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:

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?

[Rebecca Loos]

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

[BlasterBates]

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

[The Lone Gunman]

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

I often fantasise about Rebecca beating me........IGMC

[Rebecca Loos]

Blaster, what's this cardboard box at the back of KingsX business?

[BlasterBates]

Isn't that silly, it seems to have printed part of my profile....

hmmm

[threaded]

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