Creation of an empty BD to receive an exp

[flaviademorais]

Hello everyone,

before opening this topic, I researched and a lot, but I did not find anything that satisfied my doubt ... or better need =)
is the following:
I am a dba sqlserver and by the necessity of the company, I need to learn Oracle, which I confess to have a lot of desire to learn and dominate ... So many concepts I understand, but Oracle is much more complicated even more for him to rotate in an environment Linux and also do not Domino Linux ...

Well, already has a few months that I study the two and I would help me in an urgency ... I need to create an "empty" database I do not know if it is possible, to play an EXP Full I made of the production bank. My question is if I can create this bank, no structure, on the server we use for tests that has the same production structure (Oracle 10G in Linux RedHat environment), and just play the exp I did ... I'vê read in several Places on creation, but all as if I were to create the bank of zero and its structure, but I just wanted a bank created as simple as possible. The bank I want to create is a faithful copy of production.
I would like to know if there is any command or tool that gives to extract the creation script of an object / bank, since the bank that I will create is a faithful copy of the other, it would also help ... I use The PL / SQL to manipulate the data.

Thanks for the attention, and I hope you help me, I think you could understand what I want right ???

Hugs ...

Environment information: Oracle 10g running in Linux environment
* Oracle version: 10g
* Operating system: Linux RedHat

[burga]

Yes You can run Dump Import in an "empty" bank the only need if you have used the EX command is that users (schemes) and tablespaces (with the same name of the base tablespaces that was held the export) You must already be created before rotating the IMP command.

If you have exported using DataPump, the creation of users is no longer required ...

[flaviademorais]

Yeah,

My question is precisely how to create this bank as simple as possible, if I use a creation database or do not need ... type create a whole default, what is datapump? How can I know the utility? I used the conventional exp EXP ...

Thanks

[diegolenhardt]

To create a database, I advise using the DBCA utility, so you will need graphical interface in Linux,

there you create a bank,

Uses the IMP to import your bank exported by the exp,

DataPump is an improved EPP, more efficient at some points, mainly speed,
is posting their you doubt..

[flaviademorais]

Aeeeeee

Thanks to both, you gave me a light hehehe what I needed to unfold ...
is the following ...
I installed the DBCA in the Linux and even without a graphic environment ...
I was able to access it graphically, using the VNC Viewer (remote access) ... I put the IP and the port that was installed the DBCA and it opens the command screen In the VNC environment, then just type on the "DBCA" command screen and open the tool graphically, I'm hyper mega ultra happy ... now I'll try to use and create the bank ...

Guys, if you think interesting I can post step by step as I did, maybe serve of help ...

Thanks

[diegolenhardt]

I find it interesting you run a select in the production bank to see which resources they use,

XML, Java, Spatial, etc.



DBCA will ask you what features you want to add to the bank,

=]

Another thing, select the personalized bank option, with the DBCA will have to create tablespaces also

dba_tablespaces

[flaviademorais]

Hi Diego,

Does not he bring the tablespaces on the bank exp?
How do I import by DBCA?

=)

Thanks

[diegolenhardt]

DBCA - Database Configuration Assiste, serves to create, edit, exclude,

Exp - Utilitario to export schemas,

Imp - UPP - Utility for example of schemas,

When you use the EXP / IMP you must create the tablespaces and owners, (Users), Create User ...

The tablespaces you can create já By DBCA,

I hope I have helped

I sent a private message with my MSN, suddenly easier to assist,

[pedroedu]

It makes a cold abackup, restores on another machine with the same structure, arrow to SID and Starta the bank.

I hope I have helped.

[annubiss]

I did this with SSH connection, without using VNC ...

[Bardelli]

Flavia, I find myself in the same situation .. Creating an empty bank to make an import.

Could you send the step by step?


I'll send you my e-mail by MP, or if you prefer post here maybe help more people.

Thank you

[elidias7]

Good morning people.

This story of creating an empty bank is somewhat complicated, as it is complicated to know what the needs of this new bank are!

But to carry out the bank and soon after importing the data I think can be done in this way

1 - Create the bank via DBCA in the best way or as simple as possible.

2 - In the production bank or where export was done try to run these query's to obtain the user and tablespaces created


Note -> The file_name value will have to be changed as needed your new server (new file path) and must be placed in simple quotation marks

Select all

 
select  
'create user '||username||' identified by values '||password|| 
' default tablespace '||DEFAULT_TABLESPACE|| 
' temporary tablespace '||TEMPORARY_TABLESPACE|| 
' profile '||PROFILE|| 
' account status '||ACCOUNT_STATUS||';' 
from dba_users; 

[[99 ]
Note -> The password field will need simple quotation marks as well

with this you will have tablespaces and users to be created in the "empty" bank before performing the Import.
Any novelty post and to help!

Hugs

[Bardelli]

Good Morning!

I do not know if I understand correctly:

The first code is "rotated" in the production machine and the second code in which will receive the import?

Thanks for the attention!

[diegolenhardt]

Yes, for information from the current environment, up there is also in DBA_Registry to see the resources, XML, Spatial, etc.

You need to create the tablespaces and users manually, the Select posted will already generate all these commands, just run it in the production bank today, it will give the commands to rotate in the new, after that you can start trying to load the EXP.