today:
286
yesterday:
456
Total:
1,015,612

SQL Developer Password change / EXPORT & IMPORT

admin 2022.03.18 15:44 Views : 163

sqlplus system/password as sysdba

SQL>  ALTER USER GPUSA IDENTIFIED BY gp9191 ACCOUNT UNLOCK;

 

exp file=c:gpusa_0323.dmp owner=gpusa compress =y

imp file=c:gpusa_0323.dmp fromuser=gpusa touser=gpusa ignore=y commit=y

 

I want to
List
No. Subject Author Date Views
66 Column Data 일괄 추가 admin 2023.11.24 168
65 SQL SELECT DISTINCT Statement admin 2016.04.29 169
64 JAVA for delete admin 2016.04.28 173
63 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 174
62 DELETE PROCESS admin 2016.04.28 176
61 UPDATE PROCESS admin 2016.04.28 177
60 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 177
59 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 178
58 EXPORT & IMPORT admin 2016.05.01 181
57 CREATE TABLESPACE admin 2016.04.28 187
56 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 187
55 Captcha Test file admin 2016.04.18 189
54 Apex setup procedure admin 2016.04.28 191
53 TABLE PRINT admin 2018.06.18 201
52 How to convert DATE to NUMBER admin 2018.05.27 207
51 Name Show admin 2016.04.28 213
50 MISSIONARY_SUB admin 2018.06.25 213
49 All Data DELETE from Table admin 2018.05.10 218
48 IF/ELSE ... CASE WHEN admin 2018.06.25 218
47 use a validation function for an element in apex 5.0 admin 2018.05.19 221
Write Tag