b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 2340094 | Search
This is a question Off Topic

Are you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.

(, Sun 1 Apr 2001, 1:00)
Pages: Latest, 836, 835, 834, 833, 832, ... 1

« Go Back | See The Full Thread

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
(, Tue 5 Aug 2014, 14:30, 3 replies, latest was 10 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.
(, 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.
(, Tue 5 Aug 2014, 14:37, Reply)
Its the something something bit I'm having trouble with
An existing empty DB is there
(, 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
(, Tue 5 Aug 2014, 14:40, Reply)
I hadn't!
GOOD IDEA
(, Tue 5 Aug 2014, 14:41, Reply)
Just use "imp" then
duh.

EDIT: Or google "how to copy an oracle database to another machine"
(, Tue 5 Aug 2014, 14:44, Reply)
Didn't work

(, 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.
(, Tue 5 Aug 2014, 14:44, Reply)
My God. These rants make sense to me now Im practically IT myself :(

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

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

« Go Back | See The Full Thread

Pages: Latest, 836, 835, 834, 833, 832, ... 1