PLSQL Developer imports SQL files to Oracle

PLSQL Developer imports an SQL file to Oracle. open PLSQL Developer. The logon window is displayed. The Username, password, and Database are set when Oracle is installed. The default Username is sys, the default Database is ORCL, And the Connect as option is SYSDBA. 2. after successful login, select New --> SQL Window 3 in the upper-left corner. first, Create a temporary tablespace named test_temp. The Code is as follows: Create temporary tablespace test_tempTempfile 'e: \ tablespace \ test_test.dbf 'size 100 MAutoextend onNext 100 M maxsize 200 Mexico tent management local; select all the code and click the gear button on the top left to execute the code. 4. create another formal tablespace, assuming the name is test_data. The Code is as follows: Create tablespace test_dataloggingdatafile 'e: \ tablespace \ test_data.dbf' Size 100 MAutoextend onNext 100 M maxsize 200 MExtent management local; select all the code and click the gear button on the top left to execute the code. 5. create a user who can operate the test tablespace. Assume that the user name is crytoll and the password is superoracle. The Code is as follows: Create user crytoll identified superoracleDefault tablespace test_dataTemporary tablespace test_temp; then select all the code, click the gear button on the top left to execute the task. 6. grant the database connection permission to crytoll. The Code is as follows: GrantConnect, resource, create session, create any table, create any view, alter any table, drop any table, Drop any view, select any table, insert any table, update any table, delete any tableTo crytoll; then select all the code and click the gear button on the top left to execute the code. 7. Click the key button in the upper-left corner to Log On As crytoll. 8. click File --> open --> SQL Script to import the existing SQL File. It is displayed as code in the SQL window. Select all the files and click the gear button on the top left to execute the SQL Script.