How to export an Oracle database from a server to a local Oracle Database: oracle Database

How to export an Oracle database from a server to a local Oracle Database: oracle Database
1. Import the Oracle database on the server to the local

Run the following command in CMD mode:
Exp username1/password @ Server database file = Local Hard Disk:/file name. dmp
Example: exp admin/123123 @ DB file = e: db. dmp

2. Create a local database (the Oracle client is installed by default and the local database is created)

3. Create a new user and grant the DBA permission
// Create a user named test with a password of 123456. The default tablespace is users, and the user's users tablespace is unrestricted.
Create user test identified by 123456
Default tablespace users
Quota unlimited on users
// Grant the DBA permission to the test user
Grant dba to test;

4. import data to the local Oracle Database
Run the following command in CMD mode:
Imp username2/password file = Local Hard Disk:/file name. dmp fromuser = username1 touser = username2 ignore = y
For example: imp test/123456 file = e: db. dmp fromuser = admin touser = test ignore = y