Database export - import
I am trying to export database from one webhost to another. I am not getting the full table and views structure. The import happens but it seems the schema is incorrect. I cannot see the grouped Tables & Views. The steps that I have followed are as follows:-
Export
1. Select the source database
2. Click Export
3. Save the .SQL file
Screnshots (Export) -
https://prnt.sc/mWrEZ60N_8Ue
Import
1. Created the target blank database
2. Click Import
3. Choose the .SQL file
There seems to be an error but the import happens nonetheless. The imported DB is without the grouped Tables & Views.
Screenshots (Import) -
https://prnt.sc/hYM9RpzQxau1
What am I doing wrong? Thank you for any help.
- Deb
Subject
Written By
Posted
Database export - import
July 09, 2024 10:07PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.