How to view a table statement for an Oracle datasheet

Source: Internet
Author: User
Tags character set insert log connect reserved resource
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




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.