oracle| Data | statement
How do I view a table statement for an oracle datasheet?
System environment:
1, operating system: Windows 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 option
3. View and edit log files
Concrete Examples:
1, pull 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, the first to perform 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 partitioning option
Jserver Release 8.1.6.0.0-production
Exported ZHS16GBK character set and ZHS16GBK NCHAR character set
. Exporting Pre-schema process objects and actions
. Exporting external function library name for User A
. Exporting object type definition for User A
About to export the object of a ...
. Exporting database Links
. Exporting ordinal
. Exporting cluster definitions
. The table to export a is going through the general path ...
. . Exporting table A 3 row is exported
. . Exporting table B 3 rows are exported
. Exporting synonyms
. Exporting views
. Process of exporting storage
. Exporting operators
. Exporting referential integrity constraints
. Exporting triggers
. Exporting index types
. Exporting bitmaps, functional indexes, and extensible indexes
. Exporting late table activity
. Exporting snapshots
. Exporting snapshot logs
. Exporting job queues
. Exporting refresh groups and subgroups
. Exporting dimension
. Exporting Post-Schema process objects and actions
. Exporting statistics
Successfully terminates the export without warning.
E:\>
3, then perform the import, using 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-production
With the partitioning option
Jserver Release 8.1.6.0.0-production
To export a file created by export:v08.01.06 through a regular path
Import in the ZHS16GBK character set and ZHS16GBK NCHAR character set has been completed
. Importing object A to a
"CREATE TABLE" a "(" a "number) PCTFREE pctused Initrans 1 Maxtrans 25"
"5 LOGGING STORAGE (INITIAL 131072 NEXT 65536 minextents 1 maxextents 2147483"
"645 pctincrease freelists 1 freelist GROUPS 1 buffer_pool DEFAULT) TABLE"
"Space" SYSTEM ""
. . Skipping table "A"
"CREATE TABLE" B "(" A "number," B "VARCHAR2 ()) PCTFREE pctused INIT"
"RANS 1 Maxtrans 255 LOGGING STORAGE (INITIAL 131072 NEXT 65536 minextents 1"
"Maxextents 2147483645 pctincrease freelists 1 freelist GROUPS 1 buffer_p"
"Ool DEFAULT" tablespace "SYSTEM"
. . Skipping table "B"
The import was successfully terminated, but a warning appears.
E:\>
4, using the editor to open Logb.txt, you can see the DDL statement