Oracle startup
1. Start the database (Oracle 9i ):
> Sqlplus/nolog
> Connect/As sysdba
> Startup
> Quit
> LSNRCTL
> Start
Quit
2. Close the database (Oracle 9i ):
The premise is that the user connection is closed.
> Sqlplus/nolog
> Connect sys/passwd as sysdba
> Shutdown immediate
> Shutdown immediate
PL/SQL:
String connection "|", for example, update student set email = studentno | '@ doit.net.cn' Where studentno = '000000 ';
3. Modify the sysdba password:
Sqlplus/nolog
> Conn as sysdba
> Alter user SYS identified by nosmoking
4. Export Database files:
> Exp test/test@test_192.168.0.1
Export File: Test. dmp
...
5. Import database files:
> Imp
> User: Test
> Password: Test
Import file: Test. dmp
...
(If you want to import 9i database content to 8i database, you can use the 8i client to export 9i database files? *. DMP, and then import the DMP file to the 8i database)
Change Time in Oracle
Update ksxx t set T. csny = to_date ('1970-1-1 0:0', 'yyyy-mm-dd hh24: MI: ss') where 1 = 1;