haha!
I wish my job was as simple as that. Know anything about Oracle? Neither do I
( sporters I’m sincerely gratitude to you, Tue 5 Aug 2014, 14:23, 6 replies, latest was 10 years ago)

Yeah he was the little wizard chap in He-Man

(Bonzodog29 is an unemployed sponge of the worst kind, Tue 5 Aug 2014, 14:24, Reply)

Christ, no.
That end of the trade looks deathly boring.
( Kroney, Tue 5 Aug 2014, 14:25, Reply)

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, Reply)

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)

More of a Ceefax man myself.

( JeffTheDogFucker Can you dig it?, Tue 5 Aug 2014, 14:25, Reply)

Gramophone lover.

(DBT became a fruitarian on, Tue 5 Aug 2014, 14:27, Reply)

Have you got an answer to the crisps question yet

( JeffTheDogFucker Can you dig it?, Tue 5 Aug 2014, 14:28, Reply)

Yes, pubs rotate stock on Fridays.

(DBT became a fruitarian on, Tue 5 Aug 2014, 14:41, Reply)

Is this one of your incorrectly labelled 'ironic' replies?

( MEATSNAKE Richard Hammond, Tue 5 Aug 2014, 14:45, Reply)

No I googled it.

(DBT became a fruitarian on, Tue 5 Aug 2014, 14:50, Reply)

You managed to do that wrong too.

( MEATSNAKE Richard Hammond, Tue 5 Aug 2014, 14:56, Reply)

?

(DBT became a fruitarian on, Tue 5 Aug 2014, 15:02, Reply)

Crisps get made in a factory that normally runs Monday to Friday. As the expiry date is so far in the future, crisps manufactured in the same week probably have the same date. And manufacturers would then push it back seven days every week. It's the same as saying "Week ending".
(Set your faces to Stunned Bigly, Tue 5 Aug 2014, 15:07, Reply)

What stunned poster said

( MEATSNAKE Richard Hammond, Tue 5 Aug 2014, 15:11, Reply)

THAT's how you use Google.

(Set your faces to Stunned Bigly, Tue 5 Aug 2014, 15:13, Reply)

ALL DAY BABY

( MEATSNAKE Richard Hammond, Tue 5 Aug 2014, 15:14, Reply)

You can still go on teletext holidays.
They're just online now.
( GeordieJay Bummers are deaf, Tue 5 Aug 2014, 14:28, Reply)

You get your holidays from collecting vouchers in The Sun.

( JeffTheDogFucker Can you dig it?, Tue 5 Aug 2014, 14:29, Reply)

Sun Pink
(Reverend Fister "a disciplined fuckwit", Tue 5 Aug 2014, 14:53, Reply)

she was in The Matrix

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

There is a fucking spoon!

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

I do! But not nearly as much as I need to.

( The Light in Chains don't touch the Pope's boner, Tue 5 Aug 2014, 14:30, Reply)

I know I fucking HATE Oracle.

( Slippery Mick ‏, Tue 5 Aug 2014, 14:44, Reply)

Oh and if you're running low on space do NOT delete the redo logs with the database running.
It doesn't like that very much.
( Slippery Mick ‏, Tue 5 Aug 2014, 14:47, Reply)