| exp imp [message #154211] |
Fri, 06 January 2006 04:38  |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
hello i have made a full database export issuing
c:\ exp system/system@orcl database=mydatabase file=c:\dataexp.dmp full = yes
on another server what steps i have to do to import the database,
1-shall i create the tablespace or the import of the datatabse will do so ?
2- what statement shall i use for importing the database to the new server ?
3-shalli create any roles ?
im using win 2000 oracle server9i
thanks in advance for your kind help
|
|
|
|
| Re: exp imp [message #154214 is a reply to message #154211] |
Fri, 06 January 2006 04:46  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
just
imp username/password full=y file=dataexp.dmp
will do but you should have a database with atleast system tablespace.
and i noticed one database=mydatabase parameter in your export command. Well i dont think any parameter like that exist in 9i even 10g doesnt have any parameter like that.
|
|
|
|
| Re: exp imp [message #154229 is a reply to message #154211] |
Fri, 06 January 2006 05:49 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
thx so much for your reply
so i dont have to create the tablespace that was on the old datatabse,the import will do right?
it will also create roles , users ...grant the same privileges to the users ?
thx
|
|
|
|
|
|
|
|
| Re: exp imp [message #154573 is a reply to message #154246] |
Mon, 09 January 2006 08:16 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
hello
i did an import of full database , but i had some errors so it didnt finish successfully
whats the effect of redoing the same import?
it duplicate rows??
thanks
|
|
|
|
|
|
| Re: exp imp [message #154665 is a reply to message #154211] |
Tue, 10 January 2006 01:14 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
well after listing some errors like user dont exist i got the message , 'import terminated successfully with warnings'
and what i know is that import
1-create users
2-create objects
3-grant privs
3-load data
so i shouldnt have errors
how to know if the import is exact as the original database before i shut it down ...and move to the new server
thanks
|
|
|
|
| Re: exp imp [message #154681 is a reply to message #154665] |
Tue, 10 January 2006 03:21 |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
About comparing databases: I know that TOAD offers (under DBA menu) "Compare Databases". However, this TOAD feature is only available in the commercial version of TOAD with the optional Quest DBA Module.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
