| export rows and indexes... [message #156157] |
Mon, 23 January 2006 03:32  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
1.Is it possible to export a limited number of rows from a table?
2.Try to move several indexes from one tablespaces to another using export and import.
can anyone give the solution for above doubts ?i searched in many sites. but i cannot get clear solution ..
|
|
|
|
| Re: export rows and indexes... [message #156160 is a reply to message #156157] |
Mon, 23 January 2006 03:56  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
On what criteria are you defining the number of rows?
You can use a where clause like this , along with a condition.
If you are using ROWNUM as show, use an order by.
oracle@mutation#count mutation scott.emp
Table:scott.emp
COUNT(*)
----------
458752
oracle@mutation#exp scott/tiger Tables=EMP QUERY=\"WHERE rownum \< 100 order by empno\"
Export: Release 9.2.0.4.0 - Production on Mon Jan 23 04:46:12 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table EMP 99 rows exported
Export terminated successfully without warnings.
>>2.Try to move several indexes from one tablespaces to another using export and import.
you can just import with rows=n indexes=y.
You must have defined the user to have a different target tablespace as default tablespace and user should not be having a resource role granted.
Else
generate ddl using indexfile option or dbms_metadata
[Updated on: Mon, 23 January 2006 04:11] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
