Database Administration (MOSC)

MOSC Banner

import file doesn't seen to have a CREATE TABLE statement

edited Nov 19, 2013 5:49AM in Database Administration (MOSC) 7 commentsAnswered
Hello.

I have exported a schema from oracle 11.2.0.3 database via export (data pump has been failing  so I used export as a plan . Now I ran an import into another database (also 11.2.0.3) with show=Y only to see what is in that export file. What I noticed is that for couple of tables I see ALTER and CREATE INDEX and GRANT commands, but I don't see CREATE TABLE

 When I grep my import logfile for that particular name I see something like this

 "GRANT DELETE ON "TABLEXXX" TO "TABLETOAD""
 "GRANT INSERT ON "TABLEXXX" TO "TABLETOAD""
 "GRANT SELECT ON "TABLEXXX" TO "TABLETOAD""

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center