Oracle²Ù×÷ÃüÁî(sqlplus)
1.Êý¾Ý¿â£¬±í£¬Óû§µÈ³É¹¦µ¼³ö
¢Ùµ¼³öÕû¸öÊý¾Ý¿â
exp Óû§Ãû/ÃÜÂë@Ö÷»úµØÖ· full = y file= ×××.dmp
¢Úµ¼³öÌض¨µÄ±í
exp Óû§Ãû/ÃÜÂë@Ö÷»úµØÖ· tables=±íÃû£¬±íÃû… file= ×××.dmp
¢Ûµ¼³öÌض¨Óû§
expÓû§Ãû/ÃÜÂë@Ö÷»úµØÖ· owner=Óû§ file= ×××.dmp
2.Êý¾Ý¿â£¬±í£¬Óû§µÈ³É¹¦µ¼Èë
¢Ùµ¼ÈëÕû¸öÊý¾Ý¿â
imp Óû§Ãû/ÃÜÂë@Ö÷»úµØÖ· fully = y file= ×××.dmp
Ïà¹ØÎĵµ£º
package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.p ......
SELECT a.ADDRESS,
sql_text,
executions,
rows_processed,
cpu_time,
a.DISK_READS,
  ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php
//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒ ......