I have to copy a DB from one server to another one
I have no idea how to copy a DB from one server to another one
( sporters I’m sincerely gratitude to you, Tue 5 Aug 2014, 14:30, 3 replies, latest was 11 years ago)

Depending on the version of Oracle that you are having to deal with
You should be able to extract the information as a CSV or XLS then the destination server should be able to recompile it from there...

Obvs, don't know what server or oracle etc you are using.
(Bonzodog29 is an unemployed sponge of the worst kind, Tue 5 Aug 2014, 14:34, Reply)

Export the entire thing as an oracle .dmp file
and then something something something on the other server.
( The Light in Chains don't touch the Pope's boner, Tue 5 Aug 2014, 14:37, Reply)

Its the something something bit I'm having trouble with
An existing empty DB is there
( sporters I’m sincerely gratitude to you, Tue 5 Aug 2014, 14:38, Reply)

Have you tried printing it all off page by page
then inputting it by hand... you will then have a hard copy for future reference
(Bonzodog29 is an unemployed sponge of the worst kind, Tue 5 Aug 2014, 14:40, Reply)

I hadn't!
GOOD IDEA
( sporters I’m sincerely gratitude to you, Tue 5 Aug 2014, 14:41, Reply)

Just use "imp" then
duh.

EDIT: Or google "how to copy an oracle database to another machine"
( The Light in Chains don't touch the Pope's boner, Tue 5 Aug 2014, 14:44, Reply)

Didn't work

( sporters I’m sincerely gratitude to you, Tue 5 Aug 2014, 14:44, Reply)

That's what you want
Just export the schema. Create a blank schema on the empty db and import it.

I say "just" this sounds easy on paper but it's usually marred by oracle being a cunt for no reason.

Nearly every time I try and do something that should work it doesn't due to oracle being a prick.
( Slippery Mick ‏, Tue 5 Aug 2014, 14:44, Reply)

My God. These rants make sense to me now Im practically IT myself :(

( GeordieJay Bummers are deaf, Tue 5 Aug 2014, 14:48, Reply)

Being it is easy really.
Just refuse to do anything and mumble things about 'security' or 'performance'.
( Slippery Mick ‏, Tue 5 Aug 2014, 14:49, Reply)

Right click, copy...

( Kroney, Tue 5 Aug 2014, 14:37, Reply)