- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Do you have to precreate data files when doing a full import?
I am doing a database upgrade from oracle 8.0.4 to oracle 8.1.7 using the full export and import method. I have already precreated the tablespaces on the new database. I was wondering do I also have to precreate the exact datafile names in the new database as well and allocate the storage size of the new datafiles before I do the full import?
Here is what I did in the test system that worked!
The test system I precreated the tablespaces and datafiles but notice that the import messages was sending warnings that they already exist as if it was going to create them for me. If this is the case I think it might be safe to asumme that I didnt need to precreate them before the full import. But I am not sure if that is going to work still.