wawawa

To transfer everything from an old user to a new user in Oracle without manually specifying each table name, you can use Oracle's Data Pump export and import utilities (`expdp` and `impdp`). These utilities allow you to export and import entire schemas, which include tables, views, procedures, and other schema objects, without the need to list each object individually.

Here's a general outline of the steps:

1. **Export the Entire Schema**: Use Data Pump's `expdp` utility to export the entire schema of the old user. This can be done using a command like:

   ```shell
   expdp old_user/password@db DIRECTORY=your_directory DUMPFILE=old_user.dmp SCHEMAS=old_user
   ```

   - Replace `old_user`, `password`, and `db` with the old user's credentials and database.
   - `DIRECTORY` should be an Oracle directory object that points to a physical directory on the server.
   - `DUMPFILE` is the name of the file that will be created.

2. **Create the New User**: If the new user doesn't already exist, create it in the Oracle database.

   ```sql
   CREATE USER new_user IDENTIFIED BY new_password;
   GRANT CONNECT, RESOURCE TO new_user;
   ```

3. **Import the Schema into the New User**: Use Data Pump's `impdp` utility to import the dump file into the new user's schema.

   ```shell
   impdp new_user/new_password@db DIRECTORY=your_directory DUMPFILE=old_user.dmp REMAP_SCHEMA=old_user:new_user
   ```

   - `REMAP_SCHEMA` option remaps the old user to the new user.

4. **Verify and Correct Any Issues**: After the import, you should verify that all objects have been transferred correctly and rectify any issues that might arise.

5. **Recompile Invalid Objects**: Sometimes, after import, some objects might be invalid. Use the following command to recompile invalid objects:

   ```sql
   EXEC DBMS_UTILITY.compile_schema(schema => 'new_user');
   ```

6. **Transfer Additional Privileges**: If the old user had specific privileges or roles granted, you would need to grant these to the new user manually.

This process should transfer most of the schema-related objects. However, remember that certain database-specific settings or roles outside the schema level won't be transferred and must be handled separately. Also, ensure you have proper backups before performing such operations.