Home » RDBMS Server » Server Utilities » import whole database (import whole database)
import whole database [message #275715] Mon, 22 October 2007 08:44 Go to next message
allahmorad
Messages: 18
Registered: June 2006
Junior Member
Hi,

I have one query!! In office when ever i user to get a dump file from a client, firstly i use to create a blank database and use to check that whether all the tabblespace has been created with the same name of those in source. if i forget any tablespace for example "perfstat" and start import then i get error "tablespace perfatat doesnot exist" ......" import terminated unsuccessfully" .

but my friend has:
1 made a database
2 added a tablespace let say "test" to it
3 created a table on this tablesspace.
4 took full export to a dumpfile
5 delete tablespace test
6 import dumpfile of step 4 on the same database.

now the tablespace test is created automatically. and import terminates succefully.

can u explain?
Re: import whole database [message #275718 is a reply to message #275715] Mon, 22 October 2007 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tablespace creation statements are included in full export.

Regards
Michel
Re: import whole database [message #275852 is a reply to message #275715] Tue, 23 October 2007 01:11 Go to previous messageGo to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
Hi,

Try <<< FULL='Y' >> when exporting your user's schema.

Regards,
Re: import whole database [message #275858 is a reply to message #275852] Tue, 23 October 2007 01:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Muhammad Ahmad wrote on Tue, 23 October 2007 12:11

Hi,

Try <<< FULL='Y' >> when exporting your user's schema.

Regards,


!!!
Quote:

exporting your user's schema

Quote:

FULL='Y'

How you can include multiple job mode? Either you have to include schema or full not both.
Re: import whole database [message #275923 is a reply to message #275858] Tue, 23 October 2007 06:49 Go to previous messageGo to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
hi Arju,

you are absolutely right.

hi allahmorad,

this is for you:

exp username/password@service_name full=y direct=y log=logfilename

try it!

Note: the username given above must have dba role assigned.

Regards,
Re: import whole database [message #276093 is a reply to message #275715] Tue, 23 October 2007 23:00 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:


Note: the username given above must have dba role assigned.


Not mandatory.

EXP_FULL_DATABASE and IMP_FULL_DATABASE roles are there.
Previous Topic: ORA-03135: connection lost contact
Next Topic: Oracle errors on import
Goto Forum:
  


Current Time: Thu Dec 08 00:22:31 CST 2016

Total time taken to generate the page: 0.16034 seconds