|
|
| Squilibrio 2005-10-11, 7:26 am |
| Hi, I've installed Oracle (with orcl db)
Now I would like to install a new db (that I have in a dmp file)
How Can I do this???
Thanks
| |
| sybrandb@yahoo.com 2005-10-12, 11:24 am |
| No version, no platform.
A dmp file doesn't contain the create database statement, so you would
need to use
the database creation assistant (the executable is called dbca) to
create a database for you. Imp will import the dmp file.
By running imp show=y full=y log=<any filenam>
you will get a file with all sql, including the create tablespace
statements.
You need to incorporate those definitions in your dbca session, or
convert them to proper sql and run them right after dabase creation.
--
Sybrand Bakker
Senior Oracle DBA
| |
| Vilco 2005-10-12, 11:24 am |
| Mi e' parso che sybrandb@yahoo.com abbia scritto:
> No version, no platform.
> A dmp file doesn't contain the create database statement,
> so you would need to use the database creation assistant
Are you sure? I did some recovery of dumpfiles (DMP) by simply
creating a new user/schema from management console and then
running IMP.EXE to get the tables in the new schema, without any
database creation assistant.
--
Vilco
Think Pink , Drink Rose'
| |
| IANAL_VISTA 2005-10-12, 11:24 am |
| "Vilco" <a@b.invalid> wrote in
news:s653f.8999$Pe2.189433@twister2.libero.it:
> Mi e' parso che sybrandb@yahoo.com abbia scritto:
>
>
> Are you sure? I did some recovery of dumpfiles (DMP) by simply
> creating a new user/schema from management console and then
> running IMP.EXE to get the tables in the new schema, without any
> database creation assistant.
What happens if all you have is a *dmp file & NO functioning DB?
What must be done before running imp?
| |
| Squilibrio 2005-10-17, 1:25 pm |
| How Can I import it... for example with toad???
| |
| Sybrand Bakker 2005-10-17, 1:25 pm |
| On Wed, 12 Oct 2005 21:33:01 +0200, Squilibrio <aa@aa.it> wrote:
>How Can I import it... for example with toad???
This can't be a serious question.
You need to set up a database (as explained before) using dbca
and you need to import your dmp using imp. (as explained before)
If you can't do that, you either need to read the manual, or to hire a
consultant to hold your hand, or do your work for you.
--
Sybrand Bakker, Senior Oracle DBA
| |
| Squilibrio 2005-10-17, 1:25 pm |
| I haven't know if I must to use the Orcl DB or I must to create another db
| |
| Sybrand Bakker 2005-10-17, 1:25 pm |
| On Thu, 13 Oct 2005 00:12:41 +0200, Squilibrio <aa@aa.it> wrote:
>I haven't know if I must to use the Orcl DB or I must to create another db
Depends on what is in the dmp. If you don't create a database, you are
potentially merging your dmp with an exisiting database.
I really can't answer that question for you, as I don't know what is
in the dmp.
--
Sybrand Bakker, Senior Oracle DBA
| |
|
| Mi e' parso che IANAL_VISTA abbia scritto:
[color=darkred]
> What happens if all you have is a *dmp file & NO
> functioning DB? What must be done before running imp?
Oracle 9i installation created a DB (ORCL in my case).
--
Vilco
Think Pink , Drink Rose'
| |
| Turkbear 2005-10-17, 1:26 pm |
| "Vilco" <a@b.invalid> wrote:
>Mi e' parso che sybrandb@yahoo.com abbia scritto:
>
>
>Are you sure? I did some recovery of dumpfiles (DMP) by simply
>creating a new user/schema from management console and then
>running IMP.EXE to get the tables in the new schema, without any
>database creation assistant.
Do not confuse a schema with a database ( that's SqlServer speak),,
You obviously had a database - else what did you import into?
|
|
|
|