| import whole database [message #275715] |
Mon, 22 October 2007 08:44  |
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 #275923 is a reply to message #275858] |
Tue, 23 October 2007 06:49  |
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,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
