Hi,
I want to clone my existing oracle database structure without data including packages, users, tablespaces etc. I read some methods but they all copied data as well. Is there anyway out in order to do this?
Thanks in advance.
A:
Try Oracle Export command with ROWS=N
exp SCOTT/TIGER ROWS=N TRIGGERS=N
shiki
2010-08-05 09:15:20
-1: Why triggers excluded? How you deal with tablespaces and users? How to import data?
ThinkJet
2010-08-05 12:57:32
A full database export (FULL = Y, ROWS = N) will export definitions of all database items, including tablespaces and users, but no data. A similar export with ROWS = Y will include all of the data.
Adam Musch
2010-08-05 14:05:00
A:
Use SQL Developer > Tools > Database Export..
On "Specify Data" do not include any tables.
Omit packages etc here,
Fine tune your selection here,
My trial export has not finished yet but I expect this will work.
Janek Bogucki
2010-08-05 10:08:54
-1 SQL Developer can't export/import information about tablespaces and users as specified in question.
ThinkJet
2010-08-05 13:00:45
+2
A:
Use Oracle exp.exe utility for export. E.g.
EXP.EXE login/password@TNSNAME file=entire_db.dmp owner=(scott, my_user, user2) rows=n grants=y triggers=y
Only rows=n option in command above make sense for your task.
You can import to target database with imp.exe utility.
Look for detailed option list and definition by running this utilities with help=y option.
BUT tablespaces and users on target databases must be created manually before running import. There are no standard tablespace cloning tools (including SQL Developer), but some queries exists for generating such cloning scripts. Examples can be found here and here.
P.S. This question better fits to ServerFault than to StackOverflow ...
ThinkJet
2010-08-05 12:53:27