Home » RDBMS Server » Server Administration » how to import data with no Rows? Thanks
how to import data with no Rows? Thanks [message #56820] Mon, 28 April 2003 16:21 Go to next message
fengq
Messages: 38
Registered: October 2002
Member
Thank You for your replies!

Report message to a moderator

Re: how to import data with no Rows? Thanks [message #56823 is a reply to message #56820] Mon, 28 April 2003 23:51 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You cannot import data with no rows, since the rows have data into. The data is stored in rows.

If you mean to import database tables without the rows, you have to create a dump file which doesn't have any rows. As with ROWS=N parameter in the export parameter file.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: how to import data with no Rows? Thanks [message #56836 is a reply to message #56820] Tue, 29 April 2003 13:49 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hello,
use the below approach

Exp User/password tables=(list) rows=N
or while importing use Rows=N

sai

Report message to a moderator

Previous Topic: need help starting LogMiner utility
Next Topic: Oracle Architecture
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:36:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.