| file structure [message #70808] |
Fri, 26 July 2002 01:42  |
Jayachandra
Messages: 5
Registered: July 2002
|
Junior Member |
|
|
|
If performing full export from oracle8i and importing it into oracle9i databse,Is it must to have the file structure to be same i mean the datafile location and name,its size,number of datafiles in oracle8i?
|
|
|
|
| Re: file structure [message #70814 is a reply to message #70808] |
Fri, 26 July 2002 12:21  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
The file names do not matter. The tablespace name needs to be the same. The size doesn't have to match but must be enough to hold the data.
Pre-create the tablespaces with the correct names and import using ignore=Y
|
|
|
|
| Re: file structure [message #70826 is a reply to message #70808] |
Mon, 29 July 2002 00:54 |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
|
no, this is not necessary that file structure to be same in oracle8i, because the export utilties creates tablespace, datafiles automatically and use the parameter IGNORE=Y for no error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
