Export and Import (Database)

[klebergomes]

Environment information:
* Oracle version: 10g
* Operating system: Windows

I am in need of the syntaxes regarding the export and import process of a Dice.

[Dulima-SP]

Oo my shaft follows
http://www.google.com.br

[dr_gori]

Well then:
usually we give answers here in the forum and not just suggest Google. But as the question was Mega wide, this is certainly the most indicated answer: Google

If you have any more specific questions about the import / export process, send us. The answer to your question can not answer in a post ... read Oracle's documents about it, and then if I have something, send it here!

: -O

[ricardofazu]

If you help:

Select all

exp sys/senha sys@banco owner file=/pasta para guardar o dump.

has a few more command that can be immedious the above lines, if necessary, post there for WE OK?

[diegolenhardt]

You can also search for Oracle DataPump,

if the database is large, uses DataPump ...

[ruibarros]

Select all

exp help=y 
imp help=y

[schnu]

Personnel

Operating system: Win 2008
Database: Oracle 10g


Next, I have a bank installed and working and I want to make a full backup of it and import on another machine with the same Win 2008 configuration and Oracle 10g

but when I used the EXP and IMP he did not create the Users I have and also the Tablespace error . Are there any exp to export everything? I say, Tablespace, Bank users, Grant, Public Synonym !!! I wanted to make a total copy of the bank !!!

Value

[diegolenhardt]

You can use RMAN,