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, 1 reply, 11 years ago)

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)