| database from an export [message #150498] |
Thu, 08 December 2005 03:33  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
i installed oracle 9i server on win xp, didnt create any database,
my question if i import and exported database , it will create the database on my new server with init.ora file, datafile, control file...
or shall i create all of that prior to the import
thankd for your kind help
|
|
|
|
| Re: database from an export [message #150541 is a reply to message #150498] |
Thu, 08 December 2005 06:10  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
import is logical.
Not physical.
the syntax for import is
imp username/password@targetdb
If there is NO targetDB ( the database you want to import into), where are you importing into?
And there is NO user to which the import is done or under the authority of a DBA user in which import is done!!.
Precreate the database and do import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
