How do I check the formation statement of the Oracle data sheet?
System environment:
1, operating system: Windows 2000 Server, machine memory 128M
2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, installation path: c: / oracle
Implementation steps:
1. Export with EXP tools
2, use the show = y option when importing, log options
3, view, edit log file
Specific example:
1, call up SQL * Plus
Conn System / Manager
Grant Connect, Resource to a Identified by A;
Grant Connect, Resource to B Identified by B;
CONN A / A
CREATE TABLE A (A Number);
INSERT INTO A VALUES (1);
INSERT INTO A VALUES (2);
INSERT INTO A VALUES (3);
Create Table B (a Number, B Varchar2 (10));
INSERT INTO B VALUES (1, '1111');
INSERT INTO B VALUES (2, '2222');
INSERT INTO B VALUES (3, '3333');
COMMIT;
2, open a DOS window, first execute the export
E: /> EXP A / A File = a.dmp log = loga.txt
Export: Release 8.1.6.0.0 - Production on Friday December 1 22:24:16 2000
(c) Copyright 1999 Oracle Corporation. All Rights Reserved.
Connect to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
WITH THE PartInog Option
JServer Release 8.1.6.0.0 - Production
Exported zhs16GBK character set and zHS16GBK NCHAR character set
Export pre-schema process objects and operations
Export User A External Function Library Name
Object type definition being exported from user A
The object to be exported ...
Database link
Detailed serial number
Export cluster definition
The table that is about to export A passes the regular path ...
Export table A 3 lines are exported
Export table B 3 line is exported
Export synonym
Export view
Process that is derived.
Export operator
Exporting reference integrity constraints
Export trigger
Export index type
Export bitmap, functional index, and scalable index
Back table event
Export snapshot
Exporting snapshot logs
Export work queue
Export refresh group and subgroup
Exporting dimension
Export POST-SCHEMA process object and operation
Export statistics
The export is successfully terminated without warning.
E: />
3, execute the import, use show = y, log these two options
E: /> IMP A / A File = a.dmp show = y log = logb.txt
Import: Release 8.1.6.0.0 - Production on Friday December 1 22:29:49 2000
(c) Copyright 1999 Oracle Corporation. All Rights Reserved.
Connect to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith The Partitioning Option
JServer Release 8.1.6.0.0 - Production
Export files created by export: v08.01.06 via a regular path
The import of the zhs16GBK character set and the zhs16gbk nchar character set
Import a object to a
"Create Table" A "(" a "Number) PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 logging storage (Initial 131072 Next 65536 MINEXTENTS 1 MAXEXTENTS 2147483"
"645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 Buffer_Pool Default) TABLE"
"Space" system ""
Skating table "a"
"Create Table" B "(" a "Number," B "varchar2 (10)) PCTFREE 10 PCTUSED 40 INIT"
"Rans 1 MaxTrans 255 Logging Storage (Initial 131072 Next 65536 MineXtents 1"
"MAXEXTENTS 2147483645 PCTIST GROUPS 1 BUFFER_P"
"Ool default" system "" "
.. Skip table "B"
Successfully terminated, but a warning appears.
E: />
4. Use the editor to open logb.txt, you can see the DDL statement
