| need help with export/import [message #462719] |
Sat, 26 June 2010 01:54  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Hi friends,
I have a task to export full database from 8.1.7 to import in 10g. My question is,suppose the export was done by some user and i do not have access to that database. Please tell me,how can i find out all the tablespaces from the dump file before running the import process.
Do i need to pre-create all the tablespaces and users before import? Or i can use "ignore=y".
Best Regards,
|
|
|
|
|
|
| Re: need help with export/import [message #462725 is a reply to message #462719] |
Sat, 26 June 2010 03:00  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Hi,
I got to know a way by which import is not done, but only ddl statements are displayed in log file.
imp dba/password full=y show=y log=somefile.log file=somefile.dmp.
This way we can know the tablespaces of database from which we do export.
|
|
|
|
|
|
| Re: need help with export/import [message #462976 is a reply to message #462726] |
Tue, 29 June 2010 01:28 |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Hi,
I have successfully imported database of 8.1.7 to 10g. Do i need to compile all procedures,functions and triggers? Or 10g compiles it automatically.
Best Regards,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
