tags:

views:

122

answers:

1
Q: 

Oracle: Export & Dump file only creates tables, no data

I have in Oracle Exports a schema with 100 tables database size 30 GB. The dump file Size is 2 mb.

When I import the dump file (2 mb) into a new database, all the tables are empty but the user tablespace is 30 GB although all tables are empty?

A: 

It is highly unlikely that the 30GB database was exported into a 2 mb file with data. It must have been exported with rows=n parameter. Hence when you import it, the tables are empty

Dinesh Bhat  2009-12-10 03:43:37

related questions

Using the results of a query in OPENQUERY
Search all tables in Oracle DB
Insufficient privileges when creating a trigger for a table in another schema
rebuild indexes oracle 10G
oracle 10G shrink datafiles
How do I limit the global memory resources of Oracle 10g database
Getting Hourly statistics using SQL
Problems importing SQL script from Oracle 9i to Oracle 10g express
Can someone explain oracle 10G encoding, nls_lang unicode
Is it possible to output a SELECT state from a PL/SQL block?
Null Pointer when populating Grails Domain object with Oracle 10g long field
Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC
Why does Oracle require TO_NCHAR when binding SQL_C_WCHAR text via ODBC
ORACLE SQL: Need to sum two values, but one may not exist... Is this possible?
How do you programatically identify a stored procedure's dependencies?
How do I find out when a stored procedure was last modified or compiled?
ORACLE SQL: Multiple SUMS dependent on CODE in One Statement
How to read the PL/SQL code in an Oracle Forms .FMT file ?
How do I use oracle.jdbc.driver.OracleLog?
Table load via Partition Exchange (Oracle 10g)
"loader constraints violated when linking javax/xml/namespace/QName class" from webapp on Oracle 10g
JAXB 2 in an Oracle 10g Webapp
How do I change the IP address on Oracle 10g
How do I do a manual uninstall of Oracle?
Backup/Restore database for oracle 10g testing using sqlplus or rman